I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardInterbase Topic   Print This     

Keyword & fields name in Interbase

Keyword & fields name in Interbase in Interbase topic (part of our DBA, Databases, & Data group).

Quick Search: Keyword   Interbase   Keyword &   Keyword & fields   name Interbase  
Giancarlo
 (Inactive)
Lecco
I'm translating a Microsoft SQLServer database on an Intrebase database. I have some difficulties on fields such as: password, auto, position. These fields name are not allowed in Interbase because you can't use a keyword for name of a fields.
How can I do?

Tankyou for your answers,
Giancarlo
 Posted 18 years ago (Thread Starter)
Comment Quote
About Giancarlo -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #4379, 1 replies
Thread Started 11/20/2001 3:35:00 AM
View Counter=2575
Last Reply Posted 11/19/2002 7:45:00 AM)
Location=Lecco  
Joined=18 years ago   MB Posts=1  
Most Recent Post
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
You can't have any column names in InterBase that are reserved words.



Even if you try to quote the column names (a trick that does work in SQL Server) like this:


CREATE TABLE FieldTest (
  Field_ID INTEGER,
  "Auto" INTEGER );




this will generate an error in InterBase.



The only thing you can do is give the columns different names in InterBase (like UserPassword or AutoField), and use Microsoft's Data Transformation Services tool to move the data from SQL Server to the InterBase database. DTS does a very good job of matching columns between tables, even if the names are not identical.
 Posted 17 years ago
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #8347 (Level 1.1)  Reply to 4379
Thread Started 11/19/2002 7:45:00 AM
View Counter=2
Location=Las Vegas, NV USA 
Joined=17 years ago   MB Posts=442   KB Posts=19  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1194A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #4379 Counter
2575
Since 4/2/2008
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech