User bio
404 bio not found
Member since Dec 10, 2019
Posts:
show all 2
Replies:
show all 8
Limyandi Vicotrico · Feb 8, 2021 go to post

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 go to post

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.

Certifications & Credly badges:
Limyandi has no Certifications & Credly badges yet.
Followers:
Limyandi has no followers yet.
Following:
Limyandi has not followed anybody yet.