1. Home
  2. Point-Of-Sale Software
  3. Openrecordset to get ExtendedDescription

Openrecordset to get ExtendedDescription

I am trying to get the item's extended description to show up on my net display receipt template. I am using the following in a function, but it does not seem to work:

If Entry Is Nothing then Set Entry QSRules.Transaction.Entries(QSRules.Transaction.Entries.Count) End IF SQL = "SELECT Extendeddescription FROM Item WHERE ItemLookupCode = '" + Entry.Item.ItemLookupcode + "'" Set Rs = QSRules.OpenRecordSet((SQL),(-1)) If Not Rs.EOF Then txtExtendedDescription = Rs("Extendeddescription") End If

I think the issue is the length of the field or the field itself that I am using. This works fine:

If Entry Is Nothing then Set Entry QSRules.Transaction.Entries(QSRules.Transaction.Entries.Count) End IF SQL = "SELECT Notes FROM Item WHERE ItemLookupCode = '" + Entry.Item.ItemLookupcode + "'" Set Rs = QSRules.OpenRecordSet((SQL),(-1)) If Not Rs.EOF Then txtNotes = Rs("Notes") End If

Any help would be greatly appreciated.

Reply to
Jason
Loading thread data ...

Corrections:

1) I am using ExtendedDescription (capitalized D).

2) I meant the HTML status bar, not receipt template.

"Jas> I am trying to get the item's extended description to show up on my net

Reply to
Jason

Reply to
Jason

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.