Re: [sqlite] Re: How to change priority in compound SELECTs?

. Will this bring much negative effects to runtime efficiency when I have lot of UNION results to INTERSECT? Best regards, Nan Ye Igor Tandetnik wrote: Nan Ye <nan.ye-nwzjn9QkdiXhIMfW0+CuwW/[EMAIL PROTECTED]> wrote: If I used UNION and INTERSECT in compound SELECTs, how to change the default pr

[sqlite] How to change priority in compound SELECTs?

HERE value < 4.0 UNION SELECT id FROM sample_b WHERE value > 7.0); But I got an error: SQL error: near "(": syntax error. Best regard, Nan Ye - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Problem with warning: SQL error or missing database

Jay Sprenkle 写道: On 4/27/06, Nan Ye <[EMAIL PROTECTED]> wrote: Hi, I have met some problems when I opened the same database file twice in the same process. Why are you opening the same database twice? Are you trying to simulate multiple processes or threads? -- SqliteImporter: C

[sqlite] Problem with warning: SQL error or missing database

table 2 and sometimes the data will be insert corretle and sometimes not. Just now, I found this error will NOT happen definitely if I close the database after I have created the tables and reopen it before I insert data to it. Is there some important step I missed or any other solution for this problem? Regards, Nan Ye