At 03:28 PM 03-03-01 -0500, you wrote:

>No. I made a dummy variable of AnsiString and assigned
>DirQuery->FieldByName("STID")->AsString to it and it worked fine. I just
>compiled the blob insert sample because it uses a DSQL component and it has
>the same Access Violation at the same memory location. I hope it is not a
>quirk with 3.06 Cf and BCB 5.

Maybe...can't test...but it's not a problem with tib_dsql with Delphi, same IBO version.

But my question was whether, at the time you are loading the values for the params of the dsql, the FieldByName value from DirQuery is unavailable.

Helen

>Leigh
>
>-----Original Message-----
>From: Helen Borrie [mailto:helebor@...]
>Sent: Saturday, March 03, 2001 2:40 PM
>To: IBObjects@yahoogroups.com
>Subject: Re: [IBO] AV with ParamByName in DSQL component
>
>
>At 01:15 PM 03-03-01 -0500, you wrote:
> >I am using 3.6Cf with BCB 5. I am trying to use a DSQL component to
>insert
> >a record into a table. I am using the following SQL statement:
> >INSERT INTO BPCSTUDENT (STID, LNAME, FNAME, MI,
> > FNAME_P, LNAME_P, PHONE, PHONE_H, GR, RETAINED,
> > SEX, NAME, CITYSTATE, PARENT, LASTFIRST,
> > STREETADD, RACE)
> >VALUES (?stid, ?lname, ?fname, ?mi,
> > ?fname_p, ?lname_p, ?phone, ?phone_h, ?gr, 'F',
> > ?sex, ?name, ?citystate, ?parent, ?lastfirst,
> > ?streetadd, ?race)
> >
> >in the DSQL editor the statement prepares and executes (it inserts a blank
> >record). In code I prepare the statement then issue the following line:
> >BPCStu->ParamByName("STID")->AsString =
> >DirQuery->FieldByName("STID")->AsString; I get a Access Violation of some
> >address 42495408.
> >
> >BPCStu is the TIB_DSQL component and DirQuery is a TIB_QUERY component.
> >
> >This is the first time I have used the DSQL component. What am I doing
> >incorrectly?
>
>Is DirQuery somehow getting closed before the assignment?
>
>Helen
>
>All for Open and Open for All
>InterBase Developer Initiative · http://www.interbase2000.org
>_______________________________________________________
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________