[dba-SQLServer] Continuous Form Record Disappears

[Jim Lawrence]

When I was printing, in a network situations, I use to create a empty recordset, matching the report, populated it via a query or code and then used that isolated recordset. It would always work perfectly even if the network blew up.

I think pulling directly from a live database can cause problems when multiple users are using the same data.
 
Jim

----- Original Message -----
From: "David Emerson" <newsgrps at dalyn.co.nz>
To: "Discussion concerning MS SQL Server" <dba-SQLServer at databaseadvisors.com>
Sent: Tuesday, May 21, 2019 6:56:17 PM
Subject: [dba-SQLServer] Continuous Form Record Disappears

Hi Listers,

 

I have an Access 2010 accdb using SQL 2017 as the back end.  I have a
continuous form which has the recordset assigned as below when the screen is
opened.

 

    Set rstTemp = basRunDataObject("dbo.usp_RWfrmRework " & Nz(Me!cboFilter,
0) & "," & lngTeamSubID & "," & lngTeamID, adCmdText)

    Set Me.Recordset = rstTemp

    Me.UniqueTable = "dbo.RWRework"

    Me.ResyncCommand = "SELECT dbo.RWRework.* FROM dbo.RWRework INNER JOIN
dbo.RWTeamMember ON dbo.RWRework.RWTeamMemberIDNo =
dbo.RWTeamMember.RWTeamMemberID INNER JOIN dbo.RWTeamSub ON
dbo.RWTeamMember.RWTeamSubIDNo = dbo.RWTeamSub.RWTeamSubID WHERE
dbo.RWRework.RWReworkID = ?"

    Me.Requery

 

This works fine, records can be added and edited.  The only problem is that
when a new record is inserted (by entering in something in any field) then
the previous record fields show blank as if there was no data in them.  The
data is still there.  When the new record is saved and another record is
inserted then the data from the previously blank looking record appears and
the data from the last record entered is not blank looking.

 

Has anyone come across this before or have any ideas how I can prevent it?

 

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand

 

 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com