[VSDK] SQL problem

[Eric Forget]

> 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?

Éric

___________________________________________________________________

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