Any guide is really appreciated. I really 'blank' on how I can apply image recognition in this issue.

thanks for the help

I need to interface to mainframe application which use java applet. So far I manage: 1. open the applet and login following standard sequence. this just standard keyboard enter. at the end, I will reach the inquiy screen 2. I enter switch id in the enquiry screen and press specified key. the screen ...

actually it is not an error. When vbscript execute select * from svc_acv_history, error is > 0, but it return all the data.

Why vbscript give error . 0????

the following vbscript give me headache to trouble shoot. Pls see code below: the issue is at GetAsasData vbscript, it keep giving error , but the same method in another function works and return 0 VBSTART '--- GLOBAL VARIABLE AREA ----------- Dim pEquestOdbcConn, pEquestData, pQuestSQLString Dim pA...

Sorry , type error. Suposed to be on previous thread

Thanks for the suggestion, yes there is no tiem difference..

Well I will try the sql method then, thanks

I've tried the on error but still dialog box appear ( dialog box title: macro Scheduler '

I am avoiding to check whether data already exist, to avoid programming/ and also to reduce time to load data.


regards

So far I manage to exract from db A and insert data into db B. My issue now is whenever I insert data into db B, I got odnc dialogbox error: cannot insert duplicate key row.... I need to press ok,abort on the dialogbox to preceed to next line I just want to know how to disable/suppress the error dia...

when having problem with vbscript in this task, I treid to use the debugger and step thru the script, but watchlist show no value for vbscript funtion return. so it shows error.
but when i run it outside the debugger, the script run succesfully.

IS this a bug in the debugger or what?

Ok, its working based on Marcus latest suggestion. I managed to find the error. My odbc setting is correct, but the table is not there in the db. table refer to another db.

I guess few hours sleep help clear up my mind.

regards

Ok, reply retrun 0, then I got error at function GetFieldCount with error
object required pEquestData.

Just find out. if I run the code in editor/debugger, script wont work and openequestdata do not return any value, but if I run it directly outside editor/debuger then the debugger run and openequestdata return 2.

very strange..

I've tried your code and also I insert sample from help. but even the sample vbscript do not work. VBSTART Dim Recordset Dim SomeVar Dim eQuestSQLString dim OpenProcessData dim pEquestOdbc dim pEquestData dim aRtnOdbc dim aRtn Function OpenEquestData(csql) OpenEquestData = 0 Set pEquestOdbc = Create...