I am trying to make a dynamic query and am having a little trouble.

How Can I make the following work.


For x = 0 to fieldlc
field(x) = FIELDRS("FIELDS")
FIELDSRS.movenext
Next

For Y = 1 to loopcontrol
UpdateQuery = "UPDATE" & TableName & " " &
For X = 0 to fieldlc
Set VFPRS.fields(field(x)) & "=" & field(x) &
Next
" " &
"WHERE PRIMKEY=" & Y
Response.Write UpdateQuery
'connSQL.execute(UpdateQuery)
VFPRS.movenext
Next