Fwd: Database SQL statement

Slight error -

Database = SQLite

Jim

James Wagner
Oregon Research Electronics
http://www.orelectronics.net <http://www.orelectronics.net/>




> Begin forwarded message:
> 
> From: Jim Wagner <[email protected]>
> Subject: Database SQL statement
> Date: September 20, 2017 at 12:57:58 PM PDT
> To: Nug <nug-Ktk10zIkF/Jvqtv/[email protected]>
> 
> 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 Thanks
> Jim
> 
> James Wagner
> Oregon Research Electronics
> http://www.orelectronics.net <http://www.orelectronics.net/>
> 
> 
> 
> 




To unsubscribe, email [email protected]