realbasic-nug
[Top] [All Lists]

Re: Rs.field() vs rs.idxfield()

To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: Rs.field() vs rs.idxfield()
From: "Joseph J. Strout" <joe at realsoftware dot com>
Date: Wed, 1 Dec 2004 14:33:46 -0600
Delivered-to: realbasic-nug at lists dot realsoftware dot com
References: <200412012002 dot iB1K2ESS027788 at mac dot com>
At 2:03 PM -0600 12/1/04, Steve Smith wrote:

In my app, the use of rs.field("Name") appears to be failing at times. I'm
looking at a debugging session now where using the Field() method returns
nothing and the idxfield() method on the same recordset returns the correct
data.

I've never known Field to fail when you give it a name that actually exists -- my guess is that the column names aren't what you think they are, and you're asking for a field that doesn't exist in the output. (Remember, an output table (aka RecordSet) is not generally the same as a table actually in the database.)

Can you reproduce this in a simple case where you know the column name is right but Field still fails?

- Joe

--
REAL World 2005 - The REALbasic User Conference
March 23-25, 2005, Austin, Texas
<http://www.realsoftware.com/realworld>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

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

<Prev in Thread] Current Thread [Next in Thread>