We help IT Professionals succeed at work.

To automate (maybe batch) execution of some VB Procedure

AnnaBZ
AnnaBZ asked
on
320 Views
Last Modified: 2010-05-03
I written an VB application that manipulates some data of Oracle
database. One of operations : we press some button, get a resultset
and display it in the grid, then user selects some row,
when right click on row we see a popup menu then press on one
of the buttons of the menu and something is executed for that row .
All this operations executed when proper buttons are pressed
I need to automate this process and not to involve user by pressing buttons
(scenario is : check if new row arrived ,if arrived execute some code for it )
There was an idea to work with batch files ,but how can I run some procedure
which was written in VB in a batch file ,and in the same time run the application
Just have no idea.
Can somebody suggest how this things of automation usually done?  
Comment
Watch Question

[ fanpages ]Consultant (Development Team Lead, Senior Support Engineer, and Technical Test Leader)
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
My access to database is quite restricted because of security ,I cannot enter rows straight to DB I do it through MSMQ so I'm not sure about triggers .I do some SQL (using few tables) in VB and its results are displayed in the grid . Can I do triggers in VB code, and when more then one table is involved in SQL ?
Yes, the rows are added and status of row that we work on is changed , but it still in DB.
And I can amend code of procedures, but processing must be done from VB.
My knowledge is: Oracle pl/sql on quite a good level , Orace DBA1, MSCE of Windows2000(about PC environment) , VB code experience of one year but even if I don't know something in VB usually I can handle it after a lttle studing

Thank you

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
[ fanpages ]Consultant (Development Team Lead, Senior Support Engineer, and Technical Test Leader)
CERTIFIED EXPERT

Commented:
...indeed... flagging each record by setting a column on each to indicate if processed is another way to go.

Or... create a dedicated table (a "trigger" table) in the database that holds the keys of the newly created records in the main table.  The VB application 'monitors' the "trigger" table constantly, pausing after every poll for 10/20/60 seconds (or whatever).

If one, or more record(s) exist(s) in this new "trigger" table , then as each is read, they are deleted, and the appropriate record in the main table is processed.  When all the records in the "trigger" table have been read/deleted, the VB application waits, and then polls again.

The Oracle process should write the main table entries as normal but also a new record to the "trigger" table containing the unique Ids of each record.

BFN,

fp.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.