Hi Bill!

Perhaps Create View only accepts numeric values in the comparison field?

Hälsning / Best regards Mats.E
________________________
FB Engineering AB
Södra Förstadsgatan 26
211 43 Malmö

Tel: 040-660 25 50
Mobil: 0705-27 60 27
Fax: 040-660 25 99
[EMAIL PROTECTED]
www.fbe.se



"Data Directions" <[EMAIL PROTECTED]>
Sänt av: [EMAIL PROTECTED]

2006-08-25 08:58

Sänd svar till
Data Directions <[EMAIL PROTECTED]>

Till
<[email protected]>
Kopia
Ärende
[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

Reply via email to