Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Problem with TEXT in DBD::Sybase
Date: Jul 20 2001 9:06PM

tao starbow writes:
 > I am using DBD::Sybase ( version 0.23 ) to interface
 > with a Sybase-backed application.  Everything is
 > working well except for one table which includes a
 > TEXT field.  If I try to update the TEXT field (
 > "update table set field='new text' where key='key'" ),
 > it looks fine when I do a select, but the application
 > ignores it.  
 > The only way I can get the application to acknoledge a
 > change is to do an insert/select from another valid
 > table entry ( "insert into table ( select 'key' as
 > key, field from table where key='key2'" ).  Strangly
 > enough, when I do a select here, it looks identical to
 > the results of the method above.

This seems to me to be a problem with the application, and not with
your code, or with DBD::Sybase...

Michael Peppler - Data Migrations Inc. - -
International Sybase User Group -