Joe,
I have seen this same behavior with the RB DB (new format). I don't
think that I reported it because I just switched to the idxfield and kept
going.
Luke
> Message: 19
> 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
>
> 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>
|