Re: can i execute this sql ?

From: Ed Prochak <prochak_at_my-deja.com>
Date: Thu, 28 Oct 1999 16:42:39 GMT
Message-ID: <7v9udu$36i$1@nnrp1.deja.com>

In article <7v8v4c$cpd$1_at_nnrp1.deja.com>, newnewbie_at_my-deja.com wrote:
> String str1= "select e.state_name, fwm.job_type, fc.fit_ind, count
> (*) from EMPLOYER_MASTER e, " +
> " FOREIGN_WORKER_MASTER fwm, FW_CERTIFIED_DETAILS fc "+
> " where fwm.employer_code = e.employer_code and " +
> " fc.worker_code = fwm.worker_code group by e.state_name,
> fwm.job_type, fc.fit_ind " ;
>
> the code for my sql is as above.
>
> can i execute it ?
>
> when i try, the program just hangs. perhaps there is too many records
?
>
> thanks, bye.

There's really not enough information to answer your question. What are you programming in? PASCAL? VB? Your code snippet lacks context. Please post with more information next time. a source listing for the smallest program which displays your problem would help.

--
Ed Prochak
Magic Interface, Ltd.
ORACLE Development, conversions, training and support 440-498-3700 magic_at_interfacefamily.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 28 1999 - 11:42:39 CDT