Setting Double Precision and Scale change database method results

[Ruslan Zasukhin]

On 1/15/09 10:28 PM, "Stan Busk" <maxprog at mac.com> wrote:

Hi Stan,

> After issuing the following SQL command:
> 
> myDB.SQLExecute( "ALTER TABLE myTable MODIFY myNumber double( 24, 2 )" )
> 
> in order to set double scale to 2 the following myDB method always
> returns 0:
> 
> Function myTable.GetmyNumberValue( inRec As Integer ) As Double
> 
>    If RecordExists( inRec ) then
>      RecID = inRec
>      return myNumber.Value
>    End If
> 
> End Function
> 
> I have checked whether inRec is valid and it is. If I close the
> database and reopen it the problem disapears. As soon as I run again
> the command to set the double scale the problem returns.
> 
> Ruslan you said that changing a double or a float Precision and Scale
> parameters only affects string to/from conversion when using
> VField.GetString(). Am I wrong? Why does it cause this effect?

Yes.

I see you use Class way. May be this is why?
May be changed field is not related to your Class field?


Check Valentina logs to see may be any warnings on this ?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]