--- In [email protected], "bwolodko" <ben.wolo...@...> 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 -~----------~----~----~----~------~----~------~--~---
