Linking to Foxpro 2.6 datatable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 25 Nov 2004 02:03 GMT

." 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)

Reply to this Message

Cindy Winegarden - 29 Nov 2004 03:41 GMT

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?

Signature

Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com

> ." failed'Jobs.I have installed the latest Fovpro ODBC driver to enable me
> to
[quoted text clipped - 6 lines]
> long.
> (#812)

Reply to this Message

Richard - 29 Nov 2004 23:55 GMT

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.

> Hi Richard,
>
[quoted text clipped - 12 lines]
> > long.
> > (#812)

Reply to this Message