SharpDevelop Community

Awesome!
Now I can build and run SharpDevelop! Cool! Only 3 warnings! :)

I quickly tested the SQLite connection tool. Seems great! I could view the db schema and even the contents of the db.

There are a few things left though, I understand.
Like seeing the column types.
Also, right-clicking in the Server Explorer did not always produce a context menu. Sometimes it did, sometimes not.
Anyway, I am really glad you made this addition. Thank you very much!

Oh, and if there is one more thing I could wish for it is for a "browse" button when setting the Connection String.

Big thanks!

Carl

Carl

 You can see column types, although it is currently implemented somewhat differently from VS - if you right click on a table in the browser and select 'Describe' it will open a window inside #D with a table showing the column metadata. We are currently discussing how we might make this more consistent with VS2005.

Dickon

Yes, I saw the "Describe" command. However, in the grid that appears, only the first column (named "Column" :) ) has data. The rest of them ("Type", "Length", "Precision", "Scale" and "Nullable") are completely empty.
That MIGHT of course be because of SQLite's very "unstrict" way of applying field types.

Here is an example of a table in a DB that I opened in #D:

CREATE TABLE [Inspection] (

[Date] DATETIME NOT NULL,

[Deleted] BIT NOT NULL DEFAULT 0,

[ID] BIGINT PRIMARY KEY NOT NULL,

[ID_PumpStation] BIGINT NOT NULL,

[Note] VARCHAR(2000));

This is part of a dump from my test db. As you can see, this describes various types of table fields, but in #D, only the field names ("Column") appears. Perhaps the types do not map correctly to what #D expects?

Carl

Carl

 That's a good old fashioned bug - I'll take a look at it - if there a quick fix I'll make it, but given that we are likely to be making some sweeping changes to this anyway if it requires a lot of work I'll defer it to the new version. Hope that's ok

Dickon

 

No worries! :)

Hi, i'm a real beginner, but would like to manage a small Sqlite database using VB.NET and #D

I recently installed #D 3.0 beta but don't know what is "Server Explorer" or even how to install the ADO provider with Sharpdevelop.

Could anyone describe me, step by step hot to achieve it with a small exemple ?

Thanks !

 

 Hi!

I just tried #D 3.0, and I can not find the Server Explorer there either... perhaps it has not been implemented there yet?

 Regards

Carl

Actually, it has been removed because it was incomplete.

Chris

 For SQLite, you can use the SQLite Manager available as an add-on on Firefox.

Works quite great. A lot better than sqlite3.exe command line that causes errors with BLOBs.

 

hope this helped.