1.

Solve : script with SQL/DOS?

Answer»

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


Couldn't be sure what DATABASE you're USING but generally table names are used as literals without quotes, same with table fields, except they may be qualified by the table name.

You are a braver soul than I, altering the table directly without a temporary table (recordset). GOOD luck.



Discussion

No Comment Found