Re: Need information about VGET
Posted: Sat Jun 09, 2012 2:21 am
Well actually if its a table and not a profile variable does'nt he need to use TBGET? not VGET, VGET is for variables in POOLS and as I remember (unless something has changed) only one value can be stored in a profile variable, if indeed your data is in a table then
would be what the op needs, correct?
am I misunderstanding?
Peteer
ISPEXEC TBGET TABLENAM SAVENAME(VAR-NAME) ROWID(ROWIDNAM) +
NOREAD POSITION(CRPNAME)
IF &LASTCC ¬= 0 THEN /* RETURN CODES */ +
DO /* 8 - KEYED TABLES: ROW DOES NOT EXIST,*/
END /* CRP SET TO TOP */
ELSE /* - NON-KEYED TABLES: CRP REMAINS AT */ +
/* TOP */
/* 12 - TABLE IS NOT OPEN */
/* 16 - DATA TRUNCATION OR INSUFFICIENT */
/* SPACE PROVIDED TO RETURN ALL */
/* EXTENSION VARIABLE NAMES */
/* 20 - SEVERE ERROR */
NOREAD POSITION(CRPNAME)
IF &LASTCC ¬= 0 THEN /* RETURN CODES */ +
DO /* 8 - KEYED TABLES: ROW DOES NOT EXIST,*/
END /* CRP SET TO TOP */
ELSE /* - NON-KEYED TABLES: CRP REMAINS AT */ +
/* TOP */
/* 12 - TABLE IS NOT OPEN */
/* 16 - DATA TRUNCATION OR INSUFFICIENT */
/* SPACE PROVIDED TO RETURN ALL */
/* EXTENSION VARIABLE NAMES */
/* 20 - SEVERE ERROR */
would be what the op needs, correct?
am I misunderstanding?
Peteer