Hello Paul,
For years we have been doing it the other way round with very few problems.
We write to SQL from 4D using ODBC. Then you have full control of what you
send both on the record and field level.
You are welcome to contact me off list if you want some sample code.
HTH
David Samson
Manchester
UK
>We pull data from 4D into MS SQL using the 4D ODBC Driver. On occasion,
we have a problem >with some Alpha fields where only the first 2 characters
are pulled into SQL.
>In MS SQL, the associated field has been configure to use varchar(255)
{or whatever the field >length is for the 4D field}
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
