?
Solved

Problem creating a paradox table with ODBC

Posted on 2003-03-17
3
Medium Priority
?
220 Views
Last Modified: 2013-12-25
Hello everybody,

I've some troubles trying to create a paradox table with vb using the 'Microsoft Paradox Driver'.
If I use the following query :

"CREATE TABLE ORDER (N_ORDER integer, N_SIRET CHAR(20), ETS_N_SIRET CHAR(20))"

the table is created without problem.

But if I try to create the same table with a primary key constraint :

"CREATE TABLE ORDER (N_ORDER integer PRIMARY KEY, N_SIRET CHAR(20), ETS_N_SIRET CHAR(20))"

I've the error:

'-2147217900 (80040e14)'
[Microsoft][ODBC Paradox Driver] and a message saying that the db engine cannot find 'Index_935AEF87_9C85_4EE3'

(I've tried to change the query by using "PRIMARY KEY (N_ORDER)" at the end or with an "ALTER TABLE", the problem is the same)

I suppose it's a problem with the creation of the index but I'm not able to find a solution. Any idea? Thanks for your help and sorry if it's a very basic problem...
0
Comment
Question by:guillaume200
[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
3 Comments
 

Author Comment

by:guillaume200
ID: 8159511
Don't know if someone is interested in, but I've found the source of my problem. You have to create an index on the table having the same name than the table itself :

"CREATE TABLE ORDER (N_ORDER integer, N_SIRET CHAR(20), ETS_N_SIRET CHAR(20))"

And then the creation of the index :

"CREATE UNIQUE INDEX ORDER ON ORDER (N_ORDER)"

If the 2 names are different, the index cannot be created
0
 

Expert Comment

by:CleanupGuy
ID: 8410931
Hi guillaume200,
Experts-Exchange is performing an automated process to delete old questions.  There have been no responses to this question, so it will be DELETED within 3 days.

Your points will be refunded.

If you still need the answer to this question, you should ask it again, as a new question.  Your new question will appear at the top of the list, where many Experts will see it and respond.  Here are some general tips on getting Experts to work on your questions:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
1) Offer a high point level.  Experts often concentrate on higher-valued questions.
2) Choose the best Topic Area -- target the experts who have the specific skills that you need.
3) Include keywords in the Question Title that will attract the right Experts.
4) Provide FULL DETAILS in the question body so the Experts can get right to work on a solution.
5) When an Expert does make a comment, be sure to be responsive.

For more information on Asking Questions, see http://www.cityofangels.com/Experts/Member.htm
For information on how to finalize questions, see: http://www.cityofangels.com/Experts/Closing.htm
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Please DO NOT respond to this automated post.  DO NOT ACCEPT THIS COMMENT AS AN ANSWER.  Thank you for participating at Experts-Exchange.

CleanupGuy -- EE database cleanup volunteer
0
 

Accepted Solution

by:
SpideyMod earned 0 total points
ID: 8424951
PAQ'd and points refunded.

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

752 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