Re: diffenrences between providers / servers

[Rodrigo Moya <rodrigo linuxave net>]

> 
> The the main problem I encountered when developing db independend
> apps is
> that the SQL dialect you have to use when querying different data
> sources differs. The query is, for the most part, just
> passed on to the driver, isnt it? Just one example from ADO:
> parameters work fine with one datasource, but the same query
> doesnt (parameters in a union select) work with another one.
> 
> Isnt it possible to write a SQL abstraction layer that provides
> one defined SQL dialect and translates them into the data source's
> SQL ?
>
this is the purpose of the XML queries Vivien and Gerhard are discussing
about. Their purpose is exactly what you say, except that the format
being used is XML. This is because we plan to support non-DBMS data
sources (LDAP, POP3/IMAP, etc), and SQL is only supported by DBMS.
 
But of course, there is also support for sending SQL commands to the
providers. In fact, right now you could use any language, since as with
ADO/DAO, ODBC, the command is just sent over to the provider.

> How does gnome-db handle query's?
> 
> Jens
> 
> Why isnt it "Standardized Query Language" ? :-/
> 
yes, why not?