Hello Neven,
Can I ask you a question. How come that your database doesn't have decimal
point facility, there must be something like numeric type. I don't know
whats your database engine is ?
Now, try this one.
First you have to know how many digit that you gonna need. In this example,
lets say 3 digit for decimal point.
edit your datawindow, go to SQL datasource toolbar.
Select column that you want to use it including column that can't save
decimal point, then go to compute column, set new variable like
your_numeric_column / 1000 as
ln_value. Any other think that you want to put in this area, go ahead.
Go back to layout by clicking SQL datasource toolbar.
remove column that can't have decimal think from your layout.
Arrange your layout, for ln_value properties, set picture format in edit and
format section.
At update properties, set column and option that you want to saved not
include ln_value. Save your datawindow.
On your window that contain this datawindow, please open datawindow script.
Go to pfc_preupdate or your event that might trigger your save / update
event when it come to save your data,
then write this script in your event,
this.setitem( this.getrow(), this.getitemdecimal( this.getrow(),
'ln_value' ) * 1000, your_numeric_column )
this.accepttext()
note: remeber that 3 digit decimal point will set as 1000, 2 digit will be
100, and soon ...
your_numeric_column is your column that can't provide you decimal
type.
the rest is yours, see yaa.
AST
----- Original Message -----
From: Neven Crnosija <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 07, 2000 10:39 PM
Subject: PFCSIG URGENT! Itemchanged story...
> Hi, guys. I hope it is not to late to have an answer from somebodey that
can
> help.
>
> I have a kind of a problem. You see, I have to make next:
>
> In database I can not have decimal numbers, so I am able to store only
whole
> numbers ( 1, 2, 3, 4... but not 1.23, 2.31 ). So, the solution was to have
,
> for example number 3.234 stored as 3234 in a database or 0.234 as 234. OK,
> but that is not the problem! The problem is how to take care of that
column
> input? And, if someone can help me, please, is there any way for me to get
a
> reference of a column (type dwItem) in a DW controle if I know columns's
> name or ID? Thank YOu very much for Your help...
>
> Best regards
> Neven Crnosija, prof.
>
>
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
>
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
