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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only