Re: Database SQL statement

Hi Jim,  I think this may be what you’re looking for:

Dim N as integer = (row ID obtained elsewhere)
Dim deleteSQL as string  = “DELETE FROM Event WHERE ID = “ + Str(N) 

In SqlLite only strings need to be encased in quotes

Keith DeLong

> On Sep 20, 2017, at 12:57 PM, Jim Wagner <[email protected]> wrote:
> 
> 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 [email protected]