Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i have an issue with this for each, im trying to load 3 tables, 1,2,3,
Set vTablas = 'Tabla1', 'Tabla2', 'Tabla3';
FOR each name in '$(vTablas)'
let vTablaname = Peek('$(vTablas)', '$(name)');
'$(vTablaname)':
NoConcatenate
LOAD *
INLINE [
ID, Nombre
1, Juan
2, María
];
NEXT name
but i only get this, please help, i want 3 tables, table1 table2 and table3
i found the solution
i was puting my variable with in ' ' so like, i just put $(vTablas) with no ' ' and it fix the problems
SET vTablas = 'ADCP', 'ADR6', 'ADRP', 'AGR_1016', 'AGR_1251', 'AGR_DEFINE', 'AGR_PROF', 'AGR_TEXTS', 'AGR_USERS', 'T024', 'T16FB', 'T16FE', 'T16FG', 'T16FS', 'T16FT', 'T16FW', 'T16FH';
FOR each i in $(vTablas)
'$(i)':
NoConcatenate
LOAD * Where RecNo() = 1;
SQL SELECT * FROM $(i) ;
NEXT i
now i have all my tables
i found the solution
i was puting my variable with in ' ' so like, i just put $(vTablas) with no ' ' and it fix the problems
SET vTablas = 'ADCP', 'ADR6', 'ADRP', 'AGR_1016', 'AGR_1251', 'AGR_DEFINE', 'AGR_PROF', 'AGR_TEXTS', 'AGR_USERS', 'T024', 'T16FB', 'T16FE', 'T16FG', 'T16FS', 'T16FT', 'T16FW', 'T16FH';
FOR each i in $(vTablas)
'$(i)':
NoConcatenate
LOAD * Where RecNo() = 1;
SQL SELECT * FROM $(i) ;
NEXT i
now i have all my tables