using DB on external drive, reset DB

Hello,

An example, how to remove rows
http://myvisualdatabase.com/forum/viewtopic.php?id=1433

Thanks for that hint. Regrettably I´m not familiar with such code snippets. How can I use it? Must i add this code to an Button?
Best way would be if I could select like in other windows app  with Crtl oder Shift key.

Cheers

gieri

Hello tcoton,

OK, after some playing around with the sample I´m sure I have made all configs similar in my project. Regrettably it doesn´t worked the same as in the sample.

When I have a bunch of entries and I click just on one entry, all other rows are disappear. Do you have an idea what happened here?
Also I still have the problem that after delete all entries, the ID will not reset to 0 when I add some new entry
It seems that my grid will not auto refresh when I have made a new entry with the entry form... is there a option to make this grid autofresh?

Cheers

gieri

Gieri,
To reset the id to 0 after deleting all records from a table, place the following after your sql delete:

SqlExecute('Delete from sqlite_sequence where name=''Table_Name''');

Substitute Table_Name with your table name inside the quotes.

Morning Gieri, Thierry,

I was having a look at your project and there are a couple of things that you could try and change (all on Form1) to see if it does what you want.
1)
I think your 'search' (button4) doesn't behave correctly because you have included tablegrid1 as a selected component.
2)
You also do not need an incremental search on tablegrid1 pointing to button4.
3)
I would add an incremental search on edit2 and edit 3 pointing to button4 instead.
4)
You could change the filter properties for edit2 and edit to %s% to perform incremental wild-card searching
5)
If you do 4) and 5) you can hide the 'search' (button4) totally as it is now working incrementally
6)
You can add counters to tablegrid by using the tablegrid settings (where you add the column, column headings etc - click  'footer' and select 'count' option
7)
If you want to select multiple rows for deletion, you can also use 'go multiselect'  which is a property of the tablegrid (properties / options) instead of adding it in a script
8)
when selecting multiple rows in a tablegrid, you select the first row as normal AND THEN hold the CTRL key and select  any others;  if multiple rows display in the tablegrid as highlighted, you have done it correctly.

I hope this answers some of your questions helps.  I have included all of the points in the attachment.

Derek.