I have discovered that SQLite function sqlite_query runs sqlite_exec 
function if it's return value is used and sqlite_compile/sqlite_step combo 
if return value is used. I think this is a problem - if I want to run some 
pack of queries (like, create whole DB schema in one call), I can do it 
with sqlite_query - but only if I don't check the return value - and thus 
don't know if it succeeded or not! If I check the return value, it runs 
sqlite_compile/sqlite_step, which can not run multiple SQL statements. 

I think this should be fixed. In order not to break BC, I propose to add 
new function to SQLite API - sqlite_exec, which - surprise! - would always 
call sqlite_exec and would return only true/false. Though, the even better 
solution would be to kill that return_value_used check altogether and use 
two separate functions always, depending on the task.

Any thoughts about this?
-- 
Stanislav Malyshev, Zend Products Engineer   
[EMAIL PROTECTED]  http://www.zend.com/ +972-3-6139665 ext.115

-- 
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to