OpenOffice.org Forum :: [SOLVE] help SQL command error

[Home] [FAQ] [Search] [Memberlist] [Usergroups] [Register]

[Profile] [Log in to check your private messages] [Log in]

[SOLVE] help SQL command error

OOoForum.org Forum Index -> OpenOffice.org Base

View previous topic :: View next topic

Author

Message

john1123
General User

General User

Joined: 28 Jun 2012
Posts: 8

Posted: Wed Jul 04, 2012 10:31 pm Post subject: [SOLVE] help SQL command error

When i wan to reset the auto value command using SQL command I get this problem command to execute: ALTER TABLES "Payment" ALTER COLUMN "No" RESTART WITH 449 status: 1: Unexpected token: TABLES in statement [ALTER TABLES] may i know what happen is this? Last edited by john1123 on Thu Jul 05, 2012 12:50 am; edited 1 time in total

Send private message

RPG
Super User

Super User

Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland

Posted: Wed Jul 04, 2012 11:58 pm Post subject:

Reply with quote

Hello

I think change tables to table

Code:

ALTER TABLE "Payment" ALTER COLUMN "No"
RESTART WITH 449

For more information see
http://www.oooforum.org/forum/viewtopic.phtml?t=126871&highlight=restart

Romke
_________________
OOo 3.4.5 on openSUSE 12.1
Use this forum : http://user.services.openoffice.org/en/forum

Send private message

john1123
General User

General User

Joined: 28 Jun 2012
Posts: 8

Posted: Thu Jul 05, 2012 12:51 am Post subject:

thanks RPG i solve the problem edi

Send private message

Display posts from previous:

	OOoForum.org Forum Index -> OpenOffice.org Base	All times are GMT - 8 Hours
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group