1. Home
  2. Point-Of-Sale Software
  3. How to access a category name and code from vbscript

How to access a category name and code from vbscript

I am modifying the lineitem.html for the status bar in Store operation. I want to ask how can i access the category name and code for each item, i only can find a categoryid function, which is in the TransactionEntry.Item.CategoryID, but can not access the name and code for the category

Reply to
Raemond
Loading thread data ...

Raemond,

You will need to retrieve the name and code via SQL using the ID:

resultSet=QSRules.OpenRecordset("SELECT Name, Code FROM Category WHERE ID=" & TransactionEntry.Item.CategoryID, true)

- Evan Culver New West Technologies

Raem> I am modifying the lineitem.html for the status bar in Store operation. I

Reply to
Evan Culver

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.