RE: Scripts using T-SQL or ADO

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Richard J (RichardJ_at_discussions.microsoft.com)
Date: 08/09/04 

Date: Mon, 9 Aug 2004 10:27:03 -0700

DC,

Yeah, I can't imagine why you couldn't create tables using VB 6. I'll leave
the design up to you, but you would simply set the statement as:
sSQL = "CREATE TABLE " & txtTableName.Text & " ( "_
        & <fld1> & " " & <datatype> & " " & <NULL> ...

I don't see why that wouldn't work. However, building a table or database
in this manner seems like it would be counter-productive. You can't build
primary keys or indexes in this manner. So I would suggest approaching with
caution.

As for not knowing the table structure in advance, that's something you
should capture up front during requirements gathering. What information do
the users need access to?! If the users don't know, then a table isn't
needed.

Good luck.
Richard

"DC" wrote:

> Hi all,
> is it possible to script a table (or entire DB) using VB 6 source code.
> I wouldn't like to use SQL-DMO objects.
> I don't know table struture in advance.
>
> TIA,
> DC

Relevant Pages

  • Re: We are, a mass extinction event.
    ... horrors and evils, but we just can't seem to imagine more good than ... is all manner of things bad and horrible. ... way to prevent enslavement of the human race. ...
    (sci.physics)
  • Re: import doubt?
    ... > i am having one text file in following manner. ... > Kalkan, AK ... > Fonash, SJ ... we're going to be breaking database design principles by relying on the ...
    (comp.databases.ms-access)
  • Re: JPEG fading and Sensor size
    ... maybe that's the code given to the applications groups. ... imagine Photoshop without even so much as a help file for ... Then imagine talking about ... These things were actually written in such a manner that you *had* to ...
    (rec.photo.digital)
  • Re: Awesome Auction...
    ... Imagine the fun. ... "Please STOP utilizing the normally accepted ... manner of posting and start leaving quotes ...
    (alt.marketing.online.ebay)
  • Re: Stopping the Palestinian Resistance or the Israeli Aggression!?
    ... TUKA wrote in message ... >>> Yeah, right. ... When you learn to talk in a manner that allows reasonable ...
    (talk.politics.mideast)