[VSDK] SQL problem

[Eric Forget]

> On 11/17/04 11:34 PM, "Eric Forget" <forgete at cafederic.com> wrote:
> 
>>> On 11/17/04 9:38 PM, "Eric Forget" <forgete at cafederic.com> wrote:
>>> 
>>> Hi Eric,
>>> 
>>>> I'm trying to update a Text field of all the records of one table. My query
>>>> looks like this:
>>>> 
>>>>     UPDATE TableName SET FieldName = ''
>>>> 
>>>> Unfortunately, once executed, without errors from VSDK, orphans elements
>>>> are
>>>> created on the FieldName field. Is it a problem with my query or with VSDK?
>>> 
>>> I think bug.
>>> 
>>>> If it is my query, how do I set a Text to either NULL or empty string?
>>> 
>>>      UPDATE TableName SET FieldName = NULL
>>> 
>> 
>> That do not work either. It set the FieldName value to the string 'NULL'.
>> Another bug? Would you mind looking at it?
> 
> I believe that was fixed in 1.11
> 
> Have you update you VSDK ?
> 
> Have I made It for GCC? :-)

It is not available online... ;-)

Éric

___________________________________________________________________

 Eric Forget                       Cafederic
 ForgetE at cafederic.com             <http://www.cafederic.com/>