how to change field order in *.mdb
-
I created a database using CDaoDatabase and the fields were originally arranged using m_nOrdinalPosition parameter in CDaoFieldInfo. Now, I want to change a order whenever I want. Is it possible? How about the records? Is it also possible to change the order of records?
-
I created a database using CDaoDatabase and the fields were originally arranged using m_nOrdinalPosition parameter in CDaoFieldInfo. Now, I want to change a order whenever I want. Is it possible? How about the records? Is it also possible to change the order of records?
Wormhole5230 wrote: I created a database using CDaoDatabase and the fields were originally arranged using m_nOrdinalPosition parameter in CDaoFieldInfo. Now, I want to change a order whenever I want. Is it possible? Not that I know of. Wormhole5230 wrote: Is it also possible to change the order of records? Again, not that I know of. Most of the time, you'd specify a sort order in your SQL query to access the recordset in a specific order. Ask in the SQL/ADO/ADO.NET forum. They will probably be able to give you a more definite answer. Ryan Being little and getting pushed around by big guys all my life I guess I compensate by pushing electrons and holes around. What a bully I am, but I do enjoy making subatomic particles hop at my bidding - Roger Wright (2nd April 2003, The Lounge)
Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late - John Nichol "Point Of Impact"