Board index » delphi » Possible bug in BDE ? (SQL troubles)

Possible bug in BDE ? (SQL troubles)

Hy All,

When I try to run the following query (in 32bit BDE v.3.12 or v3.5):

        select equipeNummer
        from prores
        where prores.proefNummer < 2

I get a 'General Protection Fault' in the Database Desktop
and a 'Access Violation' in the Delphi IDE.

When I try:

        select equipeNummer
        from prores
        where prores.proefNummer = 2

I get the correct results. Is this a bug in the BDE of am I
doing something wrong ?

  _   ___  _____
 | | / __\|_   _| Marco ten Thije       Email: Marco.ten.Th...@ict.nl
 | |( (__   | |   ICT Automatisering Deventer B.V.   Tel: 0570-633888
 |_| \___/  |_|   "Nieuwe wegen in automatisering"   Fax: 0570-621362

 

Re:Possible bug in BDE ? (SQL troubles)


Hy All,

When I try to run the following query (in 32bit BDE v.3.12 or v3.5):

        select equipeNummer
        from prores
        where prores.proefNummer < 2

I get a 'General Protection Fault' in the Database Desktop
and a 'Access Violation' in the Delphi IDE.

When I try:

        select equipeNummer
        from prores
        where prores.proefNummer = 2

I get the correct results. Is this a bug in the BDE of am I
doing something wrong ?

  _   ___  _____
 | | / __\|_   _| Marco ten Thije       Email: Marco.ten.Th...@ict.nl
 | |( (__   | |   ICT Automatisering Deventer B.V.   Tel: 0570-633888
 |_| \___/  |_|   "Nieuwe wegen in automatisering"   Fax: 0570-621362

Re:Possible bug in BDE ? (SQL troubles)


Marco.ten.Th...@ict.nl (Marco ten Thije) wrote:

Quote
>When I try to run the following query (in 32bit BDE v.3.12 or v3.5):
>        select equipeNummer
>        from prores
>        where prores.proefNummer < 2
>I get a 'General Protection Fault' in the Database Desktop
>and a 'Access Violation' in the Delphi IDE.
>When I try:
>        select equipeNummer
>        from prores
>        where prores.proefNummer = 2

You are using only 1 table, so why use prores.proefNummer in your
where instead of just proefNummer. Perhaps this is the reason of the
fault.

Other Threads