I undested your information, but I need search the data on my database by SQL function WHERE or other.
Can you help me? EMERSON VIER --- In [email protected], Harold Wood <hwoody2w...@...> wrote: > > the query looks good now. remember that nsbasic treats a record set as a > multidimensial array, > with so you shoudl first look at the recordcount property fo r to determine > how many rows were returned then loop thru the columns to return the > individual fields. > > Dim recsBack > dim recRead > dim curRec > dim Cols > > recsBack = r.RecordCount > > recRead = 1 > > while recRead < recsback > for Cols = 1 to r(recRead).Count Step 1 > msgbox r(recRead)(Cols) > next > RecRead = recRead + 1 > wend > > > see if that helps. > Woody > --- On Thu, 5/21/09, EMERSON VIER <emersonv...@...> wrote: > > > From: EMERSON VIER <emersonv...@...> > Subject: [nsbasic-ce] Re: SQL WHERE > To: [email protected] > Date: Thursday, May 21, 2009, 12:07 PM > > > > > > > > > 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 [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 -~----------~----~----~----~------~----~------~--~---
