Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter Insert Failure
Message
From
27/06/2006 14:43:24
Jarid Griesel
The Innovix Technology Group (Pty) Ltd
Johannesburg, South Africa
 
 
To
23/06/2006 15:43:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01131208
Message ID:
01132122
Views:
19
Hi There

Solved at last !

The offending lines are:

.InsertCmdDataSourceType = pcDST
.InsertCmdRefreshFieldList = pcFldLst
.InsertCmdRefreshKeyFieldList = pcKeyLst

I changed them to :

.InsertCmdDataSourceType = ""
.InsertCmdRefreshFieldList = ""
.InsertCmdRefreshKeyFieldList = ""

It would appear that if .InserCmd = "", i.e. vfp does it's own insert command, then the
above three .insert paremeters must also be blank.

I also had to explicitly make .UpdateType = 1 and then the whole thing works, cant seem
to explain why.

Thanks anyway for your assistance with this.

Regards
Previous
Reply
Map
View

Click here to load this message in the networking platform