SQLite3 text editor using Scintilla

[jdv]

A primitive SQLite editor using Scintilla. Many thanks to Looki for doing lots of excellent work on Scintilla. The app has two known problems - mmf crashes on null values in the SQLite and the auto complete lists has been disable during editing - it also crashes.

[Looki]

Looks cool.
I wasn't able to get anything to work yet, though - Could you give me some short instruction?

I believe that the autocomplete crash is due to WordStart&End... iirc, I had problems with it before.

EDIT: WordStart has been modified to use the caret's position automatically, you're using it wrong! The parameter is an option whether to use word characters only. I might fix that, unless that will make it crash again.

[jdv]

Open any SQLite3 data base. It will retreive the tables and attributes automatically and use that to assist you in creating valid SQL's. You can use F5/F6 to get to the tables and attributes of the opened db.

I'll give the WordStart&End a go...

[Looki]

Ah, I expected that I have to do that... but I thought you'd ship an example databese.

[jdv]

Let me set up an example db - I'll upload when done.

[jdv]

Ok sample db, sample SQL's and some bug fixes :eek:

[jdv]

Looki: Open tst.db then open SQL's test.sql
Select one of the 'SELECT' - lines and Run selected SQL.

If this works fine open the group 'Catch . , and spaces typed by the user'
Run again and type 'select department.' the list of attributes should appear but this is where mine go up in flames.

[Looki]

Ah, really nice.
I'm not that familiar with SQL, especially not with storing databases... I used MySQL in PHP a lot, though.

Autocompletion works fine here That's unhandy since I can't really track down the error...

EDIT: You should consider checking "Two phase drawing" in the Edittime properties so characters don't get cut off when being bold etc.

[Sparckman]

nice... but where are all these extensions? the file cannot be opened... can anyone include the extension in the samples?

[Sparckman]

I can't install this in TGF2..... halp