Forum Discussion

al358's avatar
al358
Frequent Visitor
4 years ago
Solved

Unable To Apply Query - OLE DB or ODBC error: [Expression:Error] expected a RenameOperations value

When I try to apply this query (see text file) I get the following error:   OLE DB or ODBC error: [Expression:Error] We expected a RenameOperations value     I think the error stems from t...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    I'd probably choose to null all fields if there aren't exactly 3.

     

    Something like this:

    renamedrecord =
    if Record.FieldCount(sortedrecord) <> 3
    then [Storage_Key = null, Network_Key = null, Condition_Key = null]
    else Record.RenameFields(sortedrecord, <...existing code here...> )
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

I'd probably choose to null all fields if there aren't exactly 3.

 

Something like this:

renamedrecord =
    if Record.FieldCount(sortedrecord) <> 3
    then [Storage_Key = null, Network_Key = null, Condition_Key = null]
    else Record.RenameFields(sortedrecord, <...existing code here...> )
al358's avatar
al358
Frequent Visitor
4 years ago

Alexis, you are indeed a Super User and a credit to the community; this worked perfectly! Thank you for your help.