Chuck, Try this ... First create a Range object that contains the whole document. Then save it as a BLoB with VARIABLE TO BLOB
I did a quick test and it seems to work: *C_BLOB*($blob) *C_OBJECT*($range;$range2) $range:=*WP Create range*(PtrWriteProArea->;wk start text;wk end text) *VARIABLE TO BLOB*($range;$blob) *BLOB TO VARIABLE*($blob;$range2) $range2 = $range I'm pretty sure you will need v17 for this. HTH Pat On Tue, 30 Oct 2018 at 19:28, Charles Miller via 4D_Tech < [email protected]> wrote: > Hi All, > > I have a customer where we would like to upgrade to 4D write pro from 4D > write. We have the following issue which is basic and I can not seem to > solve, We move data between different data files using SQL. We can NOT > store 4D write pro in an OBJECT data type as you can not access via SQL > except via function calls. We can not go record by record. Is there any way > to store 4d write pro documents in a blob field > Version will be 16 or 17 not sure yet. I have looked at the manuals and it > is not clear to me. > > Thanks and regards > > Chuck > > -- > > ----------------------------------------------------------------------------------------- > Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 > Informed Solutions, Inc. > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D, Sybase & SQL Server connectivity > http://www.informed-solutions.com > > ----------------------------------------------------------------------------------------- > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, disclosure, > printing, copying, storage, modification or the taking of any action in > reliance upon this transmission is strictly prohibited. Delivery of this > message to any person other than the intended recipient shall not > compromise or waive such confidentiality, privilege or exemption > from disclosure as to this communication. > ********************************************************************** > 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] > ********************************************************************** -- ************************************************* CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 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] **********************************************************************

