I've been thinking about what you've done ... At TCL, type "SELECT FCV". Note there is NO SEMICOLON. This is a RETRIEVE SELECT, and should come back with a message "x records selected", and NOT display the data. The RETRIEVE command to display the data is "LIST".
So you don't want a semicolon in your IC SELECT. Ic_readnext is now going to retrieve JUST THE PRIMARY KEY. Do an "ic_read FCV key_ive_just_retrieved" to get the entire record (row). You should now have ALL your columns for that row. You'll need to strip out the columns you want, and then strip out the values inside it - but if you display the record so you can see the structure, it'll give you an idea where to go from here. NOTE that you are retrieving your data from the file ONE ROW AT A TIME. Cheers, Wol -----Original Message----- From: pam [mailto:[EMAIL PROTECTED] Sent: 21 May 2007 21:56 To: u2-users@listserver.u2ug.org Subject: Re: [U2] create a select list 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: u2-users@listserver.u2ug.org > 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: u2-users@listserver.u2ug.org > > 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 > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > ------- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
