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
-~--~~~~--~~--~--~---
