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
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.bournemouth.gov.uk
**********************************************************************
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
