Subject | Re: [IBO] Re: The plot thickens. Additional access errors |
---|---|
Author | Jason Wharton |
Post date | 2001-01-23T05:11:54Z |
Dale,
totally disabled by default.
MyDSQL.Prepare;
try
MyDSQL.ExecSQL;
finally
MyDSQL.Unprepare;
end;
In yoru case, I still think your GDS32.DLL is wrong. Check its timestamp.
HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
> Thank you for your reply.What are the versions indicated by each of them?
> <HB>
> > The "trial components" are the same as the registered version.
>
> It is funny because I uninstalled the release version and reinstalled
> the trial version. Now everything works well again.
> <HB>If you don't know how to use it then you don't have to worry about it. It is
> > Delete the schema cache, as a first step. You need to do that each
> time
> > you change metadata. Having schema caching during development is
> thus not
> > a good idea.
>
> I was not aware that I had created the/a schema cache. Not wanting
> to sound stupid, what is it and how do I delete it.
totally disabled by default.
> <HB>You need to do this in order to avoid the bug:
> > Do you know about the InterBase bug that requires you to prepare a
> stored
> > procedure EVERY time you call it?
>
>
> No I was not aware of this bug. I do however use the prepare
> statement. I have a IB_DSQL (the sp only returns one row so I used
> this component) with the SQL of
> "Select * from ADD_Directory
> (:Directory_Type, :Directory_Class, :parent_id,
> :supervisor_id, :description, :email, :name)"
> The stored procedure returns the ID (integer) of the new object.
> This GPF is happening in an ASTA Business Object when I call
> ExecSQL. Here is the portion of the code for that ASTA BO:
>
>
> // Add the directory
> with spAddDirectory do begin
> prepare;
> ParamByName('Directory_Class').value :=
> ClientParams.ParamByName('Directory_Class').value;
> ParamByName('Directory_Type').value :=
> ClientParams.ParamByName('Directory_Type').value;
> ParamByName('parent_id').value :=
> ClientParams.ParamByName('parent_id').value;
> ParamByName('supervisor_id').value :=
> ClientParams.ParamByName('supervisor_id').value;
> ParamByName('description').value :=
> ClientParams.ParamByName('description').value;
> ParamByName('email').value :=
> ClientParams.ParamByName('email').value;
> ParamByName('name').value :=
> ClientParams.ParamByName('name').value;
> ExecSQL;
> Directory_ID := Fieldbyname('Out_Directory_ID').AsInteger;
> end;{with spAddDirectory}
MyDSQL.Prepare;
try
MyDSQL.ExecSQL;
finally
MyDSQL.Unprepare;
end;
In yoru case, I still think your GDS32.DLL is wrong. Check its timestamp.
HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com