HTML Status Window

Mar 12, 2007 1 Replies

Rate this thread:

Morcott 19 years ago

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

Vote

Akber Alwani 19 years ago

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:

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required