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
-~----------~----~----~----~------~----~------~--~---
