MC Press Online Forum
Welcome, Guest
Please Login or Register.    Lost Password?
TechTip: Access Packed Data in "Flat Files" with a Table Function (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: TechTip: Access Packed Data in "Flat Files" with a Table Function
#118349
101communications (User)
Posts: -10
graphgraph
User Offline Click here to see the profile of this user
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>
&nbsp;&nbsp;&nbsp;Set Data = Char(Decimal(Data,30,0)*Sign); <BR>
ELSEIF Dec = 1 Then <BR>
&nbsp;&nbsp;&nbsp;Set Data = Char(Decimal(Decimal(Data)/10,30,1)*Sign); <BR>
ELSEIF Dec = 2 Then <BR>
&nbsp;&nbsp;&nbsp;Set Data = Char(Decimal(Decimal(Data)/100,30,2)*Sign); <BR>
ELSEIF Dec = 3 Then <BR>
&nbsp;&nbsp;&nbsp;Set Data = Char(Decimal(Decimal(Data)/1000,30,3)*Sign); <BR>
ELSEIF Dec = 4 Then <BR>
&nbsp;&nbsp;&nbsp;Set Data = Char(Decimal(Decimal(Data)/10000,30,4)*Sign); <BR>
ELSEIF Dec = 5 Then <BR>
&nbsp;&nbsp;&nbsp;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
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#118348
MC Press Web Site Staff (Admin)
Admin
Posts: 1061
graphgraph
User Offline Click here to see the profile of this user
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>
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#118350
Guest.Visitor (Visitor)

Birthdate:
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
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
   MC-STORE.COM