Hi Uffe,
Thanks for that.
Renaming the tables without a hyphen solved the problem.
Note that hyphens within the column name are OK.
Regards,
Bill
=======================================================================
----- Original Message -----
From: "Uffe Kousgaard" <[EMAIL PROTECTED]>
To: "Data Directions" <[EMAIL PROTECTED]>
Sent: Friday, August 25, 2006 3:41 PM
Subject: Re: [MI-L] MI-L View Table Query
Try rename your table into T_WaterBores.
"-" in a tablename is likely to create problems in SQL and in a lot of
other places.
Regards
Uffe
----- Original Message -----
From: "Data Directions" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, August 25, 2006 8:58 AM
Subject: [MI-L] MI-L View Table Query
View tables are great, if you can get them working!
When I try to run the following View Table, I get an error message saying
Bore_Total_Water_Usage:11: Numeric values required. Any ideas? Thanks.
Bill
!table
!version 100
Open Table "SurfaceWaterUsage" Hide
Open Table "T-WaterBores" Hide
Create View Bore_Total_Water_Usage As
Select RN, n_use_amt
From SurfaceWaterUsage, T-WaterBores
Where SurfaceWaterUsage.RN = T-WaterBores.RN
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
