Steven,
Probably because the buffer mode is set to 3 (optimistical row locking). Try setting the buffer mode to optimistical table locking:
CURSORSETPROP("Buffering", 5)
Then explicitly call TABLEUPDATE() or TABLEREVERT() to commit/revert changes to the backend.
HTH
>I am using the following SQL pass-through
>
>lParameters prodwg
>Local processdone
>
>prodwg = "'" + prodwg + "'"
>
>sflgdone = SQLCONNECT('pdmsupflag')
> sflgpro = "Select * From maindatad Where dm_drawing = &prodwg"
>
> =SQLEXEC(sflgdone, sflgpro, 'sflging')
> =CURSORSETPROP("Tables" , "maindatad")
> =CURSORSETPROP("UpdateNameList" , "dsflag maindatad.dsflag")
> =CURSORSETPROP("KeyFieldList", "dm_drawing, dsflag")
> =CURSORSETPROP("UpdatableFieldList", "dsflag")
> =CURSORSETPROP("SendUpdates", .T.)
>Browse
>Use
>=SQLDISCONNECT(sflgdone)
>
>Why is it updating every record and not just the one I want?
Daniel