<>
The attached code works, every version of notes, except 8.0.1 and 8.5. Can anyone point me in the right direction here??
Seeing error message indicating the following:
Could not execute @db function
I have tried removing the “Cache”, but it did not make a difference. The only true difference is downgrading back to 8.0.
Has anyone else seen this?
@If(@DbLookup( “ODBC” : cache ; “QuickBooks Data”; “”; “” ; “customer” ; “fullname”; “fullname” ; Project) = “”; @Prompt([Ok];“QB Project Name Failure”;"Record: “+Name + " (” + TxnDate + ") " + " Project: " + dsp_Project);@SetField(“verify_cn”;“True”));
RESOLUTION:
Delete the DSN and recreate it. Problem goes away…