I am not sure this is the best way to do it but it works for me in VB. I call a subroutine that works with any file and parameters it is also very quick compared to the recommended select object.
All opinions/criticism welcome. [EMAIL PROTECTED] SUBROUTINE(FILENAME,RETURN.DICTS,STATEMENT,SSLIST,COUNT) ******************************* * FILENAME - File to be selected * RETURN.DICTS - Name of Dict Items to be returned * SELECT.STATEMENT - Text of Selection Statement * SSLIST - Returned Select List Record * COUNT - Total number of records in select list (If MODE = "S") SAVE.KEY = @USERNO:FILENAME:TIME() ******************************* OPEN '&SAVEDLISTS&' TO F.TEMP ELSE ABORT SELECT.STATEMENT = "SSELECT ":FILENAME:" ":STATEMENT:" ":RETURN.DICTS EXECUTE SELECT.STATEMENT,//SELECT. > TLIST EXECUTE "SAVE-LIST ":SAVE.KEY,//SELECT. < TLIST READ HOLDLIST FROM F.TEMP,SAVE.KEY ELSE HOLDLIST = "" COUNT = DCOUNT(HOLDLIST,CHAR(254)) SSLIST = HOLDLIST DELETE F.TEMP,SAVE.KEY RETURN -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christophe Marchal Sent: 21 June 2004 15:25 To: [EMAIL PROTECTED] Subject: [U2] UniObject - Select Hello, I'm discovering the uniobject in java, and I don't find how to do a SELECT command and retreive ID. I only find the UniSelectList that have a select() method on an UniFile. But what I want is somthing like : SELECT MYFILE WITH MY.FIELD = "bar" AND WITH MY.OTHER.FIELD = "foo" And I don't whant to use the jdbc driver to do that. Is it possible whitout writing a subroutine to do this "universal" statment ? Thanks for help Christophe ------- 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/
