TableDef and Fielddef propertys 2

[jbrowne]

Hello everyone!
I want to know is there any tabledef property or fielddef property that can pick up the decimal position of a numeric field in a database? if there isn't is there any other way of interigating the database through vb to get this property? Also the same goes for uppercase in regards to a character field!?
Thanks

 

[CCLINT]

You can get the fixed decimal place of a fieldusing FieldDef.
You can get the actual no. of decimals places a field in a record using a recordset.

What do you want?

 

[jbrowne]

Its the actual decimal position im looking for so its the fixed decimal place im looking for!

 

[CCLINT]

??
What I mean, is that one can set a fixed number of decimal places a field should have - and this will be reflected by all records.
Or, if not, then for each record the value of the field gets save with the actual no. of decimal places - so one record may show 2 decimal places and the other may show 5 - for the same field.

The second should be clear - set up a recordset, query the table, move to the record in question, reference the field in question, and then using InStr return the position of the decimal and then subtract this from the Len of the field value.

For the first, use a recordset and just query the property in question:
Debug.Print rs.Fields("myField&quot.Properties("decimalplaces&quot

 

[jbrowne]

thats brilliant
thanks a million!!