Thanks, Steffen and Dave - updated.

Helen

At 09:26 AM 31-05-00 -0700, you wrote:

>
>Steffen is right -- dialect 2 is designed for migration from V5 / V6
>dialect 1 to V6 dialect 3.
>
>Helen - an addition for your table: (All from memory so forgive any errors)
>
>Differences from V5 SQL Dialect 1 to V6 SQL Dialect 1
>
>New Keywords:
> TIMESTAMP, TIME, EXTRACT, YEAR, MONTH, DAY, WEEKDAY, HOUR, MINUTE
> SECONDS, ?TYPE?, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP
>
>SQL Dialect 0 is no longer supported in V6 (official statement). (SQL
>Dialect 0 was replaced
>by dialect 1 in v4.0)
>
>
>
>
>>-----Original Message-----
>>From: Steffen Nyeland [mailto:steffen_nyeland@...]
>>Sent: Wednesday, May 31, 2000 1:18 AM
>>To: IBDI@egroups.com
>>Subject: Re: [IBDI] Differences in SQL Dialects
>>
>>Hi Helen,
>>
>>You wrote: What versions use Dialect 2?
>>
>>None, this is a IB6 feature, to help migrating dialect 1 to 3. So as I
>>understand it, if your set your client to run dialect 2, you will get
>>"warnings" where there might be conflicts when running dialect 3.
>>
>>But the experts will hopefully correct me if I'a wrong :-)
>>
>>Steffen
>>
>>
>>----------
>>Community email addresses:
>> Post message: IBDI@onelist.com
>> Subscribe: IBDI-subscribe@onelist.com
>> Unsubscribe: IBDI-unsubscribe@onelist.com
>> List owner: IBDI-owner@onelist.com
>>
>>Shortcut URL to this page:
>>
>><http://www.onelist.com/community/IBDI>http://www.onelist.com/community/IBDI
>>
>>
>>----------
>>Community email addresses:
>> Post message: IBDI@onelist.com
>> Subscribe: IBDI-subscribe@onelist.com
>> Unsubscribe: IBDI-unsubscribe@onelist.com
>> List owner: IBDI-owner@onelist.com
>>
>>Shortcut URL to this page:
>>
>><http://www.onelist.com/community/IBDI>http://www.onelist.com/community/IBDI

http://www.interbase2000.org
___________________________________________________
"Ask not what your free, open-source database can do for you,
but what you can do for your free, open-source database."
(J.F.K.)