-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave
> Crozier
> Sent: Wednesday, August 09, 2017 11:01 AM
> To: profoxt...@leafe.com
> Subject: RE: SQL Error
>
> Like using "in (select .. ) " which is equally poorly document
: RE: SQL Error
Like using "in (select .. ) " which is equally poorly documented.
Dave
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this
Like using "in (select .. ) " which is equally poorly documented.
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: 09 August 2017 15:33
To: profoxt...@leafe.com
Subject: Re: SQL Error
On Wed, 9 Aug 2017, at 03:21 PM, La
On Wed, 9 Aug 2017, at 03:21 PM, Laurie Alvey wrote:
> I've only ever used EXISTS in T-SQL. Didn't know it could be used in VFP.
> It doesn't seem to be documented anywhere - what about SOME or ANY?
it's on the "Filter Conditions for Queries and Views" help file page.
SOME and ANY also.
--
A
gt; own
> > internally.
> >
> > Dave
> >
> > -Original Message-
> > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Koen Piller
> > Sent: 08 August 2017 16:58
> > To: ProFox Email List
> > Subject: Re: SQL Error
> >
l sub query of its own
> internally.
>
> Dave
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Koen Piller
> Sent: 08 August 2017 16:58
> To: ProFox Email List
> Subject: Re: SQL Error
>
> Hi,
>
> Maybe in Visual Studio Ne
.@leafe.com] On Behalf Of Koen
> Piller
> Sent: 08 August 2017 16:40
> To: ProFox Email List
> Subject: Re: SQL Error
>
> Hi,
>
> Please note:
>
> select .T.;
> FROM cwkt;
> where;
> cwkt.clcode=ctwc.clcode And cwkt.wccode=ctwc.wccode And;
>
f Of Koen Piller
> Sent: 08 August 2017 16:40
> To: ProFox Email List
> Subject: Re: SQL Error
>
> Hi,
>
> Please note:
>
> select .T.;
> FROM cwkt;
> where;
> cwkt.clcode=ctwc.clcode And cwkt.wccode=ctwc.wccode And;
> (cwkt.trndate BETWEEN ctw
...@leafe.com] On Behalf Of Koen Piller
Sent: 08 August 2017 16:40
To: ProFox Email List
Subject: Re: SQL Error
Hi,
Please note:
select .T.;
FROM cwkt;
where;
cwkt.clcode=ctwc.clcode And cwkt.wccode=ctwc.wccode And;
(cwkt.trndate BETWEEN ctwc.validfr AND ctwc.validto);
order
Hi,
Please note:
select .T.;
FROM cwkt;
where;
cwkt.clcode=ctwc.clcode And cwkt.wccode=ctwc.wccode And;
(cwkt.trndate BETWEEN ctwc.validfr AND ctwc.validto);
order By funccode, trndate, clcode, wccode, wonbr Into Cursor temp
gives a result
and
select .T. ;
From ctwc;
I think this is referring to something different: a query in the FROM
clause is different from a query in the WHERE clause. In the FROM
clause, you're using the SQL to create an artificial data source, a
"Derived Table" in VFP terms. In the WHERE clause, you're filtering
the data in the SELECT port
Don't know if this helps but the VFP9 SP2 help file says this:
A sub-SELECT is often referred to as a derived table. Derived tables are
SELECT statements in the FROM clause referred to by an alias or a
user-specified name. The result set of the SELECT in the FROM clause
creates a table used by the
I don't recall if I've ever run into an error 1801. You go, Gene!
https://msdn.microsoft.com/en-us/library/aa976358(v=vs.71).aspx
Seems to indicate that subqueries don't support the syntax. Note
that's an old MSDN entry, so 9.0 could be better.
On Mon, Aug 7, 2017 at 8:35 PM, Gene Wirchenko wr
I think Dave is correct, sometimes adding additional parentheses fixes things,
even though it should work as is.
From: Dave Crozier
To: ProFox Email List
Sent: Tuesday, August 8, 2017 3:46 AM
Subject: RE: SQL Error
Gene,
Have you tried bracketing the statement off:
where
Gene,
Have you tried bracketing the statement off:
where;
(cwkt.clcode=ctwc.clcode) ;
and (cwkt.wccode=ctwc.wccode) ;
and( cwkt.trndate between ctwc.validfr and ctwc.validto);
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of
Maybe try .. between(cwkt.trndat, ctwc.validfr, ctwc.validto) . yes I know
- better not to use but maybe worth a try.
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Tuesday, 8 August 2017 10:36 AM
To: profoxt...@leafe.com
Subjec
16 matches
Mail list logo