Skip to Content
avatar image
Former Member

Scripts Issue

Hi All,

I need your suggestions/help regarding a couple of issues im facing in scripts.

1) While developing cheque printing, I have used the standard program and the standard script but copied the script to a local one and did changes to the same. Now I do not need a page for my development, If i delete the page as a whole im getting an error, if Im deleting all the page windows in that particular page then Im getting a blank page. Kindly suggest me how to go about this.

2) The value of the field DMBTR in the database is stored in correct format as say, 21,400.00

But in the script it is showing me a value of 21.400,00 [The coma and the decimal are interchanged], Ive checked my user settings also and they are fine. Because of this Im unable to do any calculations also in my subroutines which follow. Kindly lemme know how to fix this.

Regards,

Narendra.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Feb 20, 2008 at 11:03 AM

    Hi Narendra,

    Could you please tell me what Error you are getting when deleting the page and executing the Form.

    Thanks,

    Karthik

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2008 at 11:05 AM

    Narendra,

    The problem of DMBTR values is due to user setting .

    If after setting the parameters in user setting still u r facing the problem

    then Write the following code in the subroutine in which u r doing calculations:

    Eg:

    DMBTR = 24.000,00

    Declare F1 F2 Final_val etc variables...

    Split the Field into 2 .

    SPLIT DMBTR AT ', ' INTO F1 F2.

    The result is as follows:

    F1 ---24.000 and

    F2 --- 00.

    Now replace the '.' in F1 as follows

    REPLACE '.' in F1 WITH ','.

    CONCATENATE F1 F2 into Final_Val.

    The result for the above code will be

    FINAL_VAL -


    24,000.00

    Remember if after this u get error that will be because of ',' in the value so replace that with space and condense the fields as follows:

    REPLACE ',' IN FINAL_VAL with ' '

    CONDENSE FINAL_VAL NO-GAPS.

    Hope things are clear now..

    Have a nice time..

    Regards..

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hey Dude

      I am tellin you to write currency value to the char var..i think this can be done...

      I am tellin do the calaculation hwat u wnat but just before writing it to layout set write it to the char varaible as i said..

      Cheers

      Anup S.

  • avatar image
    Former Member
    Feb 20, 2008 at 11:09 AM

    1. If you delete all pages then where you will print the data???

    So, dont delete any pages. If you doenot want any page to be displayed. Then delete all page windows from that page.

    And delete the next page assignment then your probelm will be solved.

    2. To get the , . speparators goto the sytem->userprofiles->userdefaults. choose ., opttion.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded