G'day James, Very impressed with the level of documentation on the linked site. Unfortunately the link to the form builder on the last page seems to be broken.
At 19:19 29/04/02 -0400, you wrote: >Hi Dan, > >Yup, I've written one. It dynamically generates ALTER TABLE and CREATE >TABLE SQL statements. The issues come when someone takes an existing table >and tries to change the data-type of a field, SQL can't handle every >situation by itself, which leads to bothersome error-handling. > >Because of this I've limited the data types to: varchar, bit, int, date >money and floating point, which handles 95% of what you'll use on a web >site anyway. You can build new tables, add and remove fields as well as >change data types. It's got a few SQL syntax bugs that would probably only >take me an hour or two to sort out. Right now I don't have the time to do >it. If you want to take the time to tweak it let me know and I'll send you >the TAF, otherwise wait a few weeks and I'll post it. > >It's part of a bigger application I made called Formbuild, which is >basically a back-end in a can. You can define forms, map them to database >tables and select which fields appear on the form, in what order and what >form element type they are shown as (text, textarea, radio, select etc), >along with complete javascript validation options for each field. It also >builds a drop-down or text-search record selection form. It even handles >building a left-frame menu. You can build an entire back end without >touching any code in about 15 minutes. > >I basically got sick of coding database look-ups that populate forms and >save data back again, so I built a class file that handles everything >based on a form definition in a database. The docs are online if you're >interested: > ><http://209.47.192.71/staffpages/jameslab/formbuilddocs/index.htm>http://209.47.192.71/staffpages/jameslab/formbuilddocs/index.htm > >- James > > > > > >-----Original Message----- >From: [EMAIL PROTECTED] >[<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED]] >On Behalf Of Dan Stein >Sent: Monday, April 29, 2002 6:26 PM >To: Multiple recipients of list witango-talk >Subject: Witango-Talk: Added and changing SQL tables > > >Seems to me there should be away for me to use a Tango app to added or >modify SQL tables. I'm using SQL 2000. Anyone have one written? > >Dan > > >-- >Dan Stein >Digital Software Solutions >799 Evergreen Circle >Telford PA 18969 >215-799-0192 >610-256-2843 >Fax 413-410-9682 >FMP,Tango, EDI,SQL 7 >[EMAIL PROTECTED] >www.dss-db.com > > >________________________________________________________________________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body Warmest regards, Tom Grimshaw coy: Just For You Software tel: 612 9552 3311 fax: 612 9566 2164 mobile: 0414 675 903 post: PO Box 470 Glebe NSW 2037 Australia street: 3/66 Wentworth Park Rd Glebe NSW 2037 email: [EMAIL PROTECTED] web: www.just4usoftware.com.au the most needed product in the world can be found at www.thewaytohappiness.org This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses. ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
