Recent content by SKaushal

Hello Everybody, Greetings. Once again back with a problem. I'm writing a program to audit the changes to table and wrote a database trigger as follows: /* ------------------------------- */ TRIGGER PROCEDURE FOR WRITE OF Invent OLD BUFFER oInvent. DEFINE VARIABLE tmp-List AS CHARACTER...

I'm new to triggers. Any exapmle/s on how to use triggers will be highly appreciated. thnx SK

Hello Everybody, I need your help!!! I have to maintain a log of all the changes made to a Record in a Table, whether the record is deleted or modified or created. I have to store the field changed and details who changed it an when. Also I have to store the new changes in the record...

Hello there, I'm having a problem with array field comparision. I have a table "Wrk-Table-Item" With fields: Customer Pur-Date Qty Price of the Item changes frequently, so I have to keep track when the price changes and the multiply the Qty purchased by the customer betwwen those dates...

Hi, I am having a problem of displaying output in the following format: Invoice Date Amount Invoice Date Amount 12345 04/02/17 200.00 12361 04/02/21 100.11 12346 04/02/18 200.00...

Hi Everybody, I'm having a problem: I want to send the Column(C-No) to a Temp-table from a "Browse" Widget that is begin displayed in a frame, NOTE :But only the results which are in the screen i.e just 17 row's C-No's, however the query may return 30 or 40 rows.One more thing, also the we...

Greetings All, My problem is that I want to send a report file to multiple persons. e.g using UNIX SILENT "mail -s "XYZ Report" users@you.com<report.file" Where users can be 1 or 2 or 10 With different names but same domaim name ie @you.com Thanks Sanjeev

Thanks for the help. But In my problem the variable is DECIMAL not Integer.

Hi Can a Charcter field be Right-Aligned(By Default it is left aligned) when we use PUT STREAM to send data to a file. Cheers

Hi Everybody, Problem: I have to change the last digit of a negative number as follows: if a negative number ends in "0" then change last digit to "}" if a negative number ends in "1" then change last digit to "K" and so on.................. e.g if negative number is " -...

Hi Everybody, Problem: I have to change the last digit of a negative number as follows: if a negative number ends in "0" then change last digit to "}" if a negative number ends in "1" then change last digit to "K" and so on.................. Help me out Please. Thanx

Hi Everybody, Problem: I have to change the last digit of a negative number as follows: if a negative number ends in "0" then change last digit to "}" if a negative number ends in "1" then change last digit to "K" and so on.................. Help me out Please. Thanx

I have a character field as Note x(250) and i'm using editor to enter data into it.I'm facing following problems 1) Can I restrict just 250 characters to it because it accepts more than what i hv specified. 2) How to get this fiel printed in just 2 lines. 3) If we press enter in Editor it...