Recent posts:
Recent replies:

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.

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.