Re: [nsbasic-ce] Re: SQL SELECT WHERE

Emerson   the code should be Dim Value1 Value1 = 19 Set records=db.Execute ("SELECT * FROM People_DB WHERE Age>= " &cstr(Value1))   the above works here great.   can you send me the schema you use for your people_DB?  i can write you schema for a view that autocalculates the age.   Woody   Tue,

[nsbasic-ce] Re: SQL SELECT WHERE

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>

Re: [nsbasic-ce] Re: SQL SELECT WHERE

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.   als

[nsbasic-ce] Re: SQL SELECT WHERE

Ben, Thx, but not work for me I test the all option. EMERSON VIER --- In nsbasic...@yahoogroups.com, "bwolodko" wrote: > > --- In nsbasic...@yahoogroups.com, "bwolodko" wrote: > > > > --- In nsbasic...@yahoogroups.com, "EMERSON VIER" wrote: > > > > > > I know abou error mensage, but I need th

[nsbasic-ce] NSBasic Window Classname

Hi All, I'm trying to search for my NSB app by classname from another app and was wondering something. What's the window classname for NSBasic-made apps? Is there a standard one or is it whatever our program is named? Thanks, Shaun --~--~-~--~~~---~--~~ You

[nsbasic-ce] NS Basic/CE 8.0 Released!

We're pleased to announce that NS Basic/CE 8.0 is ready! The new release is much more usable. Several of the enhancements greatly simplify the process of getting your app to run on other devices. Some of the improvements are: o You can embed pictu

[nsbasic-ce] Re: SQL SELECT WHERE

--- In nsbasic...@yahoogroups.com, "bwolodko" wrote: > > --- In nsbasic...@yahoogroups.com, "EMERSON VIER" 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 * F

[nsbasic-ce] Re: SQL SELECT WHERE

--- In nsbasic...@yahoogroups.com, "EMERSON VIER" 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 su

[nsbasic-ce] Re: SQL SELECT WHERE

I try use ""Value1"", "Value1" but not work to. Thx EMERSON VIER --- In nsbasic...@yahoogroups.com, brian smith wrote: > > Im no SQL expert. > but I remember reading that you have to do something like this > Set records=db.Execute( "SELECT * FROM People_DB WHERE Age >= '"Value1"' ")  >   >

[nsbasic-ce] Re: SQL SELECT WHERE

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 ns

[nsbasic-ce] Re: Memory leak

--- In nsbasic...@yahoogroups.com, "bwolodko" wrote: > > --- In nsbasic...@yahoogroups.com, "ghidera2000" wrote: > > > > Actually, it was a ghidera2000 issue. The device comes with a 2006 > > release of basic.exe and I had been installing the newer basic before > > developing. I'd forgotten to