main logo
Subject: Re: SQL Dump and Restore
Author: Chuck
Posted: 2003/08/30 09:11:00
 
View Entire Thread
New Search



--Boundary_(ID_STd+PTXPeirfARBJMttnfg)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT

Hi Ruslan:

No matter what I use...VString, VText or VBlob...my descriptive story field
will not be restored properly.
I have written a routine that does reconstruct the line and I have been able to
view the string [line beginning with INSERT into...ending in ); ] in a editfield and it
looks fine....but will not insert.

In the code I sent with the first example....where I am using a BLOB field and
the line appears to have been constructed properly....no insertion.

I am cutting and pasting the text from the text editor and/or Appleworks..into
an editfield.

I am attaching the offending INSERT into line...it executed it without crashing
(sometimes)...but it never restores that record.
Insert.txt is the reconstructed blob field and Insert2.text fails whether the field is
vtext or vstring.

My staff table does get restored the properly from the same SQL dump file.

The data stored inside the database is fine..pictures, text or strings for
recalling.

I then used your front end to dump the sql file and found that the offending
field had a 'vc' with the cedilla under the 'c' or in another case your dumping added a
'Z' at the beginning of the field.

What is going on?

Thanks Chuck

--Boundary_(ID_STd+PTXPeirfARBJMttnfg)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Valentina mailing list
Valentina At lists .D.O.T macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

--Boundary_(ID_STd+PTXPeirfARBJMttnfg)--




 
©2003 Chuck
<-- Prior Message New Search Next Message -->