>Hi,
>
>Having trouble with SQL Server Fox7 pass through update sequence of commands. All my statements run successfully and report successful. The connect,select, all cursorsetprop (tables,keyfieldlist,updatablefieldlist,updatenamelist and sendupdates),insert and disconnect. But I look at the table using Enterprize Manager and no update has been made. ? Am I lacking a permission? and after the sequence runs and I try to exit foxpro I cant, I get the error "connection handle is invalid". Any suggestions.
>
>Ron

Hi Ron,

(general 'may not be right problem' disclaimer).

Did you enable buffering for your cursor, if so you'll need a TABLEUPDATE().

Try issuing a
? TABLEUPDATE(.t., .t., "Cursorname")
before you exit VFP and see if the "connection handle" error goes away.