Linking to Foxpro 2.6 datatable

G

Guest

.." failed'Jobs.I have installed the latest Fovpro ODBC driver to enable me to
link an Access2000 database to an existing Foxpro 2.6 Datatable. This has
worked sucessfully on all but one table which allows me to edit fields but on
exiting the record I receive the error message"ODBC- Update on a linked table
'Jobs' failed. [Microsoft][ODBC Visual Foxpro Driver] SQL:Statement too long.
(#812)
 
C

Cindy Winegarden

Hi Richard,

Are you editing the tables directly in grid format? If so, what happens when
you update only one field. Or, are you using an update query? If so, can you
post the code?
 
G

Guest

Hi Cindy,
I have been trying to edit the information two ways directly in the grid and
as a select query the result then edited. Both ways get the same result.

I am able to update or edit fields so long as I stay within the record. As
soon as I exit the record i get the error message.

Cindy Winegarden said:
Hi Richard,

Are you editing the tables directly in grid format? If so, what happens when
you update only one field. Or, are you using an update query? If so, can you
post the code?

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
(e-mail address removed) www.cindywinegarden.com


Richard said:
." failed'Jobs.I have installed the latest Fovpro ODBC driver to enable me
to
link an Access2000 database to an existing Foxpro 2.6 Datatable. This has
worked sucessfully on all but one table which allows me to edit fields but
on
exiting the record I receive the error message"ODBC- Update on a linked
table
'Jobs' failed. [Microsoft][ODBC Visual Foxpro Driver] SQL:Statement too
long.
(#812)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top