[DB-SIG] API suggestion: expose 'quote' method

[Chris Cogdon]

On Thursday, Jun 5, 2003, at 17:00 US/Pacific, Greg Ewing wrote:

> Chris Cogdon <chris at cogdon.org>:
>
>> I know that the postgresql and mysql drivers gleen the datatype
>> information only from the data being passed as parameters. Do any 
>> other
>> drivers get this from other places, such as the sql or from 
>> information
>> back from the database ?
>
> Yes. I'm working with the Firebird (formerly Interbase) API at the
> moment, and it does exactly this. You give it an SQL query containing
> '?' markers, and it parses and fully groks it, consults the database
> metadata, and gives you back a structure describing the expected types
> of all the parameters.
>
> It would be utterly impossible to get it to do this with anything less
> than a fully-formed syntactically and semantically correct SQL
> statement.

Point conceded: if one can only do that with full-formed SQL 
statements, then any utility of being able to 'piecemeal' the SQL 
together using strings is defeated.

Thank you for giving me an idea on how 'other' databases work.

Oh... isn't firebird a browser?? *grins and ducks*


-- 
    ("`-/")_.-'"``-._        Chris Cogdon <chris at cogdon.org>
     . . `; -._    )-;-,_`)
    (v_,)'  _  )`-.\  ``-'
   _.- _..-_/ / ((.'
((,.-'   ((,/   fL