thanks for you help, and i was working on it and i finally can read with ic_readnext but... (always there is a but) ... I can4t receive all the data from a multivalue column, I just receive the first only. I don`t know if I must do something more to get all the data. I will investigate more but I you have any idea i will apreciate it!! Thanks again you give me a great idea. Pamela
On 21/05/07, Anthony Youngman <[EMAIL PROTECTED]> wrote: > > OOWWWWWWW > > I don't know what to suggest here ... but I do know what's happening. > You're using a SQL SELECT, not a RETRIEVE SELECT. > > What I think you want to do is to just do a "SELECT FCV". This will give > you a list of keys from which you will get RUE and LNV row by row. > > Thinking in SQL terms, "SELECT FCV" will get you a cursor of primary > keys. READNEXT will then get you the rows one by one. You then need to > extract the columns you want. > > I think you really need someone with you who knows what they're doing. > If you can do it in BASIC, you can do it with InterCall. But once you > start getting confused by throwing SQL into the mix, you're likely to > get in a real mess ... > > Cheers, > Wol > > -----Original Message----- > From: pam [mailto:[EMAIL PROTECTED] > Sent: 21 May 2007 15:23 > To: [email protected] > Subject: Re: [U2] create a select list > > Hi, I'm trying to do this > > 1) SELECT RUE,LNV FROM FCV; > the result two columns > > RUE........................... LNV. > > LOS ALGARROBOS ALGA > BV BRASIL BV > BRAS > PASAJE LATORRE LATO > JUJUY JUJU > BDIER GRAL J ZAPIOLA BDIE > ZAPI > GOBERNADOR ECHAGUE ECHA > BRASILIA BRAS > VICTORIANO MONTERROSSO VICT > MONT > BV AMERICA BV > AMER > BDIER GRAL J M DE ROSAS BDIE > ROSA > JUAN M DE ROSAS JUAN > ROSA > S/N S/N > HONDURAS HOND > FRAY STA MARIA DE ORO FRAY > STA > > 2)SELECT RCVV,LIBCV,RUE,LIBELLE,LNV FROM FCV; > another way to show > > > RCVV.... E03021055 > LIBCV... LOS ALGARROBOS > RUE..... LOS ALGARROBOS > LIBELLE. LOS ALGARROBOS > LNV..... ALGA > > RCVV.... S02060365 > LIBCV... BV BRASIL > RUE..... BV BRASIL > LIBELLE. BV BRASIL > LNV..... BV > . BRAS > I wanna received the information from a C program with the function > ic_execute, and in a only way. I'm searching and I think I could set the > term with TERM 15,24 (or something like this) and maybe receive the data > in > the second way. But I would like to make a select list with the > ic_execute > to access the data using ic_read and ic_readnext to avoid all this and > to > parse the data. My problem is that I don't know how to make a selec list > with the ic_execute. > > Thanks > Pamela > > On 21/05/07, Anthony Youngman <[EMAIL PROTECTED]> wrote: > > > Can you give a bit more detail as to what you mean "I receive the data > > in a different way when the select statement change". > > > > A BASIC select, or a simple RETRIEVE select will simply give you a > list > > of keys which you can get hold of with READNEXT or READLIST. InterCall > > should work just the same. > > > > If you've started adding things like WHEN to a RETRIEVE SELECT, then > > things will certainly change ... > > > > What are you trying to do? > > > > Cheers, > > Wol > > > > -----Original Message----- > > From: pam [mailto:[EMAIL PROTECTED] > > Sent: 21 May 2007 14:06 > > To: [email protected] > > Subject: [U2] create a select list > > > > Hi, I'm working with the api intcall.h to access universe and I wanna > > make a > > select and process it, but I receive the data in a different way when > > the > > select statement change. So I would like to make a select list with > the > > ic_execute command how is point in the documentation but I don't know > > how to > > do this. If someone have any idea ....!!! > > Or some idea to read the result of the select statement. > > Thanks a lot and thanks for your previus help > > > > Pamela > > ------- > > 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/ > ------- > 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
