Joe:
So, here's what you've told us:
CREATE TABLE led (iledpk i autoinc, ddate d, icat_id i)
CREATE TABLE cat (icat_id i autoinc, cCategory c(20))
FOR i = 1 TO 150
INSERT INTO cat (cCategory) VALUES ("Category " + LTRIM(STR(i)))
NEXT
FOR i = 1 TO 200
FOR j = 1 TO 150
INSERT INTO led (ddate, icat_id) VALUES (DATE()+i*j, j)
NEXT
NEXT
SELECT led.icat_id, ddate, cat.icat_id, cat.ccategory FROM led JOIN
cat ON led.icat_id=cat.icat_id
So, I have 150 category records, and 30,000 ledger records and the SQL
query gives me 30,000 results, with all the cCategory fields filled
in.
So, what is it you are not telling us? How does your situation differ
from the above?
On Mon, May 18, 2015 at 2:37 PM, Joe Yoder <[email protected]> wrote:
> I have a ledger table with about 23,000 records and a category table with
> about 150 records. Both tables have an integer iCat_Id field which I use in
> the following code:
>
> SELECT led.iCat_Id, ddate, Led.iCat_Id, cCategory;
> FROM Led, Cat;
> WHERE Cat.iCat_Id = Led.iCat_Id
>
> The select comes back with about one third of the cCategory description
> fields empty.
>
> I searched for a specific value of iCat_Id in a browse and found the same
> value for records that included the description as well as the ones that do
> no include the description.
>
> I thought perhaps VFP sees a difference between the values that work and
> the ones that don't so I scrolled through the file and compare iCat_id_a
> with iCat_Id_b with a "? iCat_Id_a = iCat_Id_b". The results were alway
> true.
>
> I tried reindexing the tables and restarting VFP but the behavior persists.
>
> Any suggestion will be welcome.
>
> Thanks in advance,
>
> Joe
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CACW6n4tQaHjSXfDacONCjkBaEVgudd4pL6=hkng0_helvkq...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
