2008/10/1 Vivien Malerba <[EMAIL PROTECTED]> > > > 2008/10/1 Daniel Espinosa <[EMAIL PROTECTED]> > >> In V4 you have GdaMetaStore to get columns and others db objects >> information. In order to get that information you have to do: >> >> - Get a GdaMetaStore from a GdaConnnection using >> gda_connection_get_meta_store >> - Update meta information gda_connection_update_meta_store >> - Get columns information using gda_meta_store_extract and use >> GdaDataModel API to access to the required information >> >> The required SQL to do it could be: >> >> SELECT * FROM _columns WHERE table_schema = ##schema::string AND >> table_catalog = ##catalog::string AND table_name = ##table::string >> >> For gda_column_get_scale you can use numeric_scale column; sorry but don't >> know about defined_size. >> > > You can use the numeric_precision or numeric_scale columns, with both these > columns you should have all the characteristics of a column. > Now, this was to get meta data information. I agree that I've been a bit > too quick in simplifying the GdaColumn API and I should bring back the API > which handles numeric presicion and scale, but probably not as it was. Let > me think about it. >
In Rev #3221, I've added functions to set any attribute (as (name, value) pairs) to GdaColumn, GdaHolder and the GdaMetaTableColumn, which means those 3 types of objects (well the last one is not an object) can pass onto the other attributes. For example when creating a GdaDataModelIter, the attributes for each GdaHolder are set from those of the corresponding GdaColumn of the data model the iter is for. Cheers, Vivien
_______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
