> Subject: VFP9: SQL Help
>
>
> This is very simple but I need to select all the distinct items
> from a file that includes the part number and a count of records
> generated for each, resulting cursor would look like this:
>
> Part No, # of records
>
> TIA,
> De
On 1/24/07, Desmond Lloyd <[EMAIL PROTECTED]> wrote:
> This is very simple but I need to select all the distinct items from a file
> that includes the part number and a count of records generated for each,
> resulting cursor would look like this:
>
> Part No, # of records
>
SELECT partno, coun
This is very simple but I need to select all the distinct items from a file
that includes the part number and a count of records generated for each,
resulting cursor would look like this:
Part No, # of records
TIA,
Desmond
8-)
--- StripMime Report -- processed MIME parts ---
mu
Once again great help from everyone!!!
Changed the date to max(date) with "Enginebehavior" set to 9.0 and voilla!
Thanks to Everyone!
Desmond
8-)
From: "Mike yearwood" <[EMAIL PROTECTED]>
Reply-To: ProFox Email List
To: profox@leafe.com
Subject: Re: VFP9: SQL Hel
? That's one example of the problems with
enginebehavior 70 queries.
Change date to max(date) and your query should work with SET ENGINEBEHAVIOR 90.
Message: 7
Date: Mon, 07 Aug 2006 17:13:56 +
From: "Desmond Lloyd" <[EMAIL PROTECTED]>
Subject: VFP9: SQL Help
To: [EMAIL
ED]>
Reply-To: ProFox Email List
To: profox@leafe.com
Subject: Re: VFP9: SQL Help
Date: Mon, 7 Aug 2006 13:37:31 -0400
On 8/7/06, Desmond Lloyd <[EMAIL PROTECTED]> wrote:
set enginebehavior is set to 70 because it balks at my sum(time)
statements,
"group by is invalid"
Select pre
The problem in the UNION is that it automatically makes a DISTINCT list
of results...
Thus, it is cleaner to create two separate SELECT - SQL results, then
append one result to another afterwards.
Philip
Desmond Lloyd wrote:
Help!
Am attempting to summarize employee hours coming from two
On 8/7/06, Desmond Lloyd <[EMAIL PROTECTED]> wrote:
set enginebehavior is set to 70 because it balks at my sum(time) statements,
"group by is invalid"
Select prempl,date,Sum(time) as time_total, From current_labor &mfilt ;
union
Select prempl,date,Sum(time) as time_total, From history_labor &mf
On Aug 7, 2006, at 1:13 PM, Desmond Lloyd wrote:
Works fine for all employees except for one, where the time_total
is equal on both sides. Changing one of the totals if I separate
out the "current" and "history" cursors allows that employee to
calculate properly. For the one employee it
Help!
Am attempting to summarize employee hours coming from two separate files,
current and history.
The following statement works when summarizing time reported for employees.
mfilt is a "built" where clause, primarily defining a date range. (in this
case 08/04)
set enginebehavior is set
10 matches
Mail list logo