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: Art Isbell <email@hidden>
- Date: Tue, 25 Mar 2003 08:48:27 -1000
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.
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.
Aloha,
Art
_______________________________________________
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.