Hi Dimitris,
>Aleksey,
>
>I was thinking to use a similar solution as yours - at the moment I am doing a copy paste from the buildin builder.
>
If you run my code, it automatically puts the schema into clipboard, the only thing that is left to do is paste it into right place and modify data types.
>
But the problem with the builders is that by using :
>
>SQLEXEC(con,"select * from customers","res")
>AFIELDS(aflds)
>
>they assume that the data type conversion that is made (or what the back end gives) is allways correct, which is not the case. I am telling you this because for instanse some drivers (Oracle) can return a Number Datatype which VFP interprets as N(20,0) but the value returned may have decimals (for instanse 1.235), as you understand we have to convert by hand the N(20,0) to N(20, 4).
>
Do you mean "manually convert data" or "manually change data type in CursorSchema"?
Thanks,
Aleksey.
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