Re: Database SQL statement

I found by experimenting that 

“DELETE FROM Event WHERE ID = “ + str(N)

does what I need.

Thanks
Jim

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




> On Sep 20, 2017, at 1:44 PM, beejorge <[email protected]> wrote:
> 
> Hi Jim
> 
> Try With N in double quotes = "N"
> 
> Just my 2c
> Best regards 
> Beent 
> 
> -------- Oprindelig besked --------
> Fra: Jim Wagner <[email protected]>
> Dato: 20/09/2017 21.57 (GMT+01:00)
> Til: Nug <nug-Ktk10zIkF/Jvqtv/[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 Thanks
> Jim
> 
> James Wagner
> Oregon Research Electronics
> http://www.orelectronics.net <http://www.orelectronics.net/>
> 
> 
> 
> 
> 
> To unsubscribe, email us here. <mailto:[email protected]>
> To unsubscribe, email us here. <mailto:[email protected]>



To unsubscribe, email [email protected]