>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

What is the UPDATE supposed to do?

As far as I can tell, you are saving the values in the "FIELDS" field and saving it to an array. The only probable flaw I see is the missing spaces after UPDATE and before WHERE. What do you get back in UpdateQuery?