I am trying to add the Batch Start date to the HTML Status window. I can get the Batch number using QSRules.Register.Batch.Batchnumber but QSrules.Register.Batch.OpeningTime returns nothing
any help appresiated
Greg
HI Morcott, You can use the below code to get the batch No, the time it opened. Set QSRules = qsBridge.RequestQSRules() strSQL = "" strSQL = "SELECT Batch.BatchNumber, Batch.OpeningTime From Batch " strSQL = strSQL & " LEFT JOIN Register ON Batch.RegisterID = Register.ID" strSQL = strSQL & " WHERE Register.Number =" & QSRules.Session.Register.Number strSQL = strSQL & " AND Batch.ClosingTime IS NULL " Set Rs = QSRules.Session.Database.OpenRecordset(strSQL, True)
' ' IF NOT RS.EOF AND NOT RS.BOF THEN Batch = "Batch # " & Rs.Fields("BatchNumber") & " Opened on " & Rs.Fields("OpeningTime") END IF ' ' Batch = Batch & " T: "
I appreicate if you rate me please.
"Morcott" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.