Ben, Thx, but not work for me I test the all option.
EMERSON VIER --- In [email protected], "bwolodko" <ben.wolo...@...> wrote: > > --- In [email protected], "bwolodko" <ben.wolodko@> wrote: > > > > --- In [email protected], "EMERSON VIER" <emersonvier@> wrote: > > > > > > I know abou error mensage, but I need the solution for this, my column is > > > Age and I need seach value for this when I make this > > > > > > Set records=db.Execute("SELECT * FROM People_DB WHERE Age >= '19' ") > > > > > > Work very well but I need sustitute the '19' to on variable. > > > > > > Thx for all > > > > > > EMERSON VIER > > > > > > > > > > > > --- In [email protected], Harold Wood & Meyuni Gani > > > <hwoody2wood@> wrote: > > > > > > > > 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 <emersonvier@> > > > > 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 > > > > > > > > > > > It would appeasr that what we need is a string > > > > would this work? > > > > Value1 = 19 > > > > Set records = db.Execute("SELECT * FROM People_DB WHERE Age >=" & > > CStr(Value1)) > > > > Are the ( ) braces required? > > > > Set records = db.Execute "SELECT * FROM People_DB WHERE Age >=" & > > CStr(Value1) > > > > In the NsBasic manual, the syntax is EXECUTE(string) > > > > But > > > > AddObject "NSCEPictureBox.NSCEPictureBoxCtrl.1",picName,X,Y,220,90 > > Execute picName & ".ScaleMode = 3" ' pixels > > Execute picName & ".BorderStyle = 0" ' none > > Execute picName & ".hide" > > > > works well. No Braces. > > > > Converting the number to a string and appending it. > > > > if all the Quotes are required i.e '19' ") > > > > > > then Set records = db.Execute("SELECT * FROM People_DB WHERE Age >=" & "'" > > & CStr(Value1) & "')" > > > > may work, just guessing > > > > Ben > > > > Just noticed that the web page version does not show the single quotes within > the double quotes to make up this string. > > If you open the message with a reply, the string shows correctly. > > Ben > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
