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
-
James
-----Original Message-----
From:
[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
