--- In [email protected], "EMERSON VIER" <emersonv...@...> 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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
