Cesar, I don't have this problem (though your syntax for the second statement is wrong) using either SQL or RetrieVe. BTW is there any reason why you are using SQL?
Add this to the VBScript example I sent you... Sess.Command.Text = "SELECT VOC LIKE ""A...""" Sess.Command.Exec Sess.Command.text = "LIST VOC" Sess.Command.Exec Msgbox Sess.Command.Response Sess.Command.Text = "SELECT TO SLIST 0 FROM VOC WHERE F1 LIKE 'V%';" Sess.command.Exec Sess.Command.Text = "SELECT F1 FROM VOC SLIST 0;" Sess.Command.Exec Msgbox Sess.Command.Response Regards, Brian > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Cesar Riba > Sent: 24 February 2004 07:14 > To: 'U2 Users Discussion List' > Subject: RE: SQL with UniObject > > Hello > > I test SQL query from TCL and it work fine, but from > Visual Basic don't work. > > In TCL I execute this sentence and the result is OK: > > > SELECT TO SLIST 0 FROM GCDHIST WHERE CODUSER = '02'; > 98 record(s) selected to SELECT list #0. > >>SELECT ESTADO, FECHA, MARCA FROM SLIST 0 GCDHIST; > > > > In VB I execute this sentence and the first sentence > not activate the list. > Is this a incompatibility? > > > Thanks. > > > ________________________________________________________________________ This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
