Post reply

Field Data change during reading

  • January 10, 2020 at 10:27 pm

    #3714587

    Here is an impossible issue.  First, everything works perfectly on my machine, running Win 10.  This happens ONLY on my client running Windows Server.

    Complex query with many tables, two of the fields, one date one Int are having their values change during reading of the recordset.  I proved this by writing the records to a text file.

    First, before the code actually uses the records, I open the query and dump the records field by field to a text file such as:

    For Each FldObj In RSTBL.Fields

    TxtObj.WriteLine "1-" & FldObj.Name & "=[" & FldObj.Value & "] Null=" & IsNull(FldObj.Value) & " Len=" & Len(FldObj.Value)

    TxtObj.WriteLine "2-" & FldObj.Name & "=[" & FldObj.Value & "] Null=" & IsNull(FldObj.Value) & " Len=" & Len(FldObj.Value)

    Next

    Notice I write the field values TWICE and everything is fine. Specifically this field:

    1-NumTasks=[89] Null=False Len=2

    2-NumTasks=[89] Null=False Len=2

    and these fields

    1-OtherPreds=[] Null=True Len=

    2-OtherPreds=[] Null=True Len=

    1-OtherPredsID=[] Null=True Len=

    2-OtherPredsID=[] Null=True Len=

    Both should be NULL as it shows.

    Next lines of code reopen the query and I do the same thing, dump records into a test file of only the fields causing problems. Get a load of this:

    --- NumTasks= Null=False Len=0

    NOPE!!!  It should contain the value 89

    Then there is this weird happening.

    --- OtherPredsID= Null=True Len=

    --- OtherPredsID again= Null=False Len=0

    ----- OtherPredsID and again= Null=False Len=0

    With every record read in when I check this field it is correct at first, NULL.  But I immediately write the same field again to the text file and now it's not null!!!  But zero length string!!

    This is a read only recordset, values in fields CANNOT be changed. This works fine on my Win 10 PC, this only happens on their Win Server, and ONLY these fields in the recordset, the rest are fine.

    Anyone experienced this?

  • January 11, 2020 at 11:10 pm

    #3714706

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply