Hi,
I am using Delphi 5, IBX and Interbase 6.2
I have select query.

SELECT STOCK.ID, STOCK.NAME, STOK.BARCODE,
STOCKGROUP.CODE, STOCKGROUP.NAME,
TABLE1.CODE, TABLE1.NAME, TABLE2.CODE, TABLE2.NAME, TABLE2.DESCRIPTION
FROM STOCK STOCK
LEFT JOIN STOCKGROUP STOCKGROUP ON (STOCK.STOCKGROUP = STOCKGROUP.ID)
LEFT JOIN TABLE1 TABLE1 ON (STOCK.CODE1 = TABLE1.ID)
LEFT JOIN TABLE2 TABLE2 ON (STOCK.CODE2 = TABLE2.ID)
WHERE ((STOCK.STOCKGROUP = :STOKGROUPID)
ORDER BY STOCK.NAME


TABLE2.DESCRIPTION field type is Varchar(2000)

when i run the query, sometimes server is crashing
but it becomes sometimes, not always.
and server log is that
C:\Program Files\Borland\InterBase\bin\ibserver.exe: terminated abnormally
(-1073741819)

what is the problem.
what i must do
thanks,

ibrahim Bulut
Software/Database Developer
Republic Of Turkey