The question is what type of SQL is valid using the ActiveDocument.DynamicUpdate?
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'