Including tax in total sale price.

Posted by Frank Computer on Stack Overflow See other posts from Stack Overflow or by Frank Computer
Published on 2010-06-13T07:16:11Z Indexed on 2010/06/13 7:22 UTC
Read the original article Hit count: 263

Filed under:

informix

INFORMIX-SQL 7.3 Perform Screen:

Suppose I have a customer who wants to pay a $100 (7% tax included), what logic can I use so that when the cashier clerk enters $100 in the tax included sale amount, it will calculate the sale price and tax so that it adds up to $100.

I have the folllowing 3 field tags in my perform screen:

sprice = transaction.sale_price; stax = transaction.sale_tax; stotal = transaction.sale_total;

after editadd of transaction.sale_price

? ? ?

Related posts about informix

How to improve Java perfomance on Informix for Windows

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with performance of Java UDR functions on Informix on Windows. On this server I already have some functions in C and SPL. I chose one function to write it in those 3 languages and I measured performance of this function on test table. Function calculates some kind of checksum so it… >>> More
Informix "Database locale information mismatch"

as seen on Server Fault - Search for 'Server Fault'
I have informix 11.5 running in my Win-2003 box and few databases running in it. System databases have locale en_us.819 My custom databases have locale en_us.57372 (UTF8). There is also application deployed to JBoss 4.0.2 which has few datasources configured for those custom databases. <local-tx-datasource> <jndi-name>InformixDS</jndi-name> <connection-url>jdbc:informix-sqli://@database… >>> More
Problem with Informix JDBC, MONEY and decimal separator in string literals

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with JDBC application that uses MONEY data type. When I insert into MONEY column: insert into _money_test (amt) values ('123.45') I got exception: Character to numeric conversion error The same SQL works from native Windows application using ODBC driver. I live in Poland and have… >>> More
Users Login Info in INFORMIX-SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
INFORMIX-SQL 4.1 - There's this ASCII UNIX file called "passwd" in /usr/informix/etc which holds all the user id's and encrypted passwords to log into ISQL. Is there a system catalog table which holds the logged in users? I see a SYSUSERS.DAT file but when I queried it, it didnt show my login id… >>> More
String concatenation within INFORMIX-SQL "Perform" screens.

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I concatenate two char columns within a perform screen? example: table sample col1 char(1), col2 char(1) . . after editadd of sample let label_3 = sample.col1 + sample.col2 .. this didn't work, I even tried using subscripts for the 2 cols but no dice! >>> More

Developer IT

Including tax in total sale price. - Developer IT

Including tax in total sale price.

informix

Related posts about informix

How to improve Java perfomance on Informix for Windows

Informix "Database locale information mismatch"

Problem with Informix JDBC, MONEY and decimal separator in string literals

Users Login Info in INFORMIX-SQL

String concatenation within INFORMIX-SQL "Perform" screens.

Categories cloud