Setting Double Precision and Scale change database method results

[Stan Busk]

Hi,

Nothing in the warning log. Yes, I use the Class way. The field I  
change its scale is actually the same I try to read later.
Note that the problem doesn't affect VCursors, only when selecting a  
record and getting the value directly from the table field.
I have tried with several databases, same effect on all but as soon as  
I close and reopen the problem disappears.

Stan

> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina