| View previous topic :: View next topic |
| Author |
Message |
BLLittle
Newbie
Joined: 12 Jan 2012
Posts: 3
|
 Posted: Thu Jan 12, 2012 11:07 pm Post subject: Trouble with AUTO_INCREMENT |
 |
|
I keep getting an error message when either trying to create or alter a table to include an auto field:
SQL Status: 37000
Error code: -11
Unexpected token: AUTO_INCREMENT
I have searched the forums and tried a number of suggestions, but keep getting this. What's up with it? |
|
| Back to top |
|
 |
probe1
Moderator
Joined: 18 Aug 2004
Posts: 2465
Location: Chonburi Thailand Asia
|
| Posted: Thu Jan 12, 2012 11:25 pm Post subject: Re: Trouble with AUTO_INCREMENT |
|
|
Welcome to the forum.
| BLLittle wrote: | | What's up with it? |
If you DID search forum or internet you'd find out, that the SQL syntax depends on the database engine you are using.
Assuming you use the built-in HSQLDB it is
| Code: | | alter table "tablename" alter column "columnname" identity |
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs |
|
| Back to top |
|
|
BLLittle
Newbie
Joined: 12 Jan 2012
Posts: 3
|
| Posted: Fri Jan 13, 2012 6:30 pm Post subject: |
|
|
Thank you for your welcome and guidance. Yes, I DID search the forum -- for some 3 hours. I am NOT a computer neophyte nor a SQL beginner and what you've pointed out was NOT clear in any of the posts I reviewed, nor for that matter in the instructions/documentation included in the download for install.
Because of the lack of clarity in the documentation, I just don't get the arrogance and condescension that seems to be part of the culture of these forums. I'm not trying to single you out, but questioning something that is explicitly stated ( | Quote: | | If you DID search forum or internet |
) is not setting a particularly welcoming tone. I write SQL to access data in Oracle and Teradata databases for a living, using SAS for analysis. All these tools demand an attention to the kind of detail you brought to my attention that was NOT clearly stated in any of the posts I reviewed prior to my posting.
The tools in the suite seem to be powerfully featured -- but they are not ready for prime time when the documentation and the supporting user community acts as though variations in implementation are clear and self-evident. |
|
| Back to top |
|
|
mgroenescheij
Super User
Joined: 20 Apr 2011
Posts: 862
Location: Australia
|
| Posted: Sat Jan 14, 2012 3:13 am Post subject: |
|
|
Hi,
If your NOT a computer neophyte nor a SQL beginner you could have explained under what circumstance the error occurred, what database your using, which version of OpenOffice or LibreOffice you used, the OS you running on etc.
Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
BLLittle
Newbie
Joined: 12 Jan 2012
Posts: 3
|
| Posted: Wed Jan 18, 2012 6:28 am Post subject: |
|
|
Thank you for so brilliantly illustrating my point: Operating system is totally irrelevant to a question about the syntax of a SQL statement.
As to your other requests, sure, I could have included those. After two hours of searching the forums and finding conflicting information, none of which worked, I was remiss from frustration. For that I apologize. |
|
| Back to top |
|
|
|
