gettingstarted
[Top] [All Lists]

Re: SQL Error with REAL Database

To: Getting Started <gettingstarted at lists dot realsoftware dot com>
Subject: Re: SQL Error with REAL Database
From: Kristin Green <kristin at greenapple dot on dot ca>
Date: Wed, 30 Jun 2004 12:17:51 -0400
Delivered-to: gettingstarted at lists dot realsoftware dot com
List-help: <mailto:gettingstarted-request@lists.realsoftware.com?subject=help>
List-id: Getting Started <gettingstarted.lists.realsoftware.com>
List-post: <mailto:gettingstarted@lists.realsoftware.com>
References: <5283CF7E-CAAE-11D8-B11D-000A9586AE9A at greenapple dot on dot ca> <1E3FAFD1-CAAF-11D8-929D-000D9336142C at truetech dot org>
Arrggh! Then why is the option there! :-(

Why would they do that to me? Why?

While we're on the topic, how would one implement 'auto-increment' and ensure that the field is unique?


On Jun 30, 2004, at 12:04 PM, Brad Rhine wrote:

On Jun 30, 2004, at 11:58 AM, Kristin Green wrote:

- choose 'Options' and specify that it be a unique field or mandatory (or both, it doesn't seem to matter)

I get this error....

SQL Error: comma or parenthesis expected [07000]

The REAL Database doesn't (yet) support column constraints, such as primary key or unique. Remove the constraints and it'll work fine.

--
brad at truetech dot org
http://truetech.org
<><

_______________________________________________
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>


_______________________________________________
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

<Prev in Thread] Current Thread [Next in Thread>