Hi again!
>Hi Jörg,
>
>Now we at least know that it happens on VFP side. All we have to do is to find where and why. :)
:)
>
>What's the value in the view after you entered 1050 and before TABLEUPDATE()? If it's already 1049 than it's something in your form does that. If it's 1050 than I've no idea what would cause that problem.
>
before Tableupdate() it is 1050. So i Think the view does the subtraction bud why?
If i check the View Properties for this column i can see:
DBSetProp(ThisView+".pimzterminanfang","Field","Comment","Zeit des Terminanfangs")
DBSetProp(ThisView+".pimzterminanfang","Field","DataType","N(10)")
DBSetProp(ThisView+".pimzterminanfang","Field","DefaultValue","0")
DBSetProp(ThisView+".pimzterminanfang","Field","UpdateName","pim.pimzterminanfang")
DBSetProp(ThisView+".pimzterminanfang","Field","KeyField",.F.)
DBSetProp(ThisView+".pimzterminanfang","Field","Updatable",.T.)
Do you think that is there something wrong?
>
>>
>>Column: pimzterminanfang numeric 5,0 precision 8
>>
>>If i look into the SQL Profiler Log, the value has been reduced:
>>In the Form i entert a value by 1050
>>The SQL Profiler Log:
>>
>>exec sp_executesql N'UPDATE pim SET pimdterminanfang=@P1,pimzterminanfang=@P2,pimdterminende=@P3 WHERE pimlfdnr=@P4 AND pimdterminanfang=@P5 AND pimzterminanfang=@P6 AND pimdterminende=@P7', N'@P1 datetime,@P2 numeric(8,0),@P3 datetime,@P4 char(10),@P5 datetime,@P6 numeric(8,0),@P7 datetime', 'Mai 13 2004 12:00:00:000AM', 1049, 'Mai 13 2004 12:00:00:000AM', ' 112000697', 'Mai 13 2004 12:00:00:000AM', 1108, 'Mai 13 2004 12:00:00:000AM'
>>
>>You can see the update statement @P2 the value is 1049
>>
>>what could this be?