You are encloseing value1 within quotes, so what gets passed to the sql engine is the name value1 which is interpeted as the name of a column. What you need to have is "select * from tablename where columnname =>" + value1 This way the engine gets passed the query along with the value in value1.
Harold Wood & Meyuni Gani -----Original Message----- From: EMERSON VIER <[email protected]> Sent: Monday, May 25, 2009 7:50 PM To: [email protected] Subject: [nsbasic-ce] SQL SELECT WHERE 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 -~----------~----~----~----~------~----~------~--~---
