[V4RB] Bug in UPDATE or ImportText or Flush?

[RBtools]

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.

Hope this helps,

Steve
on 3/23/03 3:17 AM, Richard Altenburg at valentina at brainchild.nl wrote:

> On 23-03-2003 09:07, "Richard Altenburg" <valentina at brainchild.nl> wrote:
> 
>>> vcsImportGroup=New VCursor(ppPiPaBase, "SELECT groupname FROM AvailableGroup
>>> WHERE RecID=0")
>>>       
>>> If (vcsImportGroup<>Nil) Then
>>>         
>>>  ppPiPaBase.ppAvailableGroup.Groupname.Indexed=False
>>>         
>>>  vcsImportGroup.ImportText(fdiTemp, " ", (Chr(13)+Chr(10)))
>>>         
>>>  ppPiPaBase.ppAvailableGroup.Groupname.Indexed=True
>>>         
>>>  ppPiPaBase.Flush
>>>         
>>>  rowsAffected=ppPiPaBase.SqlExecute("UPDATE AvailableGroup SET
>>> server_recid="+Format(serverIDInPopUpMenu, "############")+" WHERE
>>> server_recid=0")
>>>         
>>>  ppPiPaBase.Flush
>>>         
>>>  vcsImportGroup=Nil
> 
> Still more tests show that it works better with a news server that has only
> 2,100 groups, but still when this is the first server I import, it does not
> work.
> 
> When I have already some 80,000 groups in my database, and then import this
> small server, the groupnames show up immediately after import, and also when
> I do this some more times.
> 
> But when I do a big server, with 40,000 groups, the names do not show up,
> but only after I import still another one.
> 
> So at the beginning of the table nothing works correctly, but after it gets
> filled, things get better.
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina