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 |