?
Solved

Problem creating a paradox table with ODBC

Posted on 2003-03-17
3
Medium Priority
?
226 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
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…
Suggested Courses
Course of the Month4 days, 2 hours left to enroll

599 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