Hi,

I was updating some tables on a system running VFP 6.0 using cursor adapters and odbc (connection string). Now what I decided to do was put a couple of tables on another database created with VFP 8.0 so I could take advantage of the auto increment. (the autoincrement portion gave an error which is another thread so I had to remove it)

Basically what I did was take the tables from the vfp6.dbc and put it into the vfp8.dbc. I get the information fine into my screen but I have 3 problems:

1)When I do my tableupdate (TABLEUPDATE(.T.)) it returns true but the information doesn't get updated as opposed to when it was on a VFP 6 dbc, when it did save.

2) In my connection string I connect to the vfp8.dbc database and in one of my queries it includes a table that is not there but it's in the vfp6.dbc database, when I run the query it works!???? both databases are in the same directory, but I'm using a ODBC handle based on a connection string, I would think it would give me an error saying something like "table not in the database" or something.

3) When I look at DBGETPROP(oApp.nconnectionhandle,"CONNECTION","ConnectString"), I get nothing when I should be getting my connection string.


Thanks.