PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
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
-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler@peppler.org - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com