Re: Database SQL statement

Hi Jim
Try With N in double quotes = "N"
Just my 2cBest regards Beent 
-------- Oprindelig besked --------Fra: Jim Wagner <[email protected]> Dato: 20/09/2017  21.57  (GMT+01:00) Til: Nug <[email protected]> Emne: Database SQL statement 
Greetings -
Database = MySQL
I have been through the LR and the Tutorials and now the Users Guide (Framework > Databases) and I am stumped. I remember that something special was needed for this on the RBDatabase but I cannot recall what.
I want to have a WHERE statement to be defined by a program-generated variable, as in
Dim N as integer = (row ID obtained elsewhere)Dim deleteSQL as string  = “DELETE FROM Event WHERE ID =  ’N'”
But that won’t work because N must be a number defined by the program and the previous expression will take N literally as a string. 
I’ve also been though a fair amount of MySQL documentation and have yet to find anything that illuminates this. Its probably there, but just not yet found. 
Can someone help?
Many ThanksJim

James WagnerOregon Research Electronicshttp://www.orelectronics.net








To unsubscribe, email us here.


To unsubscribe, email [email protected]