Re: [Squirrel-sql-users] Can't update column with type char(1)

[<dgu...@re...>]

Hi Gerd,

You're right, I mean updating data in a contents tab. I just select 'Make
editable' in a cell of type char(1) and try to modify its value, but I
can't append any char or delete.

I"m using Ubuntu Linux, Squirrel Sql 2.0 RC 1 with Java 1.5 and a
connection to SQL Server.

Thanks a lot.

David.


> Hi David,
>
> I guess you're not talking about a SQL Update statement. This would be
> like
> update MYTABLE set mychar = 'z'
>
> You probably mean updating data in the contents tab or in a SQL result.
> I tried out both on SQL Server and char(1) field and it just worked fine.
>
> Could you give some more details? What OS do you use.
>
> Gerd
>
> dgu...@re... wrote:
>> Hello,
>>
>> I"m using squirrel sql 2.0 RC 1 with Java 1.5 and an alias for connect
>> to
>> SQL Server.
>>
>> Does anyone know how to modify the value of a column with type char(1)?
>>
>> I can update any column but columns with this type of data.
>>
>> Thanks.
>>
>> David.
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by the 'Do More With Dual!' webinar
>> happening
>> July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
>> core and dual graphics technology at this free one hour event hosted by
>> HP,
>> AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squ...@li...
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>>
>
>