Dear All
I was wondering if someone could unscramble this error.
ODBC Error: ODBC RC=-1, ODBC SQLState=37000,
DBMS RC=0, DBMS Msg=[SpatialWare ODBC (2.2-32)]
Failure in Parsing - Spatial-SQL Statement ORA-01786:
FOR UPDATE of this query is not allowed -
SELECT COUNT(1) FROM "ODBCCONNECT"."MYTABLE".
We are using SpatialWare 2.2 (Oracle 7.3.2.Etc) and our recently upgraded
MI5.5 - this error doesn't occur with 5. Even more annoyingly it downloads
the table but interrupts with the rest of the code by halting my MB app
right there.
The error message above was generated using the manual opening "of the DBMS
table"
To open in my app I use something like the following:-
dim conNum as integer
If ConNum = 0 then
ConNum = server_connect ("qelib","DSN=ODBCCONNECT")
End If
server conNum link table
"select * from MYTABLE"
into DATA_MYTABLE
Some of the other tables work quite happily but this table is "non-mappable"
but contains important FKey information.
If anyone knows of this problem or can answer my query I'd be most
appreciative
Thanks
Tim Chinchen (GIS Systems Developer)
I.T. Services Bournemouth Borough Council
Mailto:[EMAIL PROTECTED]
http://www.Bournemouth.gov.uk
http://www.bournemouth.gov.uk/SCRIPTS/hsrun.exe/webapps/MapXtreme/MapXtreme.htx;start=HS_JavaMapPage
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
