|
Hi All, If someone could help me out on this one I’d really
appreciate it. 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. So failing on the last
line, help! ‘********************************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
