Re: [CDE-chat] parsesql ideas

[Lucian R. <luc...@gm...>]

Hi Andre,

  I'll start thinking on the diagram for each common instruction select,
insert, update, delete .
  Another thing, even I haven't seen till now the case when stocked
procedures (suported at least by MSSQL and MySQL starting with version 5)
used with php, we will support only execution of them. Trigers? I don't
know, may be someone will use this tool for creating a cms for database
management. Anyways we'll start with the base part and if requested some
features could be added.

Kind regards,
Lucian Rosu

On Tue, Sep 2, 2008 at 11:25 AM, Andre van Zuydam <an...@sp...>wrote:

> Hi Lucian
>
> If you and I can start working on this solution immediately it would be
> good!
>
> In firebird the expression you talked about would be implemented as
>
> select first 1000 next 500 * from table
>
> There is a little problem with where the keywords go but if we can
> create a middle ground for the sql which then can be put into any
> dialect it would be good.
>
> i.e.
>
> select first 1000 next 500 * from table = select * from table from 500
> to 1000
> select * from table limit 500, 1000 = select * from table from 500 to 1000
>
> Both statements give us the same answer in our parsesql function which
> we then translate to the applicable database with "rules" for that
> database.
>
> I think we can start by working out how different SQL queries can be
> translated into either an ANSI dialect or something we come up with to
> help get the job done
>
> Yours sincerely
>
> Andre van Zuydam
>
> -------------------------------------------------------------------------
> 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
>