[Gambas-user] Specifying NOT NULL on adding Index (gb.db)

[Safiur Rahman]

Hi

Most of the time I don't need default values for the fields but have to
mark them NOT NULL. So providing a separate option for NOT NULL would be
helpful.

On Sat, May 7, 2022 at 3:09 PM Safiur Rahman <isafiur at gmail.com> wrote:

> Hi
> I meant to put option to specify NOT NULL while creating fields.
>
> .Table.Fields.Add (gb.db)
> Sub Add ( Name As String, Type As Integer [ , Length As Integer, Default
> As Variant, Collation As String ] )
>
> should have an option to specify NOT NULL
>
> The index will be NULL or NOT NULL accordingly
>
>
> On Sat, May 7, 2022 at 11:50 AM Safiur Rahman <isafiur at gmail.com> wrote:
>
>> Hi
>>
>> While creating index how can I declare the indexed column as "NOT NULL"
>>
>> .Table.Indexes.Add (gb.db) should have an option to specify NOT NULL
>> --
>> Regards
>> Safiur Rahman
>>
>
>
> --
> Regards
> Safiur Rahman
>


-- 
Regards
Safiur Rahman
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20220509/8c2527f1/attachment.htm>