>i have the ODBC VFoxPro Drivers downloaded from microsoft (latest), and when i do an union, i do the things wrong..... whats happend? i do this two selects separately and are ok, but this union do bullshit... :(
>
>if know something about odbc+vfoxprodriver tell me
>
>thnks
The biggest thing to remeber witha UNION is that the formats of the SELECT MUST BE IDENTICAL, or it can't work. Your problem may have nothing to do with the ODBC driver at all.
To Test: perform each select and then
SELECT field 1, field 2... field n FROM cursor1 ;
UNION;
SELECT field 1, field 2... field n FROM cursor2
If the test doesn't work, then the original selects weren't compatible. Use the process of Elimination to determine which field(s) is(are) the culprit(s)
HTH
Matt
Matt McDonnell
...building a better mousetrap with moldy cheese...