you arent understanding.
 
use a query to return a record set that matches your query criteria, then loop 
thru the record set per the example.
 
my method is used after teh query has selected the appropriate records from 
your database.
 
take a look at the example in http://www.nsbasic.com/ce/info/technotes/TT09.htm
 
it shows looping thru rows and columns after a query has already selected my 
desired rows.
 
Woody

--- On Thu, 5/21/09, EMERSON VIER <emersonv...@yahoo.com.br> wrote:


From: EMERSON VIER <emersonv...@yahoo.com.br>
Subject: [nsbasic-ce] Re: SQL WHERE
To: nsbasic...@yahoogroups.com
Date: Thursday, May 21, 2009, 4:31 PM








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 nsbasic...@yahoogro ups.com, Harold Wood <hwoody2wood@ ...> 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 <emersonvier@ ...> wrote:
> 
> 
> From: EMERSON VIER <emersonvier@ ...>
> Subject: [nsbasic-ce] Re: SQL WHERE
> To: nsbasic...@yahoogro ups.com
> 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 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to