Sorting out Val Studio Part 2

[Ruslan Zasukhin]

On 6/19/08 5:30 PM, "Kay C Lan" <lan.kc.macmail at gmail.com> wrote:

> 7) In the SQL Editor:
> 
> select * from taddress where fname = 'Adler'
> result = 0 record => not expected
> 
> select * from taddress where fname like '%dler'
> result = 1 record => 'Adler' as expected
> 
> select * from taddress where fname like 'Adle%'
> result = 1 record => 'Adler' as expected
> 
> select fname from taddress where recid = '1'
> result = 1 record => 'Adler' as expected
> 
> 
> update taddress set fnumber = '5551234' where fname  = 'Adler'
> 
> I get this output:
> 
> 18:32:15: "update taddress set fnumber = '5551234' where fsname = 'Adler'" has
> been executed
> 
> BUT if I use recid
> 
> update taddress set  fnumber = '5551234' where recid = '1'
> 
> I get this output:
> 
> 18:32:41: Number of affected rows: 1, query time: 0.003 sec
> 
> BUT in BOTH cases, if I
> 
> select fnumber from taddress where recid = '1'
> 
> the result is the old number, not '5551234'

Best of all send us this db and steps with queries to do
    so we check it here.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]