Hello,
please note: the Execute statement doesn't know NSBasic variables, it
just knows a string. So you must form a valid SQL statement as a
string that contains the VALUES of your variables, not the variable
names.
Here is your example, with a msgbox statement so that you can see the
SQL statement before it gets executed (just for testing, you can
remove it when the SQL statement works):
Dim Value1
Dim strSQL ' just to make things easier
Value1 = 19
strSQL = "Select * from People_DB where Age >= " & Value1
msgbox strSQL
Set records=db.Execute(strSQL)
....
using a variable (strSQL) in which the SQL string is built before it
is used makes checking a little easier, particularly getting the
quotes right.
Kind regards
Thomas
Am 27.05.2009 um 04:35AM schrieb EMERSON VIER:
>
>
> Woody, I try your idea but not work too.
>
> I test this now and work
>
> Option 1 - WORK
> Dim Value1
> Value1 = 19
> Value1 = "'"&Value1&"'"
> Set records=db.Execute ("SELECT * FROM People_DB WHERE Age>=
> "&Value1&" ")
>
> Option 1 - WORK - Now I use this
> Set records=db.Execute ("SELECT * FROM People_DB WHERE Age>=
> "&"'"&tbsearch.Text&"'"&" ")
>
> Thx Woody and Ben for all help.
>
> EMERSON VIER
>
> --- In [email protected], Harold Wood <hwoody2w...@...>
> wrote:
> >
> > Emereson
> > your problem is that you arent forming the query statement
> correctly. the query statement should look like
> >
> > Set Records = Db.Execute("Select * from People_Db where AGE => " +
> Value1)
> >
> > the single quotes around a value are used for date and string
> columns, numbers dont use quotes.
> >
> > also you might want to set up a view with AGE as a computed
> column, then query the view.
> >
> > Woody
> >
> > --- On Tue, 5/26/09, EMERSON VIER <emersonv...@...> wrote:
> >
> >
> > From: EMERSON VIER <emersonv...@...>
> > Subject: [nsbasic-ce] Re: SQL SELECT WHERE
> > To: [email protected]
> > Date: Tuesday, May 26, 2009, 5:31 PM
> >
> >
> >
> >
> >
> >
> >
> >
> > Ben,
> >
> > Thx, but not work for me I test the all option.
> >
> > EMERSON VIER
> >
> > --- In nsbasic...@yahoogro ups.com, "bwolodko" <ben.wolodko@ ...>
> wrote:
> > >
> > > --- In nsbasic...@yahoogro ups.com, "bwolodko" <ben.wolodko@ >
> wrote:
> > > >
> > > > --- In nsbasic...@yahoogro ups.com, "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 nsbasic...@yahoogro ups.com, 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: nsbasic...@yahoogro ups.com
> > > > > > 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. NSCEPictureBoxCt rl.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
-~----------~----~----~----~------~----~------~--~---
