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.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
nombre de Hona, David S
Enviado el: martes, 24 de febrero de 2004 5:32
Para: 'U2 Users Discussion List'
Asunto: RE: SQL with UniObject
Your SQL SELECT query is invalid. FORM is a typo and should be FROM,
also you haven't specified any column names. Fix those two problems and you
should be in business.
SELECT valid-column-name(s) TO SLIST select-list-number FROM
table-name ;
I suggest you always test your SQL queries from TCL first. If it won't work
from TCL, it isn't going to work from UniObjects.
If you're unfamilar with UV/SQL, you should refer to the UV SQL Reference
Guide. It details the correct syntax. Manuals are online, here:
http://www-306.ibm.com/software/data/u2/pubs/library/
Regards
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Cesar Riba
Sent: Tuesday, February 24, 2004 4:52 AM
To: 'U2 Users Discussion List'
Subject: RE: SQL with UniObject
Hello,
Your code is ok, but the SQL Command SELECT TO SLIST 0 FORM
CUSTOMERS;,
isn't generate a selectlist active. What is that ocurr?. This command don't
functio from VB.
Thanks.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
