Fox with VB6 Error.. or not??

I am currently trying to insert a line into a foxpro table using VB6. When
I run the insert statement, no error is generated but the line is never
inserted. Also, If I open the table and then try to insert, there is still
no error (I would expect one since the table is opened by me at that time).
Does anyone know what might cause this?
I am certain it's in my code because if I make a simple VB app that does
nothing but insert this, it works fine.

John

Eric
Fri Mar 05 11:55:05 CST 2004

Hello, John!

How are you trying to insert the record? Are you using ODBC? OLEDB? Can you
post some VB code?
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Cindy
Fri Mar 05 12:25:11 CST 2004

In news: %23d1zQYtAEHA.464@TK2MSFTNGP11.phx.gbl,
John Douglas <Johnathan@gawab.com> wrote:

Hi John,

Here's what I posted to the VB newsgroup-

> I am currently trying to insert a line into a foxpro table using VB6.
> When I run the insert statement, no error is generated but the line
> is never inserted. Also, If I open the table and then try to insert,
> there is still no error (I would expect one since the table is opened
> by me at that time). Does anyone know what might cause this?

I'm not sure what you mea about getting an error because you opened the
table. FoxPro tables can be opened in shared mode.

> I am certain it's in my code because if I make a simple VB app
> that does nothing but insert this, it works fine.

It would help a lot to see your code and your connection string. Are you
using ODBC or OLE DB? Which version? Do you know if the tables are in
FoxPro2.x format or Visual FoxPro format? (VFP can accept nulls, for
example.)

In your test program are you inserting the exact same values into the same
table?

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com