mezura
asked on
adotable and adoquery
1. i have this statement in adoquery but it wont work. sip is the column name in my my test table and psip is a string.
with adoquery1 do
begin
close;
sql.Clear;
sql.add('INSERT INTO test values(sip) values('+psip+')');
execsql;
end;
2. also is it possible to use adoquery and adotable in the same form and manipulate the same table. if so can anyone provide a simple sample.
3. is there a way to move a table to another table using adotable. sample too pls
thankx
with adoquery1 do
begin
close;
sql.Clear;
sql.add('INSERT INTO test values(sip) values('+psip+')');
execsql;
end;
2. also is it possible to use adoquery and adotable in the same form and manipulate the same table. if so can anyone provide a simple sample.
3. is there a way to move a table to another table using adotable. sample too pls
thankx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ops, sorry, I didn't read Workshop's answer ... it seems to be right
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
im using microsoft access and jet for connection. i have a table named info and info2. i want to copy all of the records on info2 to info and delete all the records in info2.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
'INSERT INTO test(sip) VALUES (' + psip + ')'