F
franky
Hello,
I have a link to a vfp database table. I also have a local table with some
of the items that exist in the vfp table. When I run a query with an inner
join I get different number of results each time the query runs and some of
the row data changes. The two fields (item) in the join are the same.
However, the field i'm targeting sometimes changes (imgfile). I know its
the vfp table because when I import the table rather than linking I will get
consistent results. I'm using Visual Fox Pro Database ODBC connection to a
..DBC container. I also have the following options set for the ODBC :
Collating Sequence: Machine
Null: Checked
Deleted: Checked
Fetch Data In Background: Checked
Anybody else see this or have a solution? Below is the query I'm running:
SELECT iciimg01.item, TEMP_Items_ALLUs.item, TEMP_Items_ALLUs.imgfile,
iciimg01.imgfile
FROM iciimg01 INNER JOIN TEMP_Items_ALLUs ON iciimg01.item =
TEMP_Items_ALLUs.item
WHERE
(((IIf([iciimg01].[imgfile]=[TEMP_Items_ALLUs].[imgfile],True,False))=False));
I have a link to a vfp database table. I also have a local table with some
of the items that exist in the vfp table. When I run a query with an inner
join I get different number of results each time the query runs and some of
the row data changes. The two fields (item) in the join are the same.
However, the field i'm targeting sometimes changes (imgfile). I know its
the vfp table because when I import the table rather than linking I will get
consistent results. I'm using Visual Fox Pro Database ODBC connection to a
..DBC container. I also have the following options set for the ODBC :
Collating Sequence: Machine
Null: Checked
Deleted: Checked
Fetch Data In Background: Checked
Anybody else see this or have a solution? Below is the query I'm running:
SELECT iciimg01.item, TEMP_Items_ALLUs.item, TEMP_Items_ALLUs.imgfile,
iciimg01.imgfile
FROM iciimg01 INNER JOIN TEMP_Items_ALLUs ON iciimg01.item =
TEMP_Items_ALLUs.item
WHERE
(((IIf([iciimg01].[imgfile]=[TEMP_Items_ALLUs].[imgfile],True,False))=False));