RE: [PEAR-DEV] Re: MDB 2.x
| From: | Lukas Smith | Date: | Thu, 21 Aug 2003 11:48:20 +0000 |
| Subject: | RE: [PEAR-DEV] Re: MDB 2.x | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-20242@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 ','"
Hmm I made some improvements, but it is really odd that you are getting
this error. The Manager should actually make sure that the start is not
empty (it now ensures that it is an integer).
I will have to ponder this one.
Regards,
Lukas