Hi all,
I have an application written in VFP 3.0. When I try to insert data into certain MSDE tables, I get the error 'connectivity internal consistency error'. If I cut and paste this same query into the Query Analyzer, it works fine. If I use VFP 6.0 (sp3) the same query give me a 'no result set returned by the server' error. The query is "insert into folder (name, system_id) values ('Name', 1)" where system_id is a primary key in another table, and is defined as a foreign key in the folder table. One last note, after the error occurs and I restart the program, the record has been successfully inserted. Any help would be appreciated.

Bob