Hi Cetin,

I have managed to get the code to work for a select statement. I had to change the sqlconnection define.

I have a few more questions.
1) Do I need to execute the create object for each sql statement i need to call?
2) Do I not need to close the connection at the end?
3) I have include an example to add a record but I get the error "alias not found". Is this the right way I'm doing it

oXC1 = Createobject('xcADOUpdatable', "vtbltest", SQLCONNECTION, ;
"insert into tbltest values(4,4,'my area','my officer')",;
"tbltest",;
"",;
"id,region,area,officer",;
"id tbltest.id, region tbltest.region, area tbltest.area, officer tbltest.officer")

=Tableupdate(.t.)

Do I need to do anything different for an insert,update or delete?