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

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► MB LobbyDBA, Databases, & Data BoardOracle Topic   Print This    All Groups  

Linking to Oracle

Linking to Oracle in Oracle topic (part of our DBA, Databases, & Data group).

Quick Search: Linking   Linking Oracle  
rrs
-- USA
I have problems when I try to link to Oracle table. I get an error message "Invalid field definition 'Field Name ' in defnition of index or relationship".
The table I am trying to link to is really big. It has around 260 columns Could that cause a problem ?
Thanks for your help.
 Posted 16 years ago (Thread Starter)
Comment Quote
About rrs -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
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 #9393, 1 replies
Thread Started 4/10/2003 8:30:00 AM
View Counter=3941
Location=-- USA 
Joined=16 years ago   MB Posts=1  
Most Recent Post
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
Moved from "Member Introductions"...




The error message indicates that you have a foreign key error, so you will find the problem in the foreign key definition.



If you have the metadata handy, check for column or table aliases. Sometimes the syntax of quotes around column aliases is OK for Oracle's interpreter, but when the metadata is exported to a development tool (VB??? Delphi??? Paradox???), the syntax is invalid in that tool.



If you included the source of the foreign key definitions on that table, we could probably provide you a better answer.
 Posted 16 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 #9394 (Level 1.1)  Reply to 9393
Thread Started 4/10/2003 8:44: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 = P1223A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #9393 Counter
3941
Since 4/2/2008

Follow PrestwoodBoards on: 


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