[V4RB] Bug in UPDATE or ImportText or Flush?

[Ruslan Zasukhin]

on 3/25/03 2:08 PM, Richard Altenburg at valentina at brainchild.nl wrote:

> On 23-03-2003 20:04, "RBtools" <RBtools at columbus.rr.com> wrote:
> 
>> My suggestion would be to use iVSQL and perform the search SELECT groupname
>> FROM AvailableGroup order by RecID
>> 
>> Then verify that the RecID is correctly set for each record or just make
>> sure it is not always the same.
>> 
>> The other search could be (the sql might not be correct)
>> 
>> Select distinct RecID from AvailableGroup
>> 
>> This will give you the complete list of RecID's and let you know the number
>> of distinct RecIDs that are available.
> 
> Point is: the field RecID is OK, but the field server_recid, which points to
> a table Server, should be numeric, for example 1. But it can only be found
> if I put "1" in my query, which is not even standard SQL.
> 
> Only after re-indexing on this field, I can search for 1, and find all
> records needed. Must be a bug in the UPDATE-command implementation.

Hi Richard,

Will you send me something to test your problem?

I recall you have at least 2 problems:
1) UPDATE of ObjectPtr
2) string constants for numeric fields ???!!!

Please send me something.
I need this to debug it.

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