Re: EOModeler end SQL lines with a semi-colon, Sybase and OpenBase Don't like this
Re: EOModeler end SQL lines with a semi-colon, Sybase and OpenBase Don't like this
- Subject: Re: EOModeler end SQL lines with a semi-colon, Sybase and OpenBase Don't like this
- From: Chris Dillman <email@hidden>
- Date: Tue, 25 Mar 2003 14:00:26 -0600
On Tuesday, March 25, 2003, at 07:42 AM, Chris Dillman wrote:
EOModeler end SQL statement lines with a semi-colon, Sybase and
OpenBase Don't like this.
Is this a bug?
No. If you ask EOModeler to execute SQL statements to create
a table, the SQL it sends to the DB is correct. If you copy and
paste this SQL into an arbitrary SQL console, the end-of-statement
character may not agree with that of the SQL console.
Err..
Explain Why I see code that is generated in the SQL Generation window...
That is incorrect... and fails to run... but then runs fine in a SQL console
if the ; are removed...
Example EOModeler is making this...
CREATE TABLE ErrorTable (Data char(1023) NULL, Date datetime NULL,
Error char(1023) NULL, _rowid numeric NOT NULL, UserId char(1023)
NULL);
Example if I take SQL code that EOModeler makes and paste it into
Sybases's SQL console and remove the semi-colon everything seems
to work fine.
SQL consoles for different DB's use different
end-of-statement characters or words. Sybase's isql at one time
supported specifying the end-of-statement character or word.
Any idea where that might be or where I might look for it?
--
Email: email@hidden
iChat / AIM: email@hidden
Buy Art : http://www.starbounce.com
Listen to Music: http://www.trance-o-matic.com
Play Games: Plaid World Studios http://www.plaidworld.com
Learn game programming at http://www.idevgames.com
Day job: Software Engineer for http://www.riskwise.com, Part of LexisNexis
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.