[V4RB] How should I use UpdateAll?

[Ruslan Zasukhin]

on 3/20/03 4:30 PM, Richard Altenburg at valentina at brainchild.nl wrote:

>> Why you say that you work with string value ???
>> You get query as
>> 
>>   UPDATE AvailableGroup SET ServerRecID=5
>>   WHERE ServerRecID=0
>> 
>> Where you see strings?
>> 
>> Yes, staticTextID.Text is string, but this is because we build SQL STRING
>> for query.
>> 
>> In SQL strings are quotes, e.g.
>> 
>>       field = '5'  // this is really STRING '5'
>>           
>> Query 
>> 
>>   UPDATE AvailableGroup SET ServerRecID=5
>>   WHERE ServerRecID=0
>> 
>> Must works!
>> 
>> Does it work for you ?
> 
> NO!
> 
> When I do the UPDATE like you suggest ("SET ServerRecID="+staticTextID.Text)
> then the value actually present in the database becomes '5' instead of 5.

Hmm, impossible.

What type have ServerRecID field ?

> So I can only get the records back by querying with a string value, but that
> is not what a RecID is, so there is no relation in that case.
> 
> I don't know what is wrong, I do what I should do, but it will not work.
> 
> I must try maybe with other fields, not just a staticText.
> 
> So I have some more work to do... And that is fine with me, as long as it
> solves the problems fast and secure. I will let you know how it went. Also I
> will try the BaseObject method suggestion you gave me the other day...

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------