sql default value

[Christian - ChrisKatDev.com]

thanks :-)


Le 20 sept. 08 à 17:06, Bart Pietercil a écrit :

> Bonjour Christian,
>
> that information is available on the wiki
>
> http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documentation:vsql:reference:update
>
>
> Update t1 set field_with_default_values = default where......
>
> bat,
>
> Bart Pietercil
>
> On 20 Sep 2008, at 16:58, Christian - ChrisKatDev.com wrote:
>
>>
>> Le 20 sept. 08 à 16:47, Bart Pietercil a écrit :
>>
>>> Hi Christian,
>> Hi Bart,
>>>
>>>
>>> I would expect that when you do an insert and you don't specify
>>> values
>>> for fields that have default values, the default values will be
>>> inserted (untested, but that is what I would expect...)
>>
>> Not when insert, but when upate records...
>> I search a sql command for "reseting" exist records at defaults
>> values...
>>>
>>>
>>> hth,
>>
>> br
>> Christian
>>>
>>>
>>> Bart
>>>
>>> On 20 Sep 2008, at 13:04, Christian - ChrisKatDev.com wrote:
>>>
>>>> Hello,
>>>>
>>>> Have you sql command with set field of record at default value if  
>>>> it
>>>> exist ?
>>>>
>>>> br
>>>> Christian
>>>>
>>>> _______________________________________________
>>>> Valentina mailing list
>>>> Valentina at lists.macserve.net
>>>> http://lists.macserve.net/mailman/listinfo/valentina
>>>
>>> _______________________________________________
>>> Valentina mailing list
>>> Valentina at lists.macserve.net
>>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina