Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Creating A table
Tue, Dec 9 2008 8:31 AMPermanent Link

Allan Brocklehurst
Hello;
Stats: EDB2.02(5)

The Attached is hitting the wall
on this line
EXECUTE IMMEDIATE 'CREATE TABLE "ORMEDClosetLists"

I cannot see where or why it is bombing. I have other scripts that build tables that are in the same format anbd are working?

Does anyone see something in this script that I am missing

TIA

Allan



Attachments: Build_ClosetList.sql
Tue, Dec 9 2008 10:35 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Allan,

You are specifying collation for the INTEGER columns - that's the problem.

--
Fernando Dias
[Team Elevate]
Tue, Dec 9 2008 10:52 AMPermanent Link

Allan Brocklehurst
Fernando;
your  the man

thanks buddy

Allan

Fernando Dias <fernandodias.removthis@easygate.com.pt> wrote:

Allan,

You are specifying collation for the INTEGER columns - that's the problem.

--
Fernando Dias
[Team Elevate]
Image