The question is what type of SQL is valid using the ActiveDocument.DynamicUpdate. Is this standard ANSI SQL? Or some hybrid of QV SQL . I am able to get it to work with a simple WHERE field= value but NOT Where field in (value) .
I am now able to utilize the ActiveDocument.DynamicUpdate command within QV. It performs correctly using the following statement:
· MatchSet is a table within QV
· LastChangType is a field within MatchSet
· strDestination is a variable set to "BOGUS"
· TransactionID is a field within MatchSet
· v_ReturnQueryString is a variable that contains one value '3444334'
query = "UPDATE MatchSet SET LastChngType=" & "'" & strDestination & "'" & " WHERE TransactionID = " & v_ReturnQueryString & "
HOWEVER
When I run the same command EXCEPT for using WHERE IN (TransactionID = v_ReturnQueryString vs. TransactionID in( v_ReturnQueryString))
This does not return an error but it does not work either.
The question is what type of SQL is valid using the ActiveDocument.DynamicUpdate. Is this standard ANSI SQL? Or some hybrid of QV SQL.
Thanks