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 <[email protected]> wrote:
From: EMERSON VIER <[email protected]> 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 -~----------~----~----~----~------~----~------~--~---
