Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>
>>Thanks Erik
>>
>>That works fine for me with local views, but fails on remote views to FP2.6 tables. I get an ODBC connectivity error - operator/operand type mismatch.
>>I can't find a way to get around that.
>>
>>Bill
>
>I have never used a remote view to a FP table, so I can't tell you the ins and outs. Maybe someone with more experience here will jump in.
Hi Erik
I found the answer in an obscure KB article - #Q157424. ODBC doesn't recognize the concept of an empty date. If you wish to query for empty dates in a remote view, instead of querying for {}, you query for the value {^1899-12-30}. ODBC uses that value to represent an empty date. I have tried it and it works.
Thanks Again
Bill
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement