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

Reply via email to