|
Hi All Having trouble finding what is wrong with this code. The
first “Add Column” statement works however the second throws the “File
#0 not registered for access” error. ‘********************************Example************************ close all interactive Open Table
"c:\inspections\AMS_Final\MAINTENANCE\Inspection.TAB" as
inspection_local Interactive Open Table
"C:\Inetpub\wwwroot\biz_e_asset\AMS_Final\MAINTENANCE\Inspection_Graphic.TAB"
as inspection_server Interactive Open Table
"C:\Bizeasset\Inspection_Graphic.TAB" as inspection_copy Interactive Open Table
"C:\Inetpub\wwwroot\biz_e_asset\AMS_Final\rd\lines\core\rd_line.tab" Register Table
"C:\Bizeasset\CompletedInspections.mdb" Type ACCESS Table
"CompletedInspections" Into
"C:\Bizeasset\CompletedInspections.TAB" Open Table
"C:\Bizeasset\CompletedInspections.TAB" Interactive select * from
inspection_local where inspector = "" into answer update answer set inspector
= "Unknown" Create Map For
Inspection_copy CoordSys Earth Projection 8, 33, "m", 147, 0, 0.9996,
500000, 10000000 select * from
Inspection_local where Inspection_Lookup_Type like "%rd_line%" into
answer Add Column
"answer" (Road_Name )From rd_line Set To Road_Name Where asset_id =
asset_id Add Column "answer"
(Locality )From rd_line Set To Locality Where asset_id = asset_id Select * from
Inspection_local where Uploaded not like "y%" into not_uploaded insert into
inspection_server select * from not_uploaded insert into inspection_copy
select * from not_uploaded Add Column
"Inspection_server" (Complete_Date )From CompletedInspections Set To
TSDate Where Inspection_Number =oreftext Add Column
"Inspection_copy" (Complete_Date )From CompletedInspections Set To
TSDate Where Inspection_Number =oreftext ‘****************************************************************** Hayden Fisher |
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
