if i create a query (in delphi7) with 3 select with request sensitive result set:

select id  from (
 select id from (
  select id from product
 ) a
) b

i get this error:
Access violation at address 004F27E3 in module 'edbmgr.exe'. Read of address 00000050

with 2 select there is no probem.

Hello,

If said you are creating the query in D7 but the error message you posted was generated by EDB Manager... Can you clarify what's happening ?

--
Fernando Dias
[Team Elevate]

Fernando


The D7 reference may just be a reference to the Delphi version he/she's using which he/she thinks means the version that ElevateDB manager was compiled in.

Of more interest is where's the rest of the query. What's posted so far causes a crash but I couldn't care less because its nonsense anyway (mind you Tim will probably want to fix it). Yes it causes a crash, and yes it works if you reduce it to

 select id from (
  select id from product
 ) a

but as shown there's a simple workround

  select id from product

ultimately that's what its doing.

If codealfa would post a "proper" query that doesn't work we may be able to help.

Sorry to all for sounding aggressive about it

Roy Lambert [Team Elevate]

<< if i create a query (in delphi7) with 3 select with request sensitive
result set: >>

I'll make sure this is fixed in the next build.

Tim Young
Elevate Software
www.elevatesoft.com

Thanks  for quick response!

Zsolt