V4MD problem with UPDATE?

[Ruslan Zasukhin]

on 12/10/03 6:39 PM, Rob Wingate at rwingate at visual-book.com wrote:

Hi Rob,

> In the past, I've successfully used Valentina with multiple huge databases
> holding tons of tables.
> 
> But I'm suddenly confused at what seems like a simple task.  I have a very
> small table that looks like this:
> 
> ID___SEQ___NAME___
> 1    1     Alex
> 2    2     Bob
> 3    3     Cathy
> 4    4     Dan
> 
> The ID and SEQ fields are indexed.  Then I execute this statement:
> 
> 
> DbObj.SqlExecute("update MYTABLE set SEQ=SEQ-1 where ID=3", [])
                                        ^^^^^^^^^^^^
                                    Valentina 1.x do NOT support
                                update of field by EXPRession,
                                only constants.
                   

> Immediately afterward, the table looks like this:
> 
> ID___SEQ___NAME___
> 3    0     Cathy
> 1    1     Alex
> 2    2     Bob
> 4    4     Dan
> 
> What could I be doing wrong?  I'm using V4MD 1.9.6

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