Hi All

I am trying to write an mbx to read some information from an access database
and then use this info to recolour some polygons. Simple stuff

Well that's what I thought............

I am trying to use the following code

        SQL = "Select * From qryGetTenementColours"

        hstmt = Server_Execute(hdbc, SQL)
        Server hstmt Fetch Into "Tenement_Colours"
        Server hstmt Close 

In works as expected when qryGetTenementColours is a SELECT QUERY in the
access database.

However when qryGetTenementColours is a UNION QUERY it spits it.

Any ideas ??????

HELP !!!!!!!!!!!!!

Mapbasic 6
Mapinfo 6.5
Access 97

System DSN using Access Driver 4.00.5303.01



HOWARD ADDISON
CAD/GIS CO-ORDINATOR
AngloGold Australia Limited
Level 13, St Martins Tower
44 St Georges Terrace

Telephone (08) 94254649
Fax (08) 94254663
<mailto:[EMAIL PROTECTED]>



_______________________________________________________________

This e-mail message contains confidential information which is
intended for the use of the person to whom it is addressed.  
If you received it in error, please notify the sender and 
delete the material from any computer.  Any disclosure, 
re-transmission, dissemination or any other use of this 
information is strictly prohibited.
_______________________________________________________________



_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.

Reply via email to