Solved

TableAdapter Configuration Wizard Doesn't work properly with foxpro tables

Posted on 2009-04-12
3
378 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:DrProf
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 24128832
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.
0
 

Author Comment

by:DrProf
ID: 24129330
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?
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 24129405
Can you attach a .png screen shot of your designer?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

687 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question