Why won't this update statement work?

[Ruslan Zasukhin]

On 3/13/04 8:57 PM, "Kristafer Vale" <kristafer at comcast.net> wrote:

Hi Kristafer, 

> I'm attempting to test the UPDATE feature with this line of code in Director
> MX 2004 on a PC running XP Pro.
> 
> myTEST = SqlExecute(gMyLessonDB, "UPDATE slides SET SlideOrder = '003' ")
> 
> It always returns zero no matter what, even though there are 3 records in
> the slides table.
> 
> Is there something wrong with the UPDATE feature? Have I misunderstood the
> documentation?
> 
> This is really frustrating, so any help is much appreciated.

1) please check Valentina error
    may be you have some typo?

2) try do this command in viSQL or Valentina Studio
    and see results

3) may be column SlideOrder is marked as unique?


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