If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Inconsistent query results
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)); |
Thread Tools | |
Display Modes | |
|
|