Sent: Tuesday, April 30, 2002 1:19
AM
Subject: Witango-Talk: Added and changing
SQL tables & building forms
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
