VBS with DB Application

[cwsstins]

I'm using VBS in conjunction with an application called HEAT. HEAT is a database-driven application with (in my case) Oracle 8i as the backend db.

The application has the capability to run programs, such as VB scripts. What I would like to do is have my script check a table.field to see its value. Depending on the value, the script would then allow for various actions to take place.

For instance, the user clicks a command button. The command button runs the script. The script checks to see:
[li]if table.field = N -- the script will invoke a new email message in the user's email client (Lotus Notes)[/li]
[li]if table.field = Y -- the script will present a Yes/No message box...depending on the selection made in the message box, another activity will take place:[/li]
[li] - if Yes, the message box will close and a new email message will be invoked[/li]
[li] - if No, the message box will close with no further action[/li]

The problem is...I'm just getting started in learning how to create VB scripts and I have no idea where to start with getting VB to look at a db field.

Thanks in advance for guidance...

stinsman

 

[Ouch]

First thing you will need to do is create a connection to the database,

see

http://www.4guysfromrolla.com/webtech/faq/Databases/faq4.shtml

this will run you throu the basics of connecting and retrieving your field data.

 

[cwsstins]

Ouch,

Thanks for the tip...would this apply even if I'm not using ASP? I'm basically trying to get the application to run the .vbs files and have the .vbs files do all the conditional statement work...is this feasible?

stinsman