Post reply

SQL Server to display output to HTML box in screen?

  • September 7, 2016 at 1:42 pm

    #313203

    I want to display an HTML [popup] box that displays the Grand Total of a Ticket in a POS.

    The SQL Script is very basic.

    select Grand_Total from Invoice_Totals

    where Payment_Method = 'CA'

    So, if the SQL line that is updated has Payment_Method = 'CA', then display Grand_Total in a nicely formatted HTML box (or similar)

    So the premise here (Use Case) is when the merchant rings in some items at his store, and the customer is paying in CASH (Payment_Method = 'CA') then display a Text/HTML box with [Grand_Total] when the line in the SQL Table Invoice_Totals is updated and Payment_Method = 'CA'

    Thank you to all in advance.

    Chef

  • September 7, 2016 at 1:45 pm

    #1899666

    chef423 (9/7/2016)

    I want to display an HTML [popup] box that displays the Grand Total of a Ticket in a POS.

    The SQL Script is very basic.

    select Grand_Total from Invoice_Totals

    where Payment_Method = 'CA'

    So, if the SQL line that is updated has Payment_Method = 'CA', then display Grand_Total in a nicely formatted HTML box (or similar)

    So the premise here (Use Case) is when the merchant rings in some items at his store, and the customer is paying in CASH (Payment_Method = 'CA') then display a Text/HTML box with [Grand_Total] when the line in the SQL Table Invoice_Totals is updated and Payment_Method = 'CA'

    Thank you to all in advance.

    Chef

    SQL Server doesn't have the ability to display a pop up box. this needs to be done by the front end application.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply