sql default value

[Bart Pietercil]

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