Required Fields

CBenito · Post by **CBenito** » Tue 22 Feb 2005 10:47

Hello,

I am using dbexpsda.dll and all the fields appears as NOT required.

This bug is not link to a specific version of Sql Server it´s just a design problem of the dll.

I have the same problem with the driver of Oracle and it appears that this will be fixed in the next release.

Thanks

Ikar · Post by **Ikar** » Tue 22 Feb 2005 13:43

Setting flag isNullable = False (Required = True) causes problems with editing queries that include autoincrement fields (NOT NULL AUTO_INCREMENT) or NOT NULL fields with DEFAULT VALUE.

> I have the same problem with the driver of Oracle and it appears that this
> will be fixed in the next release.

We'll discuss this issue.

CBenito · Post by **CBenito** » Mon 28 Feb 2005 17:14

If there are problems with editing querys, Required = True and Autoincrement or Default Value fields, Core Labs has 3 options:

1- Fix this problem (i don´t known if it is possible)
2- Set Required = False in this kind of fields
3- Warn the user to set it to False in this kind of fields.

But I think that the solution of Set = False in ALL fields in not a good solution.

Thanks in advance

Ikar · Post by **Ikar** » Wed 02 Mar 2005 07:23

> 1- Fix this problem (i don´t known if it is possible)

This code is Borland one and we are unable to change this behaviour.

> 2- Set Required = False in this kind of fields

Getting a list of fields with DEFAULT VALUE requires an additional reference to the server that causes performance loss.

> 3- Warn the user to set it to False in this kind of fields.

It's not acceptable especially for users who use our driver for several years.

Now we are considering a possibility of adding an additional option setting that will set IsNullable flags.

CBenito · Post by **CBenito** » Wed 02 Mar 2005 18:33

It could be a good solution, but anyway there must be an "automatic option", now i have to set the required in every DataSet!

Thanks a lot.

Nitewing · Post by **Nitewing** » Tue 22 Aug 2006 10:18

I have scanned the dbExpress driver for SQL Server History, and I notice that the IsNullable Solution has not been built into the driver,

or has it been put into the driver and not documented.

all I am wanting to know is has this problem been adressed, or is it still been considered as a possibility, or has it slipped off the radar since Wed Mar 02, 2005 6:33 pm.

Guest · Post by **Guest** » Tue 29 Aug 2006 08:16

Hey I have the same problem -> how do i find out if field is required or not (i.e. not null).

Is this bug ever going to be fixed or an extra property made to find out what the field status is?

Jackson · Post by **Jackson** » Thu 31 Aug 2006 14:40

This functionality will be added in the next build of DbxSda (3.10.6). It will be available in about one week.
Please watch for announcements at the forum.

Nitewing · Post by **Nitewing** » Fri 01 Sep 2006 05:15

thanks EvgeniyM, Just one more quick question we are using 2.50.5 currently, will we have access to 3.10.6 or will this require additional purchasing

Antaeus · Post by **Antaeus** » Fri 01 Sep 2006 07:42

You will be able to download DbxSda 3.10.6 and next versions of DbxSda 3 only after purchasing Version Upgrade.

Guest · Post by **Guest** » Fri 01 Sep 2006 08:10

Surely u mean 3.00.6 or is the revision higher?

Antaeus · Post by **Antaeus** » Fri 01 Sep 2006 08:32

Next build of DbxSda (3.10.6) will be available in the nearest few days. I mean, if you become registered user of DbxSda 3 you will be able to download this build and future builds of DbxSda 3.

Devart Forums

Required Fields

Required Fields

Has the above possible solution been developed yet???

Future access to next version