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 <[email protected]> wrote:
From: EMERSON VIER <[email protected]> Subject: [nsbasic-ce] SQL SELECT WHERE To: [email protected] 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nsb-ce?hl=en -~----------~----~----~----~------~----~------~--~---
