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 [email protected]