Information générale
Catégorie:
Codage, syntaxe et commandes
Ok I found a difference in many fields that are empty. I use Microsoft.Jet.OLEDB.4.0 and I was not able to send empty value the driver is giving an error so I put one empty space and I think that Sedar software don't like to have a space where a field is suppose to be empty. All the value are contain in a variable F1 (f1=""TMP00076","001006","0",""")and just before to update a table I change the value of F1 with STRTRAN(f1,'""','" "'). To fix the problem I try STRTRAN(f1,'""','.NULL.') but the driver doesn't like this. How to send empty value to access table with this driver.
>Hi
>
>From Foxpro we put some data in access database (containing lot of database and lot of fields) used by a software call Sedar. After we need to compare two database to see if the data are the same on all table inside these two database. Is there a way to compare access database, maybe a software we can download somewhere. I even need to check if the is more blank at the end of data in a field (for exemple "59 park avenue" compare to "59 park avenue "). Sedar software is very strict and refuse to work if there is a very small difference and just two space at the end of data in a field can make it crash.
>
>Michel
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