> > Has anybody used this functionality in sqldb at all? > > No. For a simple reason: > > I implemented all this information in fpdatadict; > I think it belongs more there, and definitely not in the > basic data API. >
Some of the metadata are necessary in the basic data API (tables, columns, indices) and are a partial overlap with the TFPDDEngine descendants. >From an abstraction perspective, I think it is better to have database specifics as much as possible in one location and use standards as much as possible when specifying metadata. To be honest, I just discovered fpdatadict. Probably the missing implementation of a lot of the databases is one of the reasons why I haven't noticed it before. First impression is that the fpdatadict implementation makes sense but unfortunately the properties used are perhaps close to one particular database but are insufficient or confusing for other databases (no reference to schema or catalog, NUMERIC_SCALE, length vs. octet_length, collation,...). Ludo _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal