mskb #Q138094How to Create Updatable Views by Using SQL Passthrough.
How to make SQL Pass-Through cursor updatable FAQ #8153
>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? >
