Thx for all. EMERSON VIER --- In nsbasic...@yahoogroups.com, Harold Wood <hwoody2w...@...> wrote: > > yeah, i was thinking how to retrieve all rows in a result set. > > thanks > > woody > > --- On Sat, 5/23/09, Chris Kenworthy <chrisk...@...> wrote: > > > From: Chris Kenworthy <chrisk...@...> > Subject: [nsbasic-ce] Re: SQL WHERE > To: nsbasic...@yahoogroups.com > Date: Saturday, May 23, 2009, 5:53 PM > > > > > > > > > What do you want to show up as output in this example? You're selecting > 'every field in table namedb', so the msgbox command doesn't understand how > to show all those fields, in potentially more than one record. > > If you just want the first field, (firstname,) of the first record, then you > could use code like: > > cmd = "select * from namedb where lastname = '" & tbLastName.text & "'" > set r = db.execute (cmd) > val = r(1)(1) > msgbox val > > If you want both firstname and lastname, you could change the val line to: > val = r(1)(1) & " " & r(1)(2) > > Does this help? I think that you and Woody might have been talking at > cross-purposes, because he was thinking of looping over a large result set, > while you only wanted to pull a few values out of it. > > I believe that using a single quote inside your cmd is better SQLite syntax > than escaping a " by doubling it up. > > --- In nsbasic...@yahoogro ups.com, "EMERSON VIER" <emersonvier@ ...> wrote: > > > > Sorry I make mistake to write here I use this form > > > > cmd="SELECT * FROM NameDB WHERE lastname = """ & tbLastName.Text & """" > > showStatus cmd > > Set r=db.Execute( cmd) > > MsgBox & r & > > > > How I get the result for this action? > > > > > > I use this database NameDB sample > > > > FirstName LastName > > > > Joe Bob > > Henry Bill > > Tedy Herman > > > > Thx for all > > EMERSON VIER > > > > > > > > > > --- In nsbasic...@yahoogro ups.com, Harold Wood <hwoody2wood@ > wrote: > > > > > > you need a properly formatted query. > > > > > > > > > "select * from [table name goes here] where [column name goes here] = '" > > > & tbLastName.Text & "'" > > > > > > --- On Wed, 5/20/09, EMERSON VIER <emersonvier@ > wrote: > > > > > > > > > From: EMERSON VIER <emersonvier@ > > > > Subject: [nsbasic-ce] SQL WHERE > > > To: nsbasic...@yahoogro ups.com > > > Date: Wednesday, May 20, 2009, 10:16 PM > > > > > > > > > > > > > > > > > > > > > > > > > > > How I found the last name on the sample on TN15 > > > I try > > > > > > cmd="SELECT * FROM WHERE NameDB lastname = """ & tbLastName.Text & """" > > > showStatus cmd > > > Set r=db.Execute( cmd) > > > MsgBox & r & > > > > > > But this not return the line. > > > > > > 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 nsb-ce@googlegroups.com To unsubscribe from this group, send email to nsb-ce+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nsb-ce?hl=en -~----------~----~----~----~------~----~------~--~---