TFieldDefs Required is always false

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
Krigu
Posts: 1
Joined: Mon 10 Dec 2007 14:07

TFieldDefs Required is always false

Post by Krigu » Mon 10 Dec 2007 14:13

Hi

We figured out that the Property Required from TFieldDefs is always False when we're using your driver. If we use the standard Borland/CodeGear-Driver it works fine.

We're using the version 4.10.3.0

Is there are workaround for this issue?

Thanks in advance

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 11 Dec 2007 10:31

You should setup the RequiredFields option of DbxSda to retrieve such meta information.
You can do this in the AfterConnect event of TSQLConnection:

Code: Select all

procedure TForm1.SQLConnection1AfterConnect(Sender: TObject);
const
  coRequiredFields = TSQLConnectionOption(307);
begin
  SQLConnection1.SQLConnection.SetOption(coRequiredFields, Integer(PChar('Required')));
end;
For more information see Readme.html located in the DbxSda installation directory.

Post Reply