RE: [PEAR-DEV] Re: MDB 2.x
| From: | Lukas Smith | Date: | Thu, 21 Aug 2003 11:21:59 +0000 |
| Subject: | RE: [PEAR-DEV] Re: MDB 2.x | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-20238@lists.php.net to get a copy of this message | ||
> From: Michael Wallner [mailto:m.wallner@iworks.at]
> Sent: Thursday, August 21, 2003 1:08 PM
> The <start> Element of sequences is labeled optional with a default
> value of 1, but the Manager creates the SQL statement as follows:
>
> CREATE TABLE test_user_id_seq
> (sequence INT NOT NULL IDENTITY(,1) PRIMARY KEY CLUSTERED)
> ^^^^
> which fails of course with:
> "nativecode = 170 - Line 1: Incorrect syntax near ','"
just to clarify .. what should the query be for the default case?
Regards,
Lukas