[V4RB] Updating index of newly imported records seems to fail for me

[Erik Mueller-Harder]

Hi, Richard --

Is it possible that the serverURL field in your Windows implementation 
isn't actually completely empty?  Perhaps there are stray CRs, LFs, or 
spaces in the field.  Try this instead:

      rowsAffected = thePPOBase.SqlExecute("UPDATE Newsgroup SET
      ServerURL = '" + newsServerURL + "' WHERE ServerURL < '!'")

That will update all records where the first character is any of the 
ASCII control values or a space.

HTH,

-- Erik


>          ' ********** RUSLAN PLEASE LOOK HERE ! **********
>
>           ' ********** THIS SQL EXECUTE RETURNS 0 (ZERO) IN 
> rowsAffected
> **********
>           rowsAffected = thePPOBase.SqlExecute("UPDATE Newsgroup SET
> ServerURL = '" + newsServerURL + "' WHERE ServerURL = ''")
>
>           '' Because of a bug in Valentina (I think), reindex the
> server_recid field, and then all is fine.
>           '