Re: [CDE-chat] parsesql ideas

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

Hi everybody,

  In my opinion the array would be a very important issue, it could manage
some important situations. For instance for MySQL the top 1000 rows clause
is
        select * from table LIMIT 0, 1000
 But parsing the next query
        select * from table LIMIT 500, 1000   -- selection of top 1000
records starting with the 501th record
from MySQL to MSSQL cannot be made directly but using some artificial
solutions, and one of them could be an array.
Hope you understand what I'm talking about. If not, waiting for questions.

Related to parsing function, I believe that each of us who has some more
experience in a database type could work on a part of it.
But first we need to create a logic scheme (diagram) for the parsing issue.
After the logic diagram is created and can be applied on any database type,
we can find the middle solution for parsing between different databases
type.

If nobody can manage this, I guess I could do some work on this, but that
only if in case that nobody has experience in this kind of issues.

All the best,
Lucian Rosu