Hello,
I have the other way which is to add or delete a field by it's name but can someone show me an example
on how to add or delete a field from a table by it's index ?
Hello,
I have the other way which is to add or delete a field by it's name but can someone show me an example
on how to add or delete a field from a table by it's index ?
you normally dont delete fields.
you delete the value from the field.
don't think you can, the alter table sql uses field name, not an indexon how to add or delete a field from a table by it's index ?
John,
Help readers help you. Give us some info on what you want to accomplish and why(business rationale).
Rarely would you have a "normal process" to alter a table design programmatically in an operational system. When designing and/or developing you may have fields in tables that you determine are not required, and remove them before moving the application to production status. Even then you would normally go to design view of table and remove field. The need for programmatic manipulation of a table design in an operational system raises a red flag.
Hi Orange,
Thanks for the informative information. Yes it does raise a red flag however in my situation there is a need to do this because the fields are change by the user as the business reporting wants to see that particular fields on different occasions and a static database when doesn’t have that field can’t satisfy the user that wants to see it. I’m giving power to the user that wants to see what they want to see. I just use the name instead of index because I don’t think we can do it by index.
I would suggest you get the user to layout the types of business reporting that are required.
Then create a series of reports that could be executed via selection from a form and combo i dentifying those reports.
You might get some ideas from Martin Green's Dynamic Reports.
That’s a very good idea.
I will do that also. Sometimes just unpredictable what report and field is needed. But I like your way and will do that too. I like to use access as a repository and storage but if I am not wrong, I think the maximum is 20 GB of data it can hold.
No, 2Gb. If you use sql server express it is 10Gb, sql server much moreI think the maximum is 20 GB
I like different ideas and ways. That’s a very nice article from Martin Green on dynamic reports. I will look at it.
Ajax thanks for enlighten me. 👍