Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: pitbullblonde
- Order by date
-
creating foreign key - error: key not found
I'm on Pervasive version 8.60.192.030 I'm using pervasive control center, sql statements to create the tables: Projects Table: SET TRUENULLCREATE=OFF; Create Table projects using 'ProjMain.frb' ( Id IDENTITY, Ptype CHAR( 20 ) Collate "UPPER.ALT", Pdesc CHAR( 40 ) Collate...- pitbullblonde
- Post #3
- Forum: Pervasive: Pervasive.SQL
-
creating foreign key - error: key not found
I am creating a projects database. My first table (Projects) has a primary key of Id, an integer. My next table (Tasks) has a primary key of Id & Seq together, and a foreign key of Id, which references the Id in the projects table. This part works fine. The problem is in adding the third...- pitbullblonde
- Thread
- Replies: 2
- Forum: Pervasive: Pervasive.SQL
