there's probably a more efficient way, but what i would do is instantiate a shell object on the web server, via ASP, and execute the sql syntax entered by the user, using isql or osql.
i've done this to dynamically create databases, via ASP, for managers who wanted a web interface to manage the whole database and application's permissions. -----Original Message----- From: Michael Gerholdt [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 3:22 PM To: ActiveServerPages Subject: self-building database apps? I've been asked to develop a program that other database programmers - non web folk - can just 'drop an sql statement into' and perhaps provide a parameter so it knows whether to run another sql after some user input. (the notion is that the parameter would provide the name of a text file from which the other sql statement could be read . . . ). I have to redesign the concept a bit because it doesn't really take enough of the details into consideration. But before I go too far I wonder if other efforts have gone in such a direction. I remember reading about BuildApp but don't know how it works ... any suggestions for me to consider? Regards, Michael Gerholdt SUNY College at Fredonia --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
