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?