Re: [CDE-chat] parsing...

[Andre v. Z. <an...@sp...>]

Yes, it is the translation of the different SQL statements between 
database dialects.
We must aim to conform to an ANSI compliancy.

Have a look at the parsesql function to get an idea of what its about.

An easy example is: [top] in access is [first] in firebird.

Example:  I wrote a simple application in access to get the top ten 
users of a website but now someone wants to run it on a Firebird 
database, I say no problem because I know that the engine support cross 
database coding.

Here is my query in access:

select top 10 * from webusers

Now the CDE engine realises that the connection is to a Firebird 
database so it needs to check that the keywords from other database 
systems get the same results.
Running parsesql on the above query will return: select first 10 * from 
webusers which then gets used in the query.

I hope this is clear, let me know if I must explain some more.



Linux Iraqi wrote:
> hi andre and everyone...
>
> about parsing...
>
> is it means about formating* the sql statement ...?
> like here
>
> http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl
>
> or its something else...?
>
> ashraf
>
>
> * coloring - separating sql by lines - capitalizing keywords... etc.
>
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ------------------------------------------------------------------------
>
> _______________________________________________
> cdeengine-chat mailing list
> cde...@li...
> https://lists.sourceforge.net/lists/listinfo/cdeengine-chat
>