Re: What is a database record?

[Will Leshner <will dot leshner at gmail dot com>]

On Tue, 28 Dec 2004 14:58:17 -0500, Wayne Dreier
<realbasicnovice at macdialup dot com> wrote:

> I know, you'll reply with something like -  "You have to tell RecordSet
> the number of rows"

No, actually I was going to say that the RecordSet tells you how many
rows it has. For example, let's say you wanted all the rows where the
lastname field was "Smith". You'd use a query like this:

rs = db.SQLSelect("Select firstname,lastname,age,whatever from
sometable where lastname='Smith')

Exactly how many rows that it is you won't know until you get the
results back from the database. Then you can loop through the
RecordSet, adding each record (row) to your ListBox.

-- 
REALbasic database options: http://sqlabs.net
REALbasic news and tips: http://rbgazette.com
KidzMail & KidzLog: http://haranbanjo.com
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://www.realsoftware.com/listarchives/lists.html>