Re: question : select

Hello,

Thanks for your remarks concerning my english-writing, I shall keep them in mind
Concerning the request, I'm goin to try other things tomorow at work

Good night

"Ed Prochak" <edprochak_at_adelphia.net> a écrit dans le message de news: 3EBFB77D.9050104_at_adelphia.net...
>
> (I normally bottom post, but my comments are inline of the top post]
>
> delaigue wrote:
> > Hello,
> >
> > Thank you for answering,
> >
> > 1 ) I've tried to run the subquery alone :
> >
> > select dossierid from demande where demandeid between '165000000' and
> > '170000000' and originedemande = 'e-Mail' and etatdemande =
'Transférée'
> >
> > and it does work, it returns what is expected ( one number of lines )
> >
> > 2 ) Good remark : it seems to me that thetype of "demandeid" is
"number" ->
> > it would be a good reason to make TOAD exit -> I will try without the
quotes
> > on monday ( when I am back at work )
> >
> > PS : what does "IOW" mean ?
>
> shorthand for: In Other Words
>
> >
> > 3 ) Never any error code, TOADD simply runs and runs and runs and
doesn't
> > react any more to any command : I must force to stop the process TOADD
from
> > an external way ( by using the "task manager" of Windows )
>
> Oh, so my comment about your english should be corrected
> instead of "run out" (which you say you meant it runs and runs)
> say "hangs" (which is generally used to mean the program does not respond)
>
> >
> >
> > Good night
>
> Well, It may take a TOAD user to help. I don't really see anything gravely
> wrong in your query.
>
> Anyone else care to answer this?
>
> >
> > "Ed Prochak" <edprochak_at_adelphia.net> a écrit dans le message de news:
> > 3EBC51C0.4040904_at_adelphia.net...
> >
> >>delaigue wrote:
> >>
> >>>Hello,
> >>>
> >>>
> >>>My purpose is to select the lines from the table "dossier" fulfilling
> >>>conditions on fields belonging to the table "demande" ( "dossierid" is
a
> >>>primary key of table "dossier" and the couple ("dossierid",
"demandeid")
> >>
> > is
> >
> >>>a primary key of the table "demande" )
> >>>
> >>>I've tried to run this request via an interface for oracle ( TOADD ) :
> >>>
> >>>(1)
> >>>select numdossier from dossier
> >>>where dossierid in
> >>>( select dossierid from demande where demandeid between '165000000' and
> >>>'170000000' and originedemande = 'e-Mail' and etatdemande =
> >>
> > 'Transférée' )
> >
> >>>and it does not work, it makes TOADD run out
> >>>For, there really is at least one line fulfilling the three conditions
> >>
> >>What does the subquery alone return?
> >>select dossierid from demande where demandeid between '165000000' and
> >> '170000000' and originedemande = 'e-Mail' and etatdemande =
'Transférée'
> >>
> >>
> >>Also, is there a reason for quoting the ID numbers?? IOW, why use
> >>'165000000'
> >>instead of
> >> 165000000
> >>
> >>
> >>When Toad exits, what error message does it give?
> >>
> >>
> >>
> >>>this one does work ( makes TOADD run out ) :
> >>>select MonDossier.numdossier from dossier MonDossier, demande MaDemande
> >>>where MonDossier.dossierid = MaDemande.dossierid and
> >>
> > MaDemande.demandeid
> >
> >>>between '165420325' and '165420329'
> >>
> >>Again what is the error message??????????????
> >>
> >>
> >>>
> >>>Can anybody tell me if there is something wrong in the request (1) ?
> >>>Or give me a simple way to implement it differently ?
> >>>
> >>>
> >>>
> >>>Thank you by advance,
> >>>Pascal Delaigue
> >>>Good night
> >>>
> >>>P.S. : perhaps my english/american writing is not good, it's because
I'm
> >>>french -> if there are big mistakes, please tell me, thanks
> >>
> >>instead of "run out" say "exit".
>
>
>
>
> --
> Ed Prochak
> running http://www.faqs.org/faqs/running-faq/
> netiquette http://www.psg.com/emily.html
> --
> "Two roads diverged in a wood and I
> I took the one less travelled by
> and that has made all the difference."
> robert frost
>
Received on Wed May 14 2003 - 18:11:48 CDT