SQLitening Database Manager Project

[Rolf Brandt]

New Update!

A first version of the SQL Query Builder (see Screenshot) is now included.

Project files are updated in the first message of this thread.

[David Warner]

Hi Rolf,

I just downloaded your update and it generates an error (see attached image).

Regards,

David

[Rolf Brandt]

I'll check it out, David.

[Rolf Brandt]

David,

I just uploaded the file 'SQLMan_project' to the first message in this thread. This has just all the latest project file. It does not include the sample database and the Dlls. Those you have anyway alread in the release folder.

Let me know it this compiles ok. It does here.

[John Montenigro]

Rolf,
This is an amazing experience for me, as I'm re-learning PB and FF. Now I have an SQLitening project to help me. This is a lot to learn, and I hope to help advance the work.

I just ran the Query Builder (QB), and I have a few questions:
1. Should the FIELDS listbox have MULTI-SELECT enabled? Would be easier than having to select each one individually...

2. In building the WHERE clause, I tried ADAPT and 3COM. ADAPT got quoted, 3COM did not.

3. I built this query, but I get no results:
SELECT ROWID AS RECNO, MANUF, PRODUCT, PRICE FROM PARTS WHERE MANUF LIKE 'ADAPT'

Thanks,
-John

ADDED:
Found one of my mistakes:
In SQLitening:
- the multi-character wildcard is not *, but %
- the single character wildcard is not ?, but _

[Rolf Brandt]

Hi John,

1. Multi-Select - I see your point. I had it left to single, so that you  can set the order of the fields like that. But with Multi-Select enabled on could set a couple of fields where the order does not matter so much. I'll change that.

2. I simply differentiated between Numeric and String value using the Val() function. Not a good idea for a value like '3COM'. I think I'll better test for occurrence of literals other than 0-9. Thanks for the hint.

3. I check over the LIKE clause.

[David Warner]

Hi Rolf,

thanks for the update, it compiles ok now.

David

[John Montenigro]

Hi Rolf,

3. SELECT ROWID AS RECNO, MANUF, PRODUCT, PRICE FROM PARTS WHERE MANUF LIKE 'ADAPT%'

I added the % and it's fine.

new: How would I build a query that contains the keyword: UNIQUE (DISTINCT ?)
-jhm

[Rolf Brandt]

Hi John,

I put it on ToDo list for the next couple of days to include those features in it. This version of the QueryBuilder I wrote just this morning, so it is still very simple.

But let me know of any features you think that should be included. I will try to add them.

Rolf

[John Montenigro]

Off the top of my head:

- I think LIKE should have the complement: NOT LIKE

- Seems that the Copy to Clipboard button is not working.

- Should the QuickSQL textbox be disabled until a database is opened?

- Could the SQL Builder save the settings, so that next time I can retrieve them and make changes? Maybe save to the .ini file?

Those are the main things I'm thinking of now.

Rolf, this is really cool! Thanks so much for this contribution to the community!
-John

[Rolf Brandt]

Thanks for your thoughts, John, that is very helpful.

Rolf

[John Montenigro]

I know this isn't perfect, but here's my English menu file:

Code Select Expand


[main]
file=&Database
setcon=Set Connection
setdb=Select Database
connect=Connect to Server
opendb=&Open last used database
quit=&Quit
data=Data
recedit=&Edit record
recadd=&Add record
recdel=&Delete record
tools=&Tools
dbinfo=Database &Information
setlang=Set Language
help=&Help
about=About


I know these will take time, but I offer them anyway:
- For Select Database, there's currently a simple InputBox, and I'm sure that at some future time it will be changed to a full Dialog...

- I think the Main form needs at least this one navigation button: GoToRecord

OK, I'm done for today! Got to get into other work now!
Best regards,
-John

(I have only been tinkering with SQLMan as a user. I have not yet started to explore code, but I expect to start later in the week. I'd like to actually give you code to go along with my suggestions... Soon, I hope!)

[Rolf Brandt]

(I have only been tinkering with SQLMan as a user. I have not yet started to explore code, but I expect to start later in the week. I'd like to actually give you code to go along with my suggestions... Soon, I hope!)

That will be very much appreciated.

Rolf

[Rolf Brandt]

New Update!

v1.0.0.42
Query Builder - Added DESC sorting
Query Builder - Added checkbox for differentiating between string / numeric values
Query Builder - Added % param for LIKE
Query Builder - Added Reset button
Query Builder stays alive after executing query
Main Dialog - Added OpenFileDialog for opening local files
Main Dialog - Added 'Close Connection'
Added Connection Info dialog

Download in first message of thread.

[David Warner]

Hi Rolf,

I get a compilation error with your updated project (see attached image).

Regards,

David