TechTip: Access Packed Data in "Flat Files" with a Table Function (1 viewing) (1) Guest
Favoured: 0
|
|
|
TOPIC: TechTip: Access Packed Data in "Flat Files" with a Table Function
|
|
|
|
TechTip: Access Packed Data in "Flat Files" with a Table Function 3 Years, 8 Months ago
|
Karma: 0
|
|
Hi Britta <p>Replace <p>IF Dec = 0 Then <BR>
Set Data = Char(Decimal(Data,30,0)*Sign); <BR>
ELSEIF Dec = 1 Then <BR>
Set Data = Char(Decimal(Decimal(Data)/10,30,1)*Sign); <BR>
ELSEIF Dec = 2 Then <BR>
Set Data = Char(Decimal(Decimal(Data)/100,30,2)*Sign); <BR>
ELSEIF Dec = 3 Then <BR>
Set Data = Char(Decimal(Decimal(Data)/1000,30,3)*Sign); <BR>
ELSEIF Dec = 4 Then <BR>
Set Data = Char(Decimal(Decimal(Data)/10000,30,4)*Sign); <BR>
ELSEIF Dec = 5 Then <BR>
Set Data = Char(Decimal(Decimal(Data)/100000,30,5)*Sign); <BR>
ELSE Set Data = Char(Decimal(Decimal(Data)/1000000,30,6)*Sign); <BR>
END IF; <p>with <p>Set Data = Char(Decimal(Decimal(Data)/10**Dec,30,6)*Sign); <p>Sincerely Andreas
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
TechTip: Access Packed Data in "Flat Files" with a Table Function 3 Years, 8 Months ago
|
Karma: 1
|
|
This is a discussion about <B>TechTip: Access Packed Data in "Flat Files" with a Table Function</b>.<p align='center'><a href=http://www.mcpressonline.com/mc?
This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
@.6b2213f0>Click here for the article</a>.</p>
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
TechTip: Access Packed Data in "Flat Files" with a Table Function 3 Years, 8 Months ago
|
|
|
Of course it should be: <p>Set Data = Char(Decimal(Decimal(Data)/10**Dec,30,Dec)*Sign); <p>Andreas
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
|
|