main logo
Subject: Re: [V4RB] UPDATE ignoring WHERE clause
Author: "Frank Schima"
Posted: 2002/07/29 12:19:30
 
View Entire Thread
New Search


Hi Ruslan,

> > I'm having a problem with the UPDATE SQL command in V4RB. It seems to be
> > ignoring the WHERE clause. When I do the following SQL statement for example:
> >
> > UPDATE mytable
> > SET myfield = 1
> > WHERE Recid = 1
> >
> > It will update all the records in the table. I tried using another field in
> > the table in the WHERE clause, it was a Varchar, but the same thing happened.
> >
> > Using V4RB 1.9.6b4 (same problem with 1.9.6b2).
> >
> > Does anyone else see this?
>
> Unbelievable.
>
> can you check
>
> 1) __TEST project. Find in SQL_Test corresponded function.
> and in App module -> ListOfAllMethods enable that function.
> Run test

The _Test project fails the UPDATE WHERE and DELETE WHERE tests.

> 2) make for me test


Best Regards,
Frank

--
Frank Schima <mailto:rezcqz001 /at/ sneakemail .DOT com>
INADEV Consulting Inc. <http://www.inadev.com/>
Columbia, MD USA <http://columbiamaryland.com/>
 
©2002 Frank Schima
<-- Prior Message New Search Next Message -->