I try use ""Value1"", "Value1" but not work to.
Thx EMERSON VIER --- In nsbasic...@yahoogroups.com, brian smith <briman...@...> wrote: > > Im no SQL expert..... > but I remember reading that you have to do something like this > Set records=db.Execute( "SELECT * FROM People_DB WHERE Age >= '"Value1"' ") > > so to get the value of the variable in your SELECT....that would be single > quote...double quote (variable)...double quote...single quote > --- On Mon, 5/25/09, EMERSON VIER <emersonv...@...> wrote: > > > From: EMERSON VIER <emersonv...@...> > Subject: [nsbasic-ce] SQL SELECT WHERE > To: nsbasic...@yahoogroups.com > Date: Monday, May 25, 2009, 7:50 PM > > > > > > > > > If a use this > > Value1 = 19 > > Set records=db.Execute( "SELECT * FROM People_DB WHERE Age >= Value1 ") > > Returt the Scripting Error "SQLite3COM - Line XXX, char O no such column: > Value1" > > If a use this > > Set records=db.Execute( "SELECT * FROM People_DB WHERE Age >= '19' ") > > Work very well > > But I need use the variable on place '19' because this value I need get from > TextBox > > EMERSON VIER > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nsb-ce" group. To post to this group, send email to nsb-ce@googlegroups.com To unsubscribe from this group, send email to nsb-ce+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nsb-ce?hl=en -~----------~----~----~----~------~----~------~--~---
