Put this in the front of your sql statement for creating the table "IF TABLE NOT EXISTS " (Which I think is correct, if not then it's very close). Is this not in the help file examples?
-----Original Message----- From: [email protected] on behalf of markflex2007 Sent: Mon 25/08/2008 16:35 To: [email protected] Subject: [flexcoders] How to check a table already exist in SQLite? Hi, I am doing a AIR application. I want to check if a table already in database. I create a new one if it doesn't exist. The application will give me error "table already exist" if I do not do the check. Please let me know how to do the check to see if a table already exist. Thanks Mark ______________________________________________________________________ This communication is from Primal Pictures Ltd., a company registered in England and Wales with registration No. 02622298 and registered office: 4th Floor, Tennyson House, 159-165 Great Portland Street, London, W1W 5PA, UK. VAT registration No. 648874577. This e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient. If you have received it in error, please contact the sender immediately by return e-mail or by telephoning +44(0)20 7637 1010. Please then delete the e-mail and do not disclose its contents to any person. This email has been scanned for Primal Pictures by the MessageLabs Email Security System. ______________________________________________________________________
<<winmail.dat>>
