Re: M. Lemos's form class questions

On Mon, 16 Oct 2000, Meir kriheli wrote: > Hi Manuel, > > > BTW, PHP Interbase API developer (jah) mentioned that for the time being he > > does not have the time to fix the problem with direct queries being > > implemented with prepared queries. Since that prevents us from creating > > Interbase databases using SQL statements, I wonder if you have the time to > > have a look and write a patch to have it done right. > > Well, it should take me alot more time to do this (I'll have to learn the > Interbase API), so I can't promise anything :-( I've been already at least thinking about the problem. To be able to determine the type of an SQL query issued with isc_dsql_sql_info(), it *must* be prepared first. So that's why they are prepared. Another thing is that, according to the InterBase API documentation, even those functions meant for immeadiate execution of SQL statements *do* prepare the statement, with the exception being a case when both database and transaction handle are NULLs and the statement is 'CREATE DATABASE'. For the needs of MetaBase, I think the easiest solution will be to create functions ibase_create_database(), ibase_drop_database and maybe ibase_do() that calls isc_dsql_execute_immediate() (if there appears to be more SQL statements that have problems with the way the module currently works. You know any?). Would this be a sufficient solution? At least it would be the easiest one. -- Jouni Ahto