SQLitening Database Manager Project

[Rolf Brandt]

Sorry David,

I think I forgot to update the project file. Just add the frmConnInfo.frm to the project, then things should work.

Meanwhile I'll upload the correct project. Sorry for the inconvenience.

[John Montenigro]

Hey Rolf! I just installed the latest.
 
I played with Query Builder:
- LIKE with the %  works perfectly!
- variations of Numeric, etc. and found no problems. 
And thanks for fixing the "Copy to clipboard button"!

Problem:
1. open a local database (sample.db3)
2. click on "Connect to Server"
3. enter nothing and click OK (Returns Connection Error -16: cannot connect)
    Note that the local database tree is still showing in the left panel.
4. Click on local database tree. (Returns SQLitening unexpected message: -7 No open database.)
Then the app shuts down without further warning.

I don't have more time today or tomorrow, but I'll be back over the weekend. I've started to look through the source code, and I'm understanding what I see, so soon I can be more helpful.

-John

[Rolf Brandt]

Thanks for your observations, John. I'll fix those things.

[David Warner]

Hi Rolf,

Sorry for the inconvenience.

No problem Rolf, I think it's great that you share your efforts here with the rest of us!

Best Regards,

David

[Ivan Iraola]

Rolf,

Check your private messages when you get a chance.

Thanks

[Rolf Brandt]

Update!

v1.0.0.49
Added Form 'Connection Settings' - allows also to test connection
Added Sizing font in grid
Fixed Connection Info dialog

Database Creation will be next.

Download in 1st message of thread.

[Martin Francom]

Ralph,
   It's looking better and better. 
   Would it be possible to have records resorted by the column when a particular column heading is clicked on?

[Rolf Brandt]

Hi Marty,

yes this also will be one of the next features. Jean-Pierre had put up some nice listview routines for that, and I will implement them.

[Stephane Fonteyne]

Rolf

Nice Project !

Do you have plans make here examples for each control that you can used in FireFly SDK Designer v3.00

I like it if some write examples for each control that FireFly SDK Designer used.

- Standard Controls
- Common Controls

Greetings
Stephane

[Rolf Brandt]

Hello Stephane,

I doubt that my time will allow me to do that. Most of my programming circles around databases.

[Rolf Brandt]

New Update!

v1.0.0.54
Added some of Jean-Pierre Leroy's Listview functions
(http://www.planetsquires.com/protect/forum/index.php?topic=2026.0)
- Column Auto Sizing
- Column Sorting
Added a (minimum) help file

Download as always in first message of this thread.

[Jean-pierre Leroy]

Hello Rolf,

Thank you for SQLMan; I'm sure it will help many of us.

Regarding the "Column Sorting" function, I forgot to mention than to be able to view the down-arrow (or up-arrow) on the columns header, the F3 project has to be compiled with the option "Enable Theme support".

Thanks again for this beautiful piece of software.
Jean-Pierre

[Rolf Brandt]

Thank you for that hint, Jean-Pierre. It was driving me insane because I did not get the arrows to see.

Rolf

[Martin Francom]

Rolf,
    The Edit routine does not save the record  when the SAVE button is clicked.  Niether does the add routine in SQLMAN seem to be working.  Was this feature not yet implimented?

I am using the latest version.

[Rolf Brandt]

I'll check and fix!