Oops,
Re-reading my response, I should have said that UNDERSCORE characters within
a column name are OK.
Bill
----- Original Message -----
From: "Data Directions" <[EMAIL PROTECTED]>
To: "'MapInfo-L'" <[email protected]>
Sent: Friday, August 25, 2006 4:35 PM
Subject: Re: [MI-L] View Table Query
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
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
