DrProf
asked on
TableAdapter Configuration Wizard Doesn't work properly with foxpro tables
I am trying to create a dataset with two foxpro tables the tableadapter configuration wizard creates on select and insert commands, but doesn't create update or delete commands, also if I change the insert command I will loose all the parameters and then I have to redifine all the parameters again manaually.
I am using Visual Studio 2008 and my project in VB.NET.
any suggestion or help.
thx in advance
I am using Visual Studio 2008 and my project in VB.NET.
any suggestion or help.
thx in advance
That is usually a problem when the wizard cannot determine primary key columns, which are needed to generate the update, insert, and delete commands. Maybe that is a problem with how the wizard works with FoxPro.
ASKER
thx for your comments, actually I agree with you about the disability to determine the primary key, but what about changing the insert commands, the wizard unable to determine the parameters types and names, what do you think the cause of that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.