Can this be used with InterSystems Cache?
Great work Chip, Robert
One question, are you using InterSystems IRIS or Cache?
I am using Cache and am not able to use the %VID, is there any alternative to the %VID value, as I need the row number (the %ID field is not a normal incremental ID).
I just realised that I will need to use:SELECT %VID FROM ( SELECT ID FROM TableName )
Thanks for the answer. I generally tried this but it did not work too. I changed it back to the proper name but still getting the same error.
Log in or create a new account to continue