BorlandTalk.com

Pedram · Guest

Hi, I got crazy but I still couldn't delete a Record in my Database.
For example I have a Table with a test.db which contains 10 records.
I wana delete the code that is the Current code in runtime.
Table1->SetKey();
Table1->FieldByName("Code")->AsInteger=MyInt;
Table1->GotoKey();
// Table1-> ... how could I remove the record?

Antonio Felix · Guest

"Pedram" <irbus (AT) remove-me-bonbon (DOT) net> wrote:

Pedram · Guest

Hi !!!
Thanks for your reply
do you (or anyone else) know what is different between the Antonio easy way
and my new found way:
if ( Table1->GotoKey() )
DataSource1->DataSet->Delete();
When I test ot both of them are working OK.
But I guess my way , may loos some less than miliseconds and RAM address
that may be fatal in tones of records.
Am I rights?

@};- thanks again

"Antonio Felix" <nomail (AT) nm (DOT) pt> wrote

Jayme Jeffman Filho · Guest

Hi,

If you have a lot of records to delete you can use an SQL delete command :
"DELETE FROM table WHERE table_field = field_value", you do not
need a TQuery to Execute the command, use your TDatabase component
if you have dropped down one or the Session-Database, which is from the
TDatabase class. Have a look at the TDatabase::Execute() method in the
Help file.

HTH

Jayme.

"Pedram" <irbus (AT) remove-me-bonbon (DOT) net> escreveu na mensagem
news:43622968 (AT) newsgroups (DOT) borland.com...