Making DBX recognize booleans with Firebird

Question

The Firebird FAQ explains how to create a BOOLEAN domain. Probably the most interesting part is at the end, where it says:

If you use a connectivity library like OleDB under .Net, you can override the OleDB provider's GetSchema method, so the DataTables you get from queries have native .Net booleans.

Is there any way to do that with DB Express? I'm using the DBX driver from http://sites.google.com/site/dbxfirebird/, and it would sure be nice to be able to get back TBooleanField instances in my datasets instead of TSmallintField.

Answer 1

It is handled by these two methods that each TDataSet descendant can override:

function TDataSet.GetFieldClass(FieldType: TFieldType): TFieldClass;
begin
  Result := DefaultFieldClasses[FieldType];
end;

function TDataSet.GetFieldClass(FieldDef: TFieldDef): TFieldClass;
begin
  Result := GetFieldClass(FieldDef.DataType);
end;

--jeroen