Hi,
I am using d7 enterprise / win2k prof

1: In the IDE opening TEDBQuery this works
   select id,surname,forenames from clients

This does not
select id,surname,forenames from clients where id = :id

#601 CLIENTS table corrupt (error reading index pages into cache)

However, if you put a default value into the parameter property it works


2: when running a test app with this in it in the onscroll event of
TEDBQuery qlist
I get the same error as in 1: and eventually it leads to an AV

with ( qDetails ) do
   begin
   DisableControls;
   Active:= False;
   ParamByName('id').value := qList.fieldbyname('id').value
   Active:= True;
   EnableControls;
end;

If it helps, it fails in edbcomps.pas in function GetQueryCursor  ( 7269 )

There may be a more general problem with creating record cursors as this
attempted run round on the parmeter problem gives the same errors

with ( qDetails ) do
   begin
   DisableControls;
   Active:= False;
   sql[1] := 'where id = ' + QuotedStr(qList.fieldbyname('id').value)
   Active:= True;
   EnableControls;
end;

Best wishes Ed.

"Edhrx" <ed@synergynewmedia.co.uk> wrote in message
news:06541626-9D8C-4263-AA50-15AF91EBB9ED@news.elevatesoft.com...
> Hi,
> I am using d7 enterprise / win2k prof
>
> 1: In the IDE opening TEDBQuery this works
>     select id,surname,forenames from clients
>
> This does not
> select id,surname,forenames from clients where id = :id
>
> #601 CLIENTS table corrupt (error reading index pages into cache)
>
> However, if you put a default value into the parameter property it works
>
>
> 2: when running a test app with this in it in the onscroll event of
> TEDBQuery qlist
> I get the same error as in 1: and eventually it leads to an AV
>
>  with ( qDetails ) do
>     begin
>     DisableControls;
>     Active:= False;
>     ParamByName('id').value := qList.fieldbyname('id').value
>     Active:= True;
>     EnableControls;
> end;
>
> If it helps, it fails in edbcomps.pas in function GetQueryCursor  ( 7269 )
>
>

Ed,

I will look into these issues and make sure they're addressed.

--
Tim Young
Elevate Software
www.elevatesoft.com

<< This does not
select id,surname,forenames from clients where id = :id

#601 CLIENTS table corrupt (error reading index pages into cache)

However, if you put a default value into the parameter property it works >>

Could you possibly send me the table that you're using ?  I can't get
anything bad to happen with parameterized queries here.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,
I now cannot reproduce the problem.
I was preparing the clients table to send across to you and decided to
re-migrate it from a dbisam 4 table.
I tested again and found this table dos'nt have the problem.

Overall I migrated about 90+ tables from an old project. I will test a few
more. Sorry if time wasted...

Ed..



"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:ED9177DC-8912-4C3A-8331-6139AA418C34@news.elevatesoft.com...
>
> << This does not
>  select id,surname,forenames from clients where id = :id
>
>  #601 CLIENTS table corrupt (error reading index pages into cache)
>
>  However, if you put a default value into the parameter property it works
>>
>
> Could you possibly send me the table that you're using ?  I can't get
> anything bad to happen with parameterized queries here.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Tim
Ok, now found the table with the problem.
Please find attached table.


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:ED9177DC-8912-4C3A-8331-6139AA418C34@news.elevatesoft.com...
>
> << This does not
>  select id,surname,forenames from clients where id = :id
>
>  #601 CLIENTS table corrupt (error reading index pages into cache)
>
>  However, if you put a default value into the parameter property it works
>>
>
> Could you possibly send me the table that you're using ?  I can't get
> anything bad to happen with parameterized queries here.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Ed,

<< Ok, now found the table with the problem. Please find attached table. >>

Actually, I'll need the EDB catalog and the tables.  The best way to do this
would be to just do a backup on the database containing the tables, and only
select the tables that you want to send me.

However, a new preview will be out today and there's been some format
changes to the catalogs, etc. so you'll have to wait and send me the backup
using the new preview.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com