We have tried from the sql> , and the ODBC. They all failed. No problems with joins using ODBC. By that I mean, we can perform joins without any problems. However, we still are not getting any results from the the virtual fields taht participating in the joins.
Dave Davis <[EMAIL PROTECTED]> wrote: Are you using sql just from the sql> prompt, or from ODBC? Any problems with joins using ODBC? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Chiang Sent: Tuesday, January 08, 2008 1:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniSQL - virtual fields problem Yes. We started out by selecting a mixed of data and virtual fields. Once it became apparent that no values returned from any of the virtual fileds, we tried by selecting either just multiple or single virtual fields to no avail. I'm not familiar with @SELECT dictionary item, but, they are definitely are in the LISTDICT. Dave Davis wrote: Are you explicitly including the virtual fields in your select statement? Are they in the @SELECT dictionary item? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Chiang Sent: Tuesday, January 08, 2008 10:59 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniSQL - virtual fields problem Running UniData 7.1 and having difficulties of accessing virtual fields within UniSQL. We SQLized the UniData files using VSG. We then "SELECT" the table within UniSQL. There are good results returned from all the data fields, but, nothing returned from any of the virtual fields. Are there known issues with virtual fields within UniData 7.1? Thanks for your help. Larry --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --------------------------------- Never miss a thing. Make Yahoo your homepage. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --------------------------------- Never miss a thing. Make Yahoo your homepage. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/