We are executing a query which does a select from two different tables and does a union.(For eg : select phonename,uid from contact_primary_info union select name,itemId from Contact_SIM order by 1 ASC; ) We are seeing that Sqlite lib is calling a openFile call two times with the same file name during this select operation.The second time the openFile call is For the first time,the sqlite library passed the following flag values: isExclusive: 16 isDelete : 8 isCreate : 4 isReadOnly : 0 isReadWrite :2 Before closing the file,sqlite library again passed the same flag values with the same file name.Can anyone please explain if there is a chance that sqlite does like this without closing the previous file that is opened?
Best Regards, N.Rajesh Courage is the knowledge of how to fear what ought to be feared and how not to fear what ought not to be feared. _________________________________________________________________ Post free property ads on Yello Classifieds now! www.yello.in http://ss1.richmedia.in/recurl.asp?pid=221 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users