Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Jay,
In table 1 the field is a date and in table 2 the field is a character but it stores a date in the same form mm/dd/yyyy
I thought that using dtoc would allow it to work properly but does this mean it wont't work?
Thanks!
Max
>> Max,
>> I ran this on my system and it worked, so perhaps we have something different in our setups.
>> The first question that comes to mind is this. What data type is the "rptdate" field in your 2 tables. I assumed it was a Date type, but a Time or character string would also be possible. Is the data type the same in both tables?
>> Jay
Précédent
Suivant
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