|
Posted by Akber Alwani on March 13, 2007, 2:56 am
Please log in for more thread options
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:
> 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
>
>
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap