I Have one table that has all the fieldnames listed for all the tables

The FIELDRS is a record set of the fieldnamess in that table

The first for loop converts the recordset into an array

Then what i want the second For loop to do is use that array to insert the fieldnames in the UPDATE Query And Then also use the array to specify the source fields in the same update statement.

For x = 0 to fieldlc
Create Array ---> 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