>Something strange is happening with this very simple query. The result cursor has no value in the bvalue field for any of the records. However, if I enter a value and save, it is there later. Something is wrong with the query. When I look at table2 (there may be some records table1 that do NOT exist in table2) most of the records have a value in the bvalue field, but some do not. However, when I do the query, the result table has no data in bvalue in any of the records...
>
>
>
Are you sure ID fields in both tables are of the same length?
If it's not broken, fix it until it is.
My Blog