HTML Status Window


M

Morcott

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
 
Ad

Advertisements

A

Akber Alwani

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HTML Status Window Question 2
Purchase History in HTML Status Window 6
HTML Status Bar 9
HTML Status Bar 20
html status screen 3
html status screen 3
HTML STATUS BAR 14
simple query in html status 0

Top