I utterly refuse to wade through such messy code. When posting to this list please format your SQL so that the people
looking at it can make some immediate sense of it.

Jason Wharton
www.ibobjects.com

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
TIB_Query->SQL="SELECT (select account from v_account a where
a.id=c.accid and c.docdate between a.sdate and a.edate) as accountno
,for_pay.id ,BANK , ACCID , STATUS , IBANK ,
IACCOUNT , VALDATE , DOCDATE , DOCNO , c.CURRENCY
, DETAILS , URGENT , BREF , CREATID , ACCID1 ,
ACCID2 , (select SURNAME||', '||FNAME from users where
name=for_pay.creatid and activ=1) as CreatedBy , (select SURNAME||',
'||FNAME from users where name=for_pay.accid1 and activ=1) as SignedBy1
, (select SURNAME||', '||FNAME from users where name=for_pay.accid2 and
activ=1) as SignedBy2 , VER , SENDSTATUS , SIGN1 ,
DCURR , SIGN2 , BBANK , BACC , CHARGES , AMOUNT
, BADDRESS , BNAME , CACCOUNT , CBANK , BBANKNAME
, IBANKNAME , CBANKNAME , c.REGNO , c.BALCODE ,
c.COUNTRY ,
c.INFO,ubname FROM for_pay c join account on account.id=accid and
uid=:UID and install=:INST for update "

I also use :
Grid->GridLinks->SafeCommaText=Str;

to reorder columns in grid


Riho Ellermaa