Insufficient base table information for updating or refreshing.
- From: "Montclair" <montclairguy@xxxxxxxxxxx>
- Date: 19 May 2006 21:11:41 -0700
If anyone is still getting this using ADO trying to edit a FoxPro (and
possibly other) providers, using an SQL statement as a recordsource,
the answer that worked for me (which I stumbled across after 6 hours of
searching on the net, trying different CursorTypes, verifying I had a
primary key in the table, etc, etc.) is to remove the semicolon (;)
from the end of your SQL statement. Unbelievable!
i.e.
rs.Open "SELECT * FROM sometable WHERE (somefield='something');"
should be
rs.Open "SELECT * FROM sometable WHERE (somefield='something')"
[minus the semicolon]
This allowed me to apply the .update method after editing fields in the
record. Prior to that (with the semicolon) I would consistently get
the error "Insufficient base table information for updating or
refreshing."
Removing the semicolon allowed the BASETABLENAME and other properties
to be properly populated, instead of being Null.
Hope this helps someone out there!
.
- Prev by Date: ADOX: how to get true ordinal of Excel Table
- Next by Date: Re: MS Jet app and routers
- Previous by thread: ADOX: how to get true ordinal of Excel Table
- Next by thread: Re: data update
- Index(es):
Relevant Pages
|
|
