If you can find a way of dropping a table which doesn't exist, use it.
Otherwise just drop the table.
Cecilia VIGNY wrote:
Hi,
I'm using SQLite with a PHP program and I would like to execute this SQL
request : DROP TABLE IF EXISTS clients;
See my code :
$allsqls=<<<SQL
DROP TABLE cmsa;
SQL;
$sqlite = sqlite_open('pac.sdb') or die ('Impossible de se connecter a
la base SQLite');
//Création des tables dans la base SQLite
$sqls=explode("\n",$allsqls);
foreach(array_values($sqls) as $sql)
{
$sql = sqlite_query($sqlite, $sql) or die('Impossible d\'executer la
requete');
}
When I test my program, this error occures :
Warning: sqlite_query(): near "EXISTS": syntax error in .... on line 61
Why ? Can't we use "IF EXISTS" with php ? Does another solution exist ?
Thank you for your help :)
Ce message est protégé par les règles relatives au secret des
correspondances. Il est donc établi à destination exclusive de son
destinataire. Celui-ci peut donc contenir des informations
confidentielles. La divulgation de ces informations est à ce titre
rigoureusement interdite. Si vous avez reçu ce message par erreur, merci
de le renvoyer à l'expéditeur dont l'adresse e-mail figure ci-dessus et
de détruire le message ainsi que toute pièce jointe.
This message is protected by the secrecy of correspondence rules.
Therefore, this message is intended solely for the attention of the
addressee. This message may contain privileged or confidential
information, as such the disclosure of these informations is strictly
forbidden. If, by mistake, you have received this message, please return
this message to the addressser whose e-mail address is written above and
destroy this message and all files attached.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------