I've an SQL script I was to run against many SQL tables, its a basic .txt file ready for input into a compiler.
My Tables are (example)
A001
A002
A003
A004
the script is
Open table "&.tab"\nalter table & (add areasqm decimal (10,2))\nupdate & set
areasqm = area (obj, "sq m")\ncommit table &\nclose table &
where & is the table name, seem to remember I need something like a ^ before each table name, but I've forgotton.
Can one of you clever folk point me in the right direction.
TIA
Dave