[V4RB] Bug in UPDATE or ImportText or Flush?

[Richard Altenburg]

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.