V4RB: date compare fault (error 5 and 8)

[Lee Swanson]

If I write my query, I get error 5 and sometimes 8 every time, but it works
in viSQL.

I thought that maybe I could write the query in a different way .i.e. rather
than do 4 joins, do two joins, then nest another query joining the other two
or something like that.

so I was wondering if valentina supported Views, stored procedures or even
just nested queries ie:

select * from table where tableID in (select tableID from otherTable)

----- Original Message -----
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Monday, February 03, 2003 2:56 PM
Subject: Re: V4RB: date compare fault (error 5 and 8)


> on 2/3/03 7:01 AM, Lee Swanson at lee at ibc.com.au wrote:
>
> > Sorry, I replied to the wrong message. See above message about error 5
and
> > 8.
> > I can't leave it as is. My only option is to do all my data work after I
> > have pulled it out. With the amount of records I am dealing with and the
> > criteria, this would make it MUCH slower.
>
> Lee,
>
> I have not understand, so you have found that you also do type of query
> which is not implemented?
>
> Show this query us. May be we will find workaround.
>
> Or send me project if you think you do correct query, but it not works.
>
> --
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://listserv.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
>