Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Icetips Article
Back to article list
Search Articles
Add Comment
Printer friendly
Direct link
Par2: Creating Primary Key in SQL file from Clarion 1998-06-04 -- Scott Ferret > when I CREATE an ORACLE file in a C4BM program, and one of the keys has the
> PRIMARY attribute, I would expect the the field(s) of this key to be marked
> as primary key field(s) in Oracle.
>
CREATE creates unique indexes. If you want to create primary key constraints
you need to use PROP:SQL to do the create. Note that you should always use
PROP:SQL to do a create as the Clarion CREATE statement cannot handle all the
features of the SQL CREATE TABLE statement. Eg constraints on fields and
foreign keys.
Today is April 23, 2024, 5:17 am This article has been viewed 35109 times.
|
|