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/
