SQLitening Database Manager Project

[Rolf Brandt]

New Update!

v1.0.0.69
Corrected bug frmAddModify - Editing and Saving records works now properly again
- Note that added records are not reflected in the grid right away but first afer a click
- on the QuickSQL/Refresh button
Changed Layout to Tab based rather then Popup Dialogs
- Thanks to Paul and his help with the AutoResize function
Added NOT LIKE to Query Builder
Still fidgeting with implementation of ESCAPE in Query Builder
frmAddModify - set Cancel property =True for Cancel button

Database Creation is about halfway finished, will be implemented in the next couple of days.

Project download in first message of thread.

[Martin Francom]

Rolf,
   The edit/save is still not working. Here what I am doing.  Where am I going wrong.
1) Open DB
2) Select the Tablet to work with and display the records
3) Click on record to edit
4) Edit record and click the SAVE button

Observation:  Record usally not saved.  If I press enter after the edit and then click SAVE the information in the column changed is saved in the wrong column.

Here's the DB I am working with:

[Rolf Brandt]

Strange - I'll check it out.

[Rolf Brandt]

Marty,

I downloaded your database and used it to create new records and modify existing ones. I could not reproduce those errors.

[Martin Francom]

Possibly I am not using the latest version.  The version I have is 1.0.0.70

Here are two picture to illistrate problem:

First picture shows me changing the name  "Welbee"  to  "Welby"
The Second picture is AFTER I clicked the SAVE button.  As you can see the
name did NOT change.   I even tried clicking the "Show/Refresh Data" button. and still the record was not changed.

Where am I going wrong?   Am I using an old version of the SQLman?

[Martin Francom]

Rolf,
   Now look at the following series of pictures:

This time I was trying to edit the street address;  changing "somewhere" to "123 Nowhere Lain".  See picture aaThird.
After making my change I pressed the "Enter" key and notice in Picture aaForth that the active field moved from DrStreet to DrCity  Now I click the save button and change is saved this time but it is saved in the wrong column.  It was saved in the DrCity Column. See picture  aaFifth
Is this the intended behavior? 
Are we using different versions of the program?
Or am I in the "Twilight zone"?

[Rolf Brandt]

Odd indeed. I am attaching a newer exe. Try if that still happens.

[Martin Francom]

Rolf,
   There must be a rip in the Time-Space continum and I am stuck in another universe.   The program you just posted does the exact same behavior as what I discribed above.
   Maybe I am just dense as a rock.  So, humor me, using the above database,  walk me though the steps to change Markus Welbee  to  Markus Welby  Step by step do a screen capture at each step. 

   If someone here who has also downloaded SQLman could take the database above and edit a record.  I would very much like to know if it is working correctly for you. 

   I find it hard to understand how Rolf and I are getting totally different results doing a simple edit.

    Oh, and the Add-record feature doesn't work on that database either.  Could it be that the database structure is wrong in someway?

   I will try this on a simple one table database and see if it makes any difference.

     

[Martin Francom]

Well, I tried edit with the "Sample.db3" database and the edit did not work on that database either. 

[Rolf Brandt]

As for the Add record function be aware that I do no update the grid after an Add. You must refresh the recordset by either doubleclicking on the table in the treeview or by a click on the QuickSQL button. This loads the records new.

As for the Edit function I am still not able to reproduce your problem.

[Marc van Cauwenberghe]

Hello,
Finally had a change to look at this.
I can see the same behaviour as Marty.
Rolf, please try this and take care that you do exactly the same:
first open a database, go to a table lets say doctors (I am using Marty's db but should happen everywhere).
Select a record by clicking once on a row (ex. row 3) -> row gets blue
Click on the icon that says 'Edit record' -> dialog opens
Click on DrStreet in listbox on the left -> data is shown in textbox on the right = '123 anywhere'
Dubbleclick on the 123 part of the text -> 123 gets selected
Change to 999
!!! Press enter !!!
What you now will see is that on the left side (the listbox) the field selected has gone to the next one, namely 'DrCity' while on the right side it will stil show '999anywhere'
When you now press the save button '999anywhere' gets saved in the DrCity and is shown as such in the grid.

Hope this helps.
Marc

[Rolf Brandt]

OK, Marc, now I can reproduce it.

It has to do with the use of the mouse in the AddModify.frm. My sequence of editing a record is different. I choose the record in the grid, press <ENTER> to open the Edit dialog. Next I use the up/down keys to select the field I want to edit, then I press <ENTER> to move to the textbox. I edit the field contents, the press again <ENTER> to save the changes to the array. Important - otherwise changes will not be recorded. Next I save the record.

You notice I use the keyboard more than the mouse because its faster. Now that I know the problem I'll fix it quickly.

[Martin Francom]

Thanks Marc,  you have released me from Rod Sterling's grasp.  Living in the Twilight Zone is very frustrating.

Rolf, sorry I didn't explane the problem better.  I assumed everyone would edit a record the same way I was doing it.  Guess there's more than one way to skin a cat.

[Rolf Brandt]

New Update
Version 1.0.0.71

The changes:

v1.0.0.69
Corrected bug frmAddModify
Changed Layout to Tab based rather then Popup Dialogs
Added NOT LIKE to Query Builder
Added Database creation
frmAddModify - set Cancel property  =True for Cancel button

v1.0.0.71
Added DoubleClick event in Grid to open edit dialog
Corrected Click/DblClick behaviour in Treeview
QueryBuilder - Added UpDown  control to change order of selected fields
MainWindow - Added Indices to Treeview
Database Creation - Added Create Index
Database Info - Added Listview for TableDefinition
Database Info - Added Index information

Download in first message of thread.

[Martin Francom]

Rolf,
    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?