I am developing a form and i need to update only 1 record from a table. I am opening the table like this:

hConn = SQLSTRINGCONNECT("Driver=SQL Server;Server=(local);UID=;PWD=;Database=Empagram")

lnConsul = SQLExec(hConn, "SELECT * FROM SBCabTransaccion "+;
"WHERE EMPRESA = 'EMPA' "+;
"AND tipomovimiento = 'CP' "+;
"AND (sttransaccion <> 'V') "+;
"ORDER BY nummovimiento", "SqlSBCabTransac")

CURSORSETPROP("Buffering", 3)
CURSORSETPROP("SendUpdates", .T.)
CURSORSETPROP("UpdatableFieldList","emp_chqpag")


What´s wrong? and how i have to open the conexion to make this work?



Chio