VB (GUI) to SQL Procedures: Interface "not" populating to latest-month (needs to be run 2nd time).
Posted on 2008-06-11
I have a problem. I need to run an Interface that picks-up data thru to the latest month. Currently - for whatever reason - I need to simply run it twice - for it to populate data thru to the latest-month. The 1st time around, it picks up to the previously run month only and stops. Then, once I set it to run again - like I did the 1st time around - it goes thru all the way and brings in all the data inclusive thru to the current-month at hand.
Can you guys advise on how to fix this problem? and - what could be the cause?
The GUI uses VB which then invokes SQL Procedures that pull data from a Sybase Database. The VB is via Visual Studio 2005.
Thanking you for your time & help, sincerely, Raj.