SQLitening Database Manager Project

[Martin Francom]

Rolf,
   I hate to sound like a broken record.  But the Edit record feature still does not work properly. Did you actually test it?
   I have included a screen print.  What the screen print shows,  is that the edited field is ending up being stored in the field next to it.
   Try these steps and see what you get:
1) open database
2) Double click on Tablet to display the rows and columns
3) Click on Row to highlight it
4) Click the  Edit Record button
5) In the edit dialog click the field you want to edit
6) Make a change to the field
7) Press ENTER key
Click SAVE button

Notice the changed field got saved in the Dr-Street field instead of the Dr-Name field.

[Rolf Brandt]

Is it possible to modify a Table in an active database?   That is to add or delete a field in a Table.  Or, to add or delete an index   in database filled with infomation?

As of yet you can only add tables or indices to a current database. More features will be implemented in future updates.

[Rolf Brandt]

Minor Update!
v1.0.0.72

Changed code in the AddModify.frm.
Cursor will not jump to next field anymore but stay with the same. Seems this was occasionally causing the problem Marty reported.

Download in first message of thread.

[Martin Francom]

Rolf,
    Downloaded this minor  program change.  And now the cursor does stay in the same field after pressing enter.   But that is NOT the problem.  The problem is: the data changed gets saved to the WRONG field.  See screen print.
    I tryed to change the address and when I saved the change the address was put in the DrCity field instead of the DrStreet field.
    So I have to report the Edit function of SQLMAN still does not work correctly.

[Rolf Brandt]

How do you switch from one field to the next? Mouse or Cursor keys?

BTW I did mention that the cursor does stay in the same field now.

[Rolf Brandt]

Bugfix (Can't really call it an update!)
v1.0.0.73

Changed code in the AddModify.frm again.
Cursor still will not jump to next field but stay with the same. But the problem should be fixed.

Download in first message of thread.

[Paul Breen]

Hello:
I don't know why, but I am getting a dialog from windows that says "memory xxx could not be read" and firefly shuts down. This is when I compile and run the version dated today. I tried a new installation and same thing happened. I tried another sample application and there was no problem, so I don't think it is my machine, but you never know. I use a different machine every day at the computer lab, use a fresh install of firefly. If nobody else complains, you can probably ignore this. I like the program and hope you keep improving it.
thanks,
Paul Breen

[Rolf Brandt]

Paul,

I sometimes experience this too. I think it might have to do with the tab control. Try to open all forms in designer view. That sometimes works for me.

[Rolf Brandt]

Update!
v1.0.0.74

Changes:
Implemented Creation of Triggers
frmAddModify again - jumps to next field after edit (finally)

Changed name of executable to SQLiteningMan to reflect it's real purpose.

A complete setup with all dependencies, helpfile, and sample database can be downloaded here:
http://sqlitening.rbsoft.eu/SQLiteningMan_Setup.exe

[Martin Francom]

Rolf,
    I am happy to report that fields being saved are now saved correctly.

    I would like to request a couple of things:

    * Would it be possible that if the user double clicks a field, that record opens the edit dialog and moves directly to the field the user double clicked (as that is likely the field they wanted to edit).

    * Would it be possible to SAVE the record as soon as the ENTER button is pressed.  I am particulary keyboard centric and it seems to me to be a waist of energy to have to stop and grab the mouse so I can save the record.   I know some people may want to edit several fields before they save.  But because after pressing enter you can not see the fields you have previously changed.   To me it just makes more sense to save the change as soon as the ENTER key is pressed.

   * Another posibility would be to be able on the listing screen to just clickon the field the user wants to edit and edit it right there.  No real need to open a special edit dialog.

   Your project is coming along nicely.  Good work!

[Rolf Brandt]

Hello Marty,

thank you for your thoughts. I'll see what I can implement into the project.

Would it be possible to SAVE the record as soon as the ENTER button is pressed.   

ENTER just saves the field content to the array. You could use ALT-S to save the record without using the mouse. Of course we also could save the record also after each field being edited, but this really would create a lot of unnecessary traffic to the server.

I am particulary keyboard centric and it seems to me to be a waist of energy to have to stop and grab the mouse so I can save the record.

I fully understand that, I don't like either always to change between mouse and keyboard. That's why my commercial taxi programs are keyboard oriented. Though many of my customers complain and want more mouse capabilities like Drag and Drop etc.

The Add / Edit form I am using here is an idea borrowed from the Cheetah Pet program. It allows to have an universal small dialog even for records with lots of fields. It is not the most ideal form to work with but you do not have to create special forms for each table. In an application with a set range of tables I would use a different approach.

Right now I am implementing altering table definitions (which is a bit limited in SQLite).

[Rolf Brandt]

Update!
v1.0.0.75

Changes:
RecordBrowser - right mouseclick opens Edit dialog with selected column
ToolsMenu - Export to CSV
Updated helpfile

Project download in first message of thread.

Complete setup with all dependencies, helpfile, and sample database:
http://sqlitening.rbsoft.eu/SQLiteningMan_Setup.exe

[Martin Francom]

Rolf,
   Just wonderiing how you are coming with this project?

[Rolf Brandt]

Hi Marty,

I have been very busy with my dispatch project the last few weeks, so I did not have much time to work on the SQLiteningman. But it will continue.

[Rolf Brandt]

Update!
v1.0.0 Release 85

Changes:
New Layout - Selected record displayed in 2nd Listview (see image)
New Feature - Print data grid (column width is reflected in printout)

Project download in first message of thread.

Complete setup with all dependencies, helpfile, and sample database:
http://sqlitening.rbsoft.eu/SQLiteningMan_Setup.exe