Problem with large writes using update

[coltf]

Hello,

I'm writing data to an access server using the SQL command update. When the write gets to a certain size it fails because it truncates. How do I work around this problem in SQL? Any examples on using memo and OLE datatypes with SQL would be useful as well. I'm seeing multiple copies of the data I write to the memo fileds and I have no idea how to use the OLE field.

The updatetext command seemed promising but I'm not sure it is supported and I can't find any good examples. I'm doing all this with TCL.

Thanks,
Colt

 

[Cagliostro]

you can put data with small segments of whole data, Try the following idea:
while NotAllDataIsPut
begin
UpdateSmallerTextPortion

update xx
set YouTextField = YouTextField + OneSmallerPortion
where ...
end
John Fill
ivfmd@mail.md

 

[foxdev]

I may be restating what John said, but I've found that with VFP/ODBC I have to break the statements into separate quoted strings, such as:

[tt]
Bad
"insert into mytable values ('really long value1',
'really long value2', 'still in the same long command
string here...'"

Good
"insert into mytable values " + "('really long value1'," +
"'really long value2', " + "'we are breaking it into
smaller strings concatenated together'"
[/tt]
The "breaking" point with VFP/ODBC seems to be 1024 per string segment.
Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org