Search found 31 matches

by stitch22
Mon Apr 12, 2021 12:02 pm
Forum: Technical / Scripting
Topic: database insert
Replies: 4
Views: 2655

Re: database insert

Hello, That is a great site. I was going to refer there myself. I see alot of sesmicolon's in the those groups of statements. I'm guessing they all worked except the last ones with out it. I just expierenced it with my last SQL insert. Took me a while to figure it out. SQL=Insert into table_name sel...
by stitch22
Sun Apr 11, 2021 5:20 am
Forum: Technical / Scripting
Topic: database insert
Replies: 4
Views: 2655

Re: database insert

First look, missing end of line ";" on your SQL insert satement. Also the "ANSI" or "UNICODE" in the driver statement.
Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;
by stitch22
Wed Oct 30, 2013 3:45 pm
Forum: Technical / Scripting
Topic: Mac Parallels
Replies: 2
Views: 2990

It's working! Nothing to do with parallels. Antivirus software messing with the install.
by stitch22
Mon Oct 28, 2013 6:36 pm
Forum: Technical / Scripting
Topic: Mac Parallels
Replies: 2
Views: 2990

Mac Parallels

I have a client running Mac Parallels with win 7 trying to run compiled script. The script runs fine on windows pc. But this is the first time on parallels and I don't have a way to duplicate the issue. Just wanted to check here and see if anyone has had issues or experience previously with Parallel...
by stitch22
Tue Jan 29, 2013 3:11 am
Forum: General Discussion
Topic: Compiled script runs slower than script.
Replies: 3
Views: 9313

Hi JRL, I had forgoten about the timer function, thanks for the reminder. After a few hours testing I found that the problem does not occur when data is generated with in the script. when I create array of data points using MS array functions it works quite well. The results are similar to what you ...
by stitch22
Sun Jan 27, 2013 7:03 pm
Forum: General Discussion
Topic: Compiled script runs slower than script.
Replies: 3
Views: 9313

Resolved the problem. Although I don't know why this effects the the exe file. When compiling the script I have to leave logging enabled. If I disable logging it slows the the exe. I tested on on previuosly working exe files and the problem occurs when logging is disabled. Does this make sense? not ...
by stitch22
Fri Jan 25, 2013 5:38 pm
Forum: General Discussion
Topic: Compiled script runs slower than script.
Replies: 3
Views: 9313

Compiled script runs slower than script.

I have a situation where the script prior to compile runs faster "10x" than the compiled version. Never ran into this before.
Makes it kind of difficult to debug. The routine is dawing an image in the dialog box.

Anyone ever experience this?
by stitch22
Tue Jan 08, 2013 5:56 pm
Forum: Technical / Scripting
Topic: Multiple File selection with listbox Add Remove Up and Down
Replies: 7
Views: 7142

Here is cleaned up version using a similar technique of Parsing the path. Except the VBscript is using a more versitile Disconnected Recordset. Which I found and built based on this article. http://technet.microsoft.com/en-us/magazine/2008.09.heyscriptingguy.aspx?pr=PuzzleAnswer Warning! Xp can be v...
by stitch22
Tue Jan 08, 2013 7:11 am
Forum: Technical / Scripting
Topic: Multiple File selection with listbox Add Remove Up and Down
Replies: 7
Views: 7142

Yes, and thanks. I took your idea and put this together. // allows end user to select files from multiple directories // and also multiple file selection with in a directory // and re-order the list to suit their process VBSTART dim recursion Set FSO = CreateObject("Scripting.FileSystemObject") Sub ...
by stitch22
Fri Jan 04, 2013 10:14 pm
Forum: The Water Cooler
Topic: selling compiled scripts
Replies: 9
Views: 13272

Thanks for your input. Any place I can find license agreement templates? I kind of like Java's. Whats the deal with Win8 and v12 MS? What about digital signatures and installation issues? any sugestions would be helpfull. I don't know what direction I may go in yet. Try to package something up and a...
by stitch22
Fri Jan 04, 2013 9:57 pm
Forum: Technical / Scripting
Topic: Multiple File selection with listbox Add Remove Up and Down
Replies: 7
Views: 7142

Any Idea on on a better way to display the list?
I have been busy on other projects and have not tried the mutilple columns yet.
by stitch22
Fri Jan 04, 2013 9:54 pm
Forum: Technical / Scripting
Topic: Multiple File selection with listbox Add Remove Up and Down
Replies: 7
Views: 7142

OK i see, the security is on those folders most users should not be in anyway.
The ones I realy want are fine.
Thanks.
by stitch22
Sun Dec 30, 2012 5:02 pm
Forum: The Water Cooler
Topic: selling compiled scripts
Replies: 9
Views: 13272

selling compiled scripts

Anybody here selling any of their compiled scripts?
I have no idea how to go about it or whats exactly required.

Anyone willing to share their experience, opinoins, comments or just point me in the right direction.
by stitch22
Sun Dec 30, 2012 4:01 pm
Forum: Technical / Scripting
Topic: Multiple File selection with listbox Add Remove Up and Down
Replies: 7
Views: 7142

Multiple File selection with listbox Add Remove Up and Down

As I was getting ready to post this I solved my own problem. Which was setting the SelectedIndex when MultiSelect is True. I need this for the UP DOWN buttons to function. The work around was to toggle MultiSelect settings in the updown subroutines. That did the trick, so obviuos I just couldn't see...
by stitch22
Sun Dec 09, 2012 12:53 am
Forum: Technical / Scripting
Topic: Drawline rotate output x degrees
Replies: 18
Views: 13480

Hi JRL, After many more hours research and testing, a few aspirin and a beer. I came up with this version. I can now rotate the drawing to any angle. //Set IGNORESPACES to 1 to force script interpreter to ignore spaces. //If using IGNORESPACES quote strings in {" ... "} //Let>IGNORESPACES=1 Let>scal...
Sign up to our newsletter for free automation tips, tricks & discounts