Alexander V.Nevsky wrote:

>>When I issue CREATE INDEX "CDESDIS_DISHDR" ON "DISHDR"("CDESDIS") on
> the table created
>>by the script below I get:
>>
>>Statement failed SQL code=-902 I/O error
>>for file ""
>>error while trying to open file no such file or directory
>
> Directory specified in TmpDirectories parameters in firebird.conf
> does'nt exist of Firebird server have no access rights for this directory.

Which would also make the temp file not big enough :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services