Re: question : select

From: delaigue <pascal.delaigue_at_wanadoo.fr>
Date: Sat, 10 May 2003 23:18:26 +0200
Message-ID: <b9jqan$eao$2@news-reader12.wanadoo.fr>

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 ?

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 )

Good night

"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 Sat May 10 2003 - 16:18:26 CDT