<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>hello,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have a field "MySQL_query_build" that
contains :</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>UPDATE catalogue SET videoprojecteur = 'non' WHERE
ref = 'SONYVPLCS3';<BR>UPDATE catalogue SET videoprojecteur = 'non' WHERE ref =
'POLAVIEW270';<BR>UPDATE catalogue SET videoprojecteur = 'non' WHERE ref =
'EPSONEMP50';<BR>etc.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>In a button, I have:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>on mouseUp<BR> <BR>
put revdb_execute(the MySQL_id_connection of this card, field
"MySQL_query_build") into field "MySQL_result"</FONT></DIV>
<DIV><FONT face=Arial size=2> <BR>end mouseUp</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>and the function return : </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>You have an error in your SQL syntax near
';<BR>UPDATE catalogue SET videoprojecteur = 'non' WHERE ref =
'POLAVIEW270';<BR>UPDATE' at line 1</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Why?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>of course, the content of my field is a correct SQL
query</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>thanks</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></FONT></DIV>
<DIV><FONT face=Arial size=2>Sylvain Le Gourriérec ——
développement —— son-video-distribution</FONT></DIV></BODY></HTML>