Changing value in one field across multiple tables

[djenckes]

I am trying to write a program that will update the value of one field for every record across every table that contains the field.

I can get the table names from the _file and _field tables, but how do I get the for each statement to recognize the table name?

 

[djenckes]

Never mind, I figured it out. I was trying to do it with an include file (.i) and has to be an uncompiled file (.p).

 

[BONO]

Hello,
you can do that by create a .p dynamically from a procedure whor read _file and _field system table. I've do that so u can run it only from a progress provision session or better and not from client networking because u need to compile it at run time.
With V9 u can access buffer and query by handle and u can use query-prepare. I think u can create with v9 instruction the same program without run time compilation needed.


Hope it's help