>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.
You create a SPT cursor from that table with sqlexec(h, "select * from #temp", "mycursor"), then cursorsetprop() a bunch of things for that cursor - update tables, primary key, update fields, pretty much the same way VFP does it for the updatable views. Then you fill the cursor and do a tableupdate(). You can find the code here in either downloads or FAQ - look for Vlad Grynchyshyn, he wrote that.