tinti13
asked on
terrible problem
i have a mdb data base(with a query)
i add some components
after that when i push a button i delete all records like that
calcul.SQL.Clear;
calcul.SQL.Add('delete from calcQuery');
calcul.ExecSQL;
now when i want to add again records is a error and i don't know why
error is like this
Current provider does not support returning multiple recordsets from a single execution
How can i rezolve this
Thanks
35
i add some components
after that when i push a button i delete all records like that
calcul.SQL.Clear;
calcul.SQL.Add('delete from calcQuery');
calcul.ExecSQL;
now when i want to add again records is a error and i don't know why
error is like this
Current provider does not support returning multiple recordsets from a single execution
How can i rezolve this
Thanks
35
guessing u use the same query
for a select-query you must use open-method
just a guess, and as gloomy alread asked:
How do you add the records?
meikl ;-)
for a select-query you must use open-method
just a guess, and as gloomy alread asked:
How do you add the records?
meikl ;-)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
I noticed you set active AFTER ExecSQL, but I don't see the
inverse operation BEFORE the ExecSQL.
Plus, you don't reset the SQL property before reopening the query.
HTH,
Andrew
I noticed you set active AFTER ExecSQL, but I don't see the
inverse operation BEFORE the ExecSQL.
Plus, you don't reset the SQL property before reopening the query.
HTH,
Andrew
just wondering about the accepted answer
-> this answer should usual cause an exception
--> if this is wanted?
-> this answer should usual cause an exception
--> if this is wanted?
How do you add the records?