Recent posts:
Recent replies:
Limyandi Vicotrico · Mar 3, 2021
Limyandi Vicotrico · Feb 8, 2021
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).
SOLVED:
I just realised that I will need to use:
SELECT
%VID FROM ( SELECT ID FROM TableName )
Thanks,
Rico.
Limyandi Vicotrico · Jan 19, 2021
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.
Followers:
Limyandi has no followers yet.
Following:
Limyandi has not followed anybody yet.
Global Masters badges:
Limyandi has no Global Masters badges yet.
Can this be used with InterSystems Cache?