[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice-devel
Subject:    Re: KSpread Kexi Import Filter
From:       Adam Pigg <piggz1 () gmail ! com>
Date:       2006-08-16 21:46:38
Message-ID: 200608162246.38466.adam () piggz ! co ! uk
[Download RAW message or body]

On Wednesday 16 August 2006 22:35, Jaroslaw Staniek wrote:
> Martin Ellis said the following, On 2006-08-16 21:28:
> > (It's an awkwardness of the KexiDB API that it's easier to pass an SQL
> > query directly to the DB engine, rather than use the KexiDB parser.)
>
> This "feature" is for historical reasons, awaiting for massive API polish
> in 2.0 (where hopefully more apps will use the API; KSpread is actually the
> first in KOffice). So, don't worry about this.
>
> To Adam: you should really use the parser instead of playing. This will
> catch user's errors. Moreover, Sebastian has started to use the parser and
> thus removed a security hole (hint: you can assert that only SELECT queries
> will be executed) :)

oh yeah...dont want to be able to type a 'drop' query :)

>
> Example use from KexiQueryPart::loadSchemaData():
>
> 	KexiDB::Parser parser(connection);;
> 	parser.parse( sqlText );
> 	KexiDB::QuerySchema *query = parser->query();
>
> Disadvantage: the queries are limited by what KexiDB accepts and what the
> parser currently accepts.
>
> BTW- I think about a query statements entered into the formula bar. How
> could we define that? (ther result of the function would be a table of
> values...)

-- 
PiggZ
adam@piggz.co.uk
www.piggz.co.uk

First, let me make it very clear, poor people aren't necessarily 
killers. Just because you happen to be not rich doesn't mean 
you're willing to kill." 
-President George W. Bush, Washington, D.C., May 19, 2003
_______________________________________________
koffice-devel mailing list
koffice-devel@kde.org
https://mail.kde.org/mailman/listinfo/koffice-devel
[prev in list] [next in list] [prev in thread] [next in thread]