Search found 438 matches

by adroege
Wed Aug 10, 2011 2:49 pm
Forum: Technical / Scripting
Topic: Help with If/else regarding text in a box.
Replies: 4
Views: 5389

see if there is any text in the active text box on the database
I think you will have better results if you do a SQL query
on your database instead of trying to get the data from a
GUI.

Look up the Macro Scheduler commands

DBConnect
DBClose
DBExec
DBQuery
by adroege
Mon Aug 08, 2011 8:47 pm
Forum: Technical / Scripting
Topic: DBQuery - Acquire Variable Name
Replies: 10
Views: 11128

Here is a more simple solution for you which doesn't involve reading and parsing files. The VBScript does it all. Probably could change the field separator to a pipe or something and then let Macro Scheduler create an array from the result (if needed.) VBSTART Function DBAccess (connection_string,sq...
by adroege
Wed Aug 03, 2011 8:17 pm
Forum: Technical / Scripting
Topic: Problem with VBScript Timeout
Replies: 5
Views: 13118

Let>VBS_TIMEOUT=70000 VBSTART Function taketime starttime = Now() for x = 1 to 200000000 y=1 next taketime=datediff("s",starttime,Now()) end function VBEND VBEval>taketime,result MDL>%result% seconds have elapsed Interesting.... I see different behavior when I run it from within the editor vs compi...
by adroege
Tue Aug 02, 2011 2:48 pm
Forum: Technical / Scripting
Topic: DBQuery - Acquire Variable Name
Replies: 10
Views: 11128

When I run the following code //Connect to Datasource Let>str=DSN=PostgreSQL30;Server=192.168.3.253;Port=5432;Database=DemoDataAD;User=MH;Password=mh;Option=3; DBConnect>str,dbH //Perform SELECT query Let>SQL=select * from entities limit 5 DBQuery>dbh,SQL,entities,numrecs,numfields,1 //Close databas...
by adroege
Thu Jul 28, 2011 1:55 pm
Forum: Technical / Scripting
Topic: read file and paste ?
Replies: 2
Views: 5423

I didn't do ALL your homework for you..... but this sample should show you how to do it. The sample opens a text file with just one line, and pastes that line into Google then does a search on that. You can build upon this sample to open multiple web pages and paste multiple lines of text. Waiting 5...
by adroege
Thu Jul 28, 2011 1:38 pm
Forum: Technical / Scripting
Topic: My script stop when i logout vps ?
Replies: 7
Views: 11058

This FAQ entry should help you. This is a microsoft issue.

http://www.mjtnet.com/msfaq171.htm
by adroege
Wed Jul 27, 2011 9:08 pm
Forum: Technical / Scripting
Topic: Help with WaitRectChanged
Replies: 3
Views: 3782

Are you referring to the mouse coordinate box with the drop down on it? with Relative, follow cursor, Pixel Color Yes. Make sure Relative is unchecked because WaitRectChanged uses absolute coordinates. From the Help File ...... WaitRectChanged>TLX,TLY,BRX,BRY,Timeout This command causes Macro Sched...
by adroege
Mon Jul 18, 2011 7:22 pm
Forum: Technical / Scripting
Topic: Help with WaitRectChanged
Replies: 3
Views: 3782

Well, one way (there are several) is to use the
real-time pixel coordinate tool on the tool bar
of the macro editor. It's over on the right and
can be set to readout in relative or absolute X/Y
numbers.
by adroege
Fri Jul 15, 2011 7:16 pm
Forum: Technical / Scripting
Topic: Filling in a PDF form
Replies: 4
Views: 4960

This link will tell you how to fill a PDF form programatically

http://forums.adobe.com/thread/741050
by adroege
Thu Jul 14, 2011 7:50 pm
Forum: Technical / Scripting
Topic: Base64 to populate Combo
Replies: 13
Views: 11810

Usually there is no need to read and count lines before reading a file.

This example reads each line from the text file and displays it in a Message window.

Code: Select all

  Let>k=1
Label>start
  ReadLn>c:\temp\test.txt,k,line
  If>line=##EOF##,finish
  Message>line
  Let>k=k+1
  Goto>start
Label>finish
by adroege
Mon Jul 11, 2011 2:41 pm
Forum: Technical / Scripting
Topic: Base64 to populate Combo
Replies: 13
Views: 11810

I think you have been Okay in the past since you were not reading/writing line-by-line.
by adroege
Mon Jul 11, 2011 2:09 pm
Forum: Technical / Scripting
Topic: Base64 to populate Combo
Replies: 13
Views: 11810

To JRL: Because crypt by itself could generate ANY ASCII values, it can also generate the ASCII values for CR LF OR even EOF. To read back the values line-by-line requires us to be able to trust that the CRLF at the end of each record is not part of the data. Therefore we need to use BASE64 (or some...
by adroege
Mon Jul 11, 2011 2:05 pm
Forum: Technical / Scripting
Topic: Base64 to populate Combo
Replies: 13
Views: 11810

Try this. //to write to the txt IfFileExists>c:\cards.txt DeleteFile>c:\cards.txt Endif Let>Line=hello world Crypt>abc,line,cryptval Base64>cryptval,ENCODE,newline WriteLn>c:\cards.txt,nWLNRes,newline //to decrypt ReadFile>c:\cards.txt,cardslist Trim>cardslist,cardslist Base64>cardslist,DECODE,cards...
by adroege
Mon Jul 11, 2011 12:41 pm
Forum: Technical / Scripting
Topic: Base64 to populate Combo
Replies: 13
Views: 11810

please post your code.
by adroege
Fri Jul 08, 2011 2:57 pm
Forum: Beginners
Topic: Execute a VB6 code !
Replies: 1
Views: 3888

Compile the VB6 code to an exe and then use Run>


Or (if possible) convert the code to VBScript which is very
similar syntactically
Sign up to our newsletter for free automation tips, tricks & discounts