SQL to VB object

Hello,

I have a schema SQL (DDL).  It will likely change a lot (i.e. entities and relationships will be added and removed).  I am going to use the schema for a file structure definition and I would like to have a VB object/s created for interfacing the file.  Do you know of any quick ways to generate VB objects from a SQL definition?

E.g. SQL input:

CREATE TABLE A
 (ID NUMBER
 ,DATA VARCHAR2(4000)
 )

VB object output (A.cls file):

Private ID As Integer 'local copy
Private DATA As String 'local copy
Public Property Let time(ByVal _ID As integer)
    ID = _ID
End Property

Public Property Get ID() As Integer
    ID = ID
End Property

...
rmundkowskyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

leonstrykerCommented:
If you are using SQL Server you can do this with DTS.  What is your database?

Leon
0
rmundkowskyAuthor Commented:
Actually, there is no database.  The data design was just done in a ER modeling tool.
0
leonstrykerCommented:
The only way soemthing like this is possible is by launching another tool/process or something else, which is database specific.  So for example you may be able to execute xp_command_shell (or a similar system store proc) in Sybase or MS SQL Server, or you can utilize Perl/Java/VBScript ot whatever the database may support.  However, there is no direct way to "generate VB objects from a SQL".

Leon
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

rmundkowskyAuthor Commented:
Maybe I need to rephrase the question:

I want to create VB classes (source code), not objects (instants of classes) from SQL.
0
leonstrykerCommented:
Give me an example of what it would look like if it waqs possible?  I am having a hard time visualizing this.

Leon
0
rmundkowskyAuthor Commented:
SQL INPUT:

         CREATE TABLE A (ID NUMBER ,DATA VARCHAR2(4000) )

VB CLASS OUTPUT:

         Private ID As Integer 'local copy
         Private DATA As String 'local copy

         Public Property Let time(ByVal _ID As integer)
             ID = _ID
         End Property

         Public Property Get ID() As Integer
             ID = ID
         End Property

         ....
0
leonstrykerCommented:
Well, I guess you can create SQL code which will generate VB code and retrieve the result into a text file, but it will not be simple.

It seems to me that it would be easier to start in VB and have your code create a table in SQL Server and then create your class.

Leon
0
rmundkowskyAuthor Commented:
Yeah,

I think my current approach (below) is better.  

Have a Perl script to convert SQL to VB code.

Just thought someone might know of a tool that already does this.
0
leonstrykerCommented:
Well, you are using the same method as i suggested above, just that you are starting from Perl instead of VB.  I am pretty sure that no such tool exists.

Leon
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.