Search found 69 matches

by hoangvo81
Wed May 28, 2014 6:59 pm
Forum: Technical / Scripting
Topic: run program passing parametr
Replies: 5
Views: 6385

Re: run program passing parametr

Thanks for the explanation.
by hoangvo81
Wed May 28, 2014 6:53 pm
Forum: Enhancement Suggestions
Topic: Code Explorer
Replies: 0
Views: 7132

Code Explorer

as a tab in the area where the code builder/watch list etc. are located.

this way we can quickly locate variables , srt etc.
or let it float and not close down when we have double click on the line we want to see, cause then we have to re-open it agian.
by hoangvo81
Wed May 28, 2014 5:11 pm
Forum: Technical / Scripting
Topic: run program passing parametr
Replies: 5
Views: 6385

Re: run program passing parametr

ignore this - i found the problem. need to enclose the application path in quotes. runprogram>"%script_Dir%\displayselected.exe" /selected=123 script_dir the folder has spaces so that was causing problem. but i m not sure why it would run when i remove teh /selected=123 parameter since the spaces is...
by hoangvo81
Wed May 28, 2014 5:07 pm
Forum: Technical / Scripting
Topic: run program passing parametr
Replies: 5
Views: 6385

Re: run program passing parametr

yet when i pull the exe back to my desktop and ran it, it's fine.
...
by hoangvo81
Wed May 28, 2014 5:04 pm
Forum: Technical / Scripting
Topic: run program passing parametr
Replies: 5
Views: 6385

Re: run program passing parametr

opening up command prompt manually and typing in the DisplaySelected.exe /selected=123
works fine and display 123

also tried making it into an exe and running it and still the same complain.
by hoangvo81
Wed May 28, 2014 5:00 pm
Forum: Technical / Scripting
Topic: run program passing parametr
Replies: 5
Views: 6385

run program passing parametr

Hi, I think I losing it, cause i was sure i could pass parameter via runprogram to an exe, the exe is a macro scheduler created exe exe code: MDL>Selected Main code: let>RP_ADMIN=1 RunProgram>%script_Dir%\displaySelected.exe /selected=123 macro scheduler is complaining that the file does not have a ...
by hoangvo81
Wed May 21, 2014 10:47 pm
Forum: The Water Cooler
Topic: The Unofficial Macro Scheduler Puzzler #9
Replies: 38
Views: 40681

Re: The Unofficial Macro Scheduler Puzzler #9

beautiful solution hagchr.
I don't think there's a way to get it down to one line code using your solution, but i am sure someone will prove me wrong
by hoangvo81
Wed May 21, 2014 12:22 am
Forum: The Water Cooler
Topic: The Unofficial Macro Scheduler Puzzler #9
Replies: 38
Views: 40681

Re: The Unofficial Macro Scheduler Puzzler #9

Isn't hagchr solution really a one liner if you combine the all the variables into the execute? Let>BinVal=10111010001000010 Let>Calc="Bin=""%BinVal%"":Res=0:For I = len(Bin) to 1 step -1:Dig=mid(Bin,I,1):select case Dig:case ""0"":case ""1"":Res=Res+(2^(len(Bin)-I)):end select:Next:MsgBox(""Binary=...
by hoangvo81
Wed May 07, 2014 10:28 pm
Forum: Technical / Scripting
Topic: Hoping to move on from WinBatch and AutoMate
Replies: 5
Views: 6652

Re: Hoping to move on from WinBatch and AutoMate

[content remove]

general idea - ms is very powerful
by hoangvo81
Wed May 07, 2014 9:42 pm
Forum: Technical / Scripting
Topic: DBExec - Query Time Out
Replies: 4
Views: 5730

Re: DBExec - Query Time Out

Server Remote connection is 600 within sql server by default, which give me 6mins. the time it took for the time out was less than 2mins. I re-ran the code on a different server MS DBExec - timed out, MS VBscript - completed the vb script version within macro scheduler - not a problem dim constr con...
by hoangvo81
Wed May 07, 2014 6:41 pm
Forum: Technical / Scripting
Topic: DBExec - Query Time Out
Replies: 4
Views: 5730

Re: DBExec - Query Time Out

I've try adding Timeout=1200 to the connection string and still getting a query time out expired. when running the same query via SQL Management Studio, it run without a problem. using the same login I used in teh connection string to connect to the sql database. the total time it took for a 4.5 gig...
by hoangvo81
Wed May 07, 2014 1:47 am
Forum: Technical / Scripting
Topic: DBExec - Query Time Out
Replies: 4
Views: 5730

DBExec - Query Time Out

Hi, I am running into a problem and can't seem to find out why its timing out. It doesn't always time out but sometimes it does: Here's the code. Let>DB_COMMANDTIMEOUT=1200 DBConnect>Provider=SQLNCLI.1;Password=%mypassword%;Persist Security Info=True;User ID=%myuser%;Data Source=localhost\sqlexpress...
by hoangvo81
Fri Mar 21, 2014 2:56 pm
Forum: Technical / Scripting
Topic: Random, .. not so random?
Replies: 4
Views: 5228

thanks for clearing that up.
i'll just add the min limit values to the result.
by hoangvo81
Mon Mar 17, 2014 6:37 pm
Forum: Technical / Scripting
Topic: Random, .. not so random?
Replies: 4
Views: 5228

Random, .. not so random?

Hi, can someone also confirm this on their version? I am running ver 14.0.16 codes: let>k=0 repeat>k let>RND_SEED=1000 add>k,1 random>10000,value writeln>c:\temp\random.txt,wr,%value% Until>k=100 result is 3799 every entry. - your's might be different not sure. problem i found is that when i did the...
by hoangvo81
Mon Dec 16, 2013 6:33 pm
Forum: Technical / Scripting
Topic: Folder Names into Listbox in alphabet orders
Replies: 3
Views: 5382

Beautiful, but it will still be a problem as we have to extract the file name from the GetFileList otherwise it will give us the full path. none the less, did not know there was a sorted property for the listbox and will use it in the future when i do need to do so for different set of data. Thanks
Sign up to our newsletter for free automation tips, tricks & discounts