>Hi Suhas
>
>>inaddition to what dragan said u can also make the temp table updatable through spt and then update it at once rather than sending individual insert commands to the sql server
>
>Can you expand on it, I am pretty new for SQL Server. If you could provide an example code I will adapt it to suit my pruposes.
>
>Thanks for your response.

it would be something like

sqlexec(han,"create table #temp")
sqlexec(han,"select * from #temp","temp")

*make the temp updatable to the server
cursorsetprop(tables,....
cursorsetprop(updatefieldlist,....
*etc

insert into temp values(...)

tableupdate(.t.,.t.,'temp')

sqlexec(han,'select * from originaltable where pk=#temp.pk....