[VSDK] SQL problem

[Ruslan Zasukhin]

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


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------