We help IT Professionals succeed at work.
Get Started

INSERT INTO Paradox Table with Special Character on the Primary Key Field

1,587 Views
Last Modified: 2012-06-22
We have a paradox Table with the following fields (Acct#,ClientName,LastName) where Acct# is the Primary Key and WE CANNOT CHANGE THE STRUCTURE OF THE TABLE. Acct# is a type A in Paradox that is like a VARCHAR type in SQL, you cna insert Numbers and Letters and we already double checked that the primary key is not duplicated.

We can Update, Delete or Modify any record but at the time that we want to insert a new record, we get the following error
"ERROR [HYS22] [Microsoft][ODBC Paradox Driver] The INSERT INTO statement contains the following unknown field name: 'Acct#'.  Make sure you have typed the name correctly, and try the operation again."

The query is as follows  --  INSERT INTO status([Acct#]) values('123123123'). We are almost sure that is because of the Special Character on the Acct# field.

Does nyone have a work around or a solution for this problem that can help us? We are migrating from Paradox to SQL and are struggling with this problem. Any help would be appretiated.
Comment
Watch Question
IT Manager
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 15 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE