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 <hwoody2w...@...>
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 <emersonv...@...>
> 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
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
