General information
Category:
Coding, syntax & commands
Instead of ALLTRIM(STR(rendoring)) use:
PADL(rendoring,10,'0')
>Hi,
>
>The field was actually numeric in the table from which the select statement was done. However, the select statement selects that field like so:
>
>Select allt(str(rendorind)) from V11481.dbf into table TmpClaim
>
>So the TmpClaim table now has a rendorind field that is char(10). The rendorind is "0" for all records in the tmpclaim table.
>
>I try to append the contents of tmpclaim table to the process table (which contains a rendorind field, char(10)). Once appended, the records are all blank for that field.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only