Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
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 May 3, 2024, 7:37 pm This article has been viewed 35116 times.
|
|