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




[Non-text portions of this message have been removed]