I would like to add a line of data into the table belteksales when chargeamount is not equal to 0
this is the code I have, but I do not think it is the correct format.
if chargeamount <>'0'
insert into belteksales (WarehouseNo, Salesrepname, Invoiceno, Customerno, BillTo, BillName, CashAmount, Tax1total, InvoiceTotal)
what do you think I can do ??