Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Mon, Aug 29 2022 11:46 PM	Permanent Link
Ian Branch	Hi Team, How do I iterate through Information.Tables so I can set the same properties in all of the tables? Regards & TIA, Ian
Tue, Aug 30 2022 2:22 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian Iterating through Information.Tables is just like any other table. I haven't tried it with it assigned to a table component but a simple query (eg SELECT * FROM Information.Tables) does work. Iterating through it is then just like any query - a while not eof construct (always remembering to add NEXT which I often forget). Altering tables would be done with a subsidiary query which you could build inside the while eof loop. Roy Lambert
Tue, Aug 30 2022 5:41 AM	Permanent Link
Ian Branch	Tks Roy. I wasn't certain and didn't want to run the risk of killing something.
Tue, Aug 30 2022 8:02 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian Don't worry - ignore the hype AI isn't alive YET! Roy Lambert