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: "Patrick S dot Leung" <pleung at easygroup dot com>
Subject: Re: problem with ct_send_data
Date: Jun 16 2000 4:16AM

Thanks Mike.  You are right.  I changed the stored proc to insert a " "
initially, and then my perl script works great now.  I've overlooked that
ct_send_data cannot update NULL fields.

Rgds, Patrick

Michael Peppler wrote:

> Patrick S. Leung writes:
>  > I modified one of my old update text scripts, and it didn't work
>  > afterward.  The table has one text column,
>  >
>  > And here is the error message:
>  >
>  > Server message: (In srv_cb)
>  > Message number: 156, Severity 15, State 1, Line 1
>  > Server 'DEVELOP1'
>  > Message String: Incorrect syntax near the keyword 'NULL'.
>  > ...
>  > (more errors below)
> That looks like a problem with the fact that the data in the column is
> NULL initially (I think!).
> Try setting the column to '' first, and see if that fixes the problem.
> Michael
> --
> Michael Peppler         -||-  Data Migrations Inc.
>    -||-
> Int. Sybase User Group  -||-
> Sybase on Linux mailing list: