Re,
Inside a I-Type; SUBR is called only one time. The first. You need to return a mv'ed dynamic array. That the reason why there is many functions to manage mv'ed field. Functions are usually postfixed by S like CHAR and CHARS.
You must have :
SUBR('SQ_CAL_SUB','GQ.COD.TAB',@RECORD<3>:'|':'TMDEFN':'|':'CT.ES');
SUBR('SQ_CAL_SUB','OEM2ANSI',@1)Inside your GQ.COD.TAB test if param is mv'ed.... if yes, loop on all mv and return a mv'ed dynarray.
Regards.
Manu Fernandes Infodata S.`r.l. Tel : (352) 33 16 48 Fax : (.352) 33 75 55
----- Original Message ----- From: "Vincent MASSON" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, March 08, 2005 12:00 PM
Subject: [U2] I-Type and Assoc
Dear all,
I have a problem with an I-type used in an association. Here is my I-descriptor :
SUBR('SQ_CAL_SUB','GQ.COD.TAB',@RECORD<3,@MV>:'|':'TMDEFN':'|':'CT.ES'); SUBR('SQ_CAL_SUB','OEM2ANSI',@1)
When I use this descriptor in a select (through ODBC), I get this :
[EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] E [EMAIL PROTECTED] E [EMAIL PROTECTED] E [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] S [EMAIL PROTECTED] S [EMAIL PROTECTED] S [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] E [EMAIL PROTECTED] S [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] ENTRiE
The excepted output should be :
[EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] SORTIE [EMAIL PROTECTED] ENTRiE [EMAIL PROTECTED] ENTRiE
How can I do ?
Thanks a lot,
Vincent MASSON <mailto:[EMAIL PROTECTED]>
Infodata Sarl <http://www.infodata.lu>
Tel : (352) 33 16 48
Fax : (352) 33 75 55
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
