Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Question
Message
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Miscellaneous
Thread ID:
00615064
Message ID:
00615233
Views:
19
This message has been marked as the solution to the initial question of the thread.
>The MSDN help for the ADOX Column's Append method shows:
>
>Columns.Append Column [, Type] [, DefinedSize]
>

>
>How do I specified decimal positions?

Have you tried creating a column object ?

Something like:
Dim col As ADOX.Column

Set cat = New ADOX.Catalog
cat.ActiveConnection = CurrentProject.Connection
Set col = cat.Tables("Table1").Columns("fldDecimal")
col.NumericScale = 8
col.Precision = 4
cat.Tables("Table1").Columns.Append col
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform