>>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

well try do this select that u write upper but include the sentence NOT EXIST :(

thnks 4 reply