Article View: borland.public.jbuilder.database
Article #380JBuilders SQL Builder, using functions?!?!?!?
From: N
Date: Fri, 16 Feb 2007 22:13
Date: Fri, 16 Feb 2007 22:13
12 lines
1736 bytes
1736 bytes
I have been unable to find a single example on how to utilize the USER() function under SQL Builder, I have an easier way to run my query:
SELECT ORADBA.PS_PROJECT_INFO.PROJECT_ID,ORADBA.PS_PROJECT_INFO.PROJECT_NAME,ORADBA.PS_PROJECT_INFO.PROJECT_DESC
FROM ORADBA.PS_PROJECT_INFO
WHERE ORADBA.PS_PROJECT_INFO.PROJECT_ID = (SELECT ORADBA.PS_PROJECT_EMPLOYEES.PROJECT_ID
FROM ORADBA.PS_PROJECT_EMPLOYEES
WHERE ORADBA.PS_PROJECT_EMPLOYEES.EMPLOYEE_ID = (SELECT ORADBA.PS_EMPLOYEE_LOOKUP.EMPLOYEE_ID FROM ORADBA.PS_EMPLOYEE_LOOKUP WHERE ORADBA.PS_EMPLoYEE_LOOKUP.USERNAME = (SELECT USER from dual)));
But for some reason it will not accept the this query ( i already ran it as a script via command line and it works)... So now I am trying to use the USER() function... Is there any documentation about these functions and how to use them. What I found in the help section was useless?
Thank you for your help in advance..
N
Technical Details
Message-ID:
<45d62c8a$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 1073da,9a57ca76b54fe400,start X-Google-Attributes: gid1073da,public X-Google-Language: ENGLISH,ASCII-7-bit From: "N" <nmperez@water.ca.gov> Sender: "N" <nmperez@water.ca.gov> Reply-To: "N" <nmperez@water.ca.gov> Subject: JBuilders SQL Builder, using functions?!?!?!? Newsgroups: borland.public.jbuilder.database X-User-Info: 136.200.198.98 NNTP-Posting-Host: 207.105.83.66 Message-ID: <45d62c8a$1@newsgroups.borland.com> Date: 16 Feb 2007 14:13:30 -0800 X-Trace: newsgroups.borland.com 1171664010 207.105.83.66 (16 Feb 2007 14:13:30 -0800) Lines: 12 Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail