Access to the tables

jsinisa

hi!

i have to change values in one field (value '100' to value '900') and that in around 150 tables (around 1,000,000 items)...

normaly, i will use report or codeunit and MODIFY...

but, i have to every time to change value of REC variable, or to define 150 variables...

is there any possibility to access different tables inside code just by changing 'table nr.'?

thanks

<small>[ 05-09-2002, 11:44: Message edited by: jsinisa ]</small>

Luc_VanDyck

In Attain 3.60 this should be possible. In versions before 3.60 you'll have to define a record variable for every table.

But have a look at the dataport-generator in the download section. This generates a txt-object that you have to import and compile in the database. Maybe you can use a similar approach: create a txt-object with all your code. Write a loop to create the code to define your 150 rec-variables, and write another loop to create the code for replacing the fields.