I have built a simple CF app - add, edit, delete, etc. But rather than hard code the fields, Ive dumped them into a text file with the following format.
Bool : visible on the list of records, String: name in data entry screens String: field name in SQL String: field type in SQL Number: field size in SQL An example of the file is: 1, Client Name, Client_Name, char, 20 1, Application Name, App_Name, char, 20 1, CF Version, CF_Version, char, 10 0, Server Path, Server_Path, char, 255 0, Website URL, Website_URL, char, 255 What I was wondering was: How do I retrieve the types and sizes. As well as this, I would also be interested in discovering whether or not the field would accept a null value. I remember reading something about querying the Master database in SQL Server, but more than that, I can't remember. My reasoning is that if I can get this to work (with an exclude list for any fields that I want to manually update), then I will have a system that I can tweak, 'skin' with a design and use almost anywhere... coz Im lazy :-) Martin L. Gill, MSc - Programmer For & on Behalf of UniTech (The Universal Information Technology Group Ltd) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ URL: http://www.unitech.net Email: [EMAIL PROTECTED] UniTech House, 25 Bernard Street, Leith, Edinburgh, EH6 6SH Tel: +(44) 0131 472 5555 DDI: +(44) 0131 472 5560 Fax: +(44) 0131 472 5556
