Linking to Foxpro 2.6 datatable

  • Thread starter Thread starter Guest
  • Start date Start date
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)
 
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?
 
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)
Click to expand...
Click to expand...
 
Back
Top