by Programming with:
* vb 5.0
* ODBC 3.5 using ODBCDIrect with the Database object
* SQL Server 6.5
I attempt to execute the following statement and receive the ODBC error
3146 - ODBC call failed.
delete * from pattable where oid = '005' and end_ >= '12/01/96' and end_ <=
'08/07/98'
Upon examing the returned error closer -- I was able to determine that the
server error being returned is system message 146 - "Unable to allocate
ancillary table for a subquery. Maximum number of tables in a query (%d)
exceeded."
What causes this error and what do I need to do to get around it? I am
using only one table for this query. The query is performed using the
.Execute method with no explicit option setting. I have full rights to this
table as the UID in the initial connection string is set as the database
owner. Any help is very much appreciated.
Frank West