NAVISION FINANCIAL 3.70 IN DATAPORT I AM EXPORTING DATA TO A TXT FILE. IT IS WORKING OK MY PROBLEM IS I WOULD LIKE TO HAVE SOME OF THE FIELD ADJUSTED TO THE RIGHT AND SOME TO THE LEFT HOW DO I DO THAT
Carsten, I am assuming that you are using a fixed format export. You can create global variables within the dataport. You then use the OnBeforeExport trigger to assign the data (from the record in quetion) to the var. Then in the Dataport Fields window you can list the var instead of the field. Once you have the field data exporting as a variable, then you can modify the variable … say by padding the text to left or right justify the string. You can also use the SourceExpression field on the Property Sheet of the Field to FORMAT, or UPPERCASE/LOWERCASE, etc. -john
quote:
NAVISION FINANCIAL 3.70 IN DATAPORT I AM EXPORTING DATA TO A TXT FILE. IT IS WORKING OK MY PROBLEM IS I WOULD LIKE TO HAVE SOME OF THE FIELD ADJUSTED TO THE RIGHT AND SOME TO THE LEFT HOW DO I DO THAT
Originally posted by CARSTEN OKHOLM - 2004 Oct 12 : 15:53:54
Please refrain from using all upper case - this is considered rude in online communication…
You might want to try to use the FORMAT property for te dataport fields. You can define things like: … := [… | Filler | 1000Character | Comma | Overflow | Filler Character | Precision] … This is just a copy from th CSIDE Reference Guide. Have a look there.
my requirment is i need to write record to an text file when it is inserted in Database
now i am able to write record in to text file but when another record is inserted the previouse record writen in the text file is getting overwrite