Hi,

i need help from you all,:D

i'm having problem in my customization script, i can't bind each record for my query result to the program variables.

for example the code

select tfgld102.docn, tfgld102.ttyp
from tfgld102

returned 5 rows, because each document having many ledger account.

and i want to make each row is bind to each program variables for example i want to bind each ledger account to each of my variables.

please tell me if my story is too complicated, hahaha:D

any links and suggestion is welcomed.

thank you.

Roy.

Hi,

Here is a link for the baan sql documentation (http://www.baanboard.com/programmers_manual_baanerp_help_functions_database_handling_baan_sql).

In short, of you want to save all the values, you can add a "selectdo" and in it the code will go over all the rows. All you need to do then is to save them.

select tfgld102.docn, tfgld102.ttyp
from tfgld102
selectdo
i=i+1
your.array(i) = tfgld102.docn
endselect

I hope it helps,

- George

Hi,

i tried the solution you gave me.

and it worked :D

thanks for the reply.