SQL Dump and Restore

[Ruslan Zasukhin]

on 8/29/03 9:42 PM, Chuck at rwc1717 at shaw.ca wrote:

> Hi Ruslan:
> I am writing these individually so as the subject line will reflect the topic.
> 
> I am able to store and retrieve all the data (jpegs,mpegs) while inside the
> vdb 
> file.  
> Works like a charm.
> 
> The problem:
> 
> I have dumped my database with its VString fields, VBlob fields and VText
> fields.
> It seems that if a VString dumped field has any carriage returns embedded in
> it... then the restore line by line does not work properly.


Try this idea:

In normal state with no CR, you get

INSERT INTO ....
INSERT INTO ...    

With CR you get probably

INSERT INTO ....
....
INSERT INTO ...    
    

So when you read line by line, you can check first word of next line to see
if it is INSERT, if no then you need simply continue read next line


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------