ivan

$original = "130102.123456" $diff = "0.000001" $expected_result = "130102.123455" consolewrite((($original - $diff) == $expected_result) & @CRLF) consolewrite(($original - $diff) & @CRLF) consolewrite($expected_result & @CRLF) Try ==.

For tutorials, check this out: http://www.tutorialspoint.com/sqlite/index.htm If you are planning on having multiple users accessing the database simultaneously (concurrency), I'd advise you to use MYSQL, although it's quite feasible to have multiple processes performing searches on a SQLITE db at the same time, but not inserts (http://sqlite.org/faq.html#q5). It's a very bad idea to have the file being shared as proposed in question 2 above. To work effectively in SQLITE with concurrency you'd need to have a thorough understanding of how transactions (commits and rollbacks) work http://www.sqlite.org/lockingv3.html. I built a messaging queue for multiple processes sharing the same file in SQLITE. Unfortunately I can't find that old code, so no example from me today. I never used a remote file. I'm sure it's quite possible though, and I am quite interested in seeing how that can turn out. Hope that helps.

Thanks for the advice.

I was wondering if anyone has successfully tried to use 2 (or more) sqlite dbs simultaneously with the sqlite UDF. There are many scenarios where this could be desirable. For instance, suppose you have a memory db that stores and manipulates temporary data that is only required at run time, and you want to store only a subset of that data in a file db, say, when the user presses a save button, or something of the sort. Or maybe you want to verify if the permanent database already contains the data, for example: select * from temp.table1 as t inner join perm.table1 as p on p.pk = t.pk where t.col=match_condition; I can't quite figure out how the handle to temp can be passed to query perm, or the other way around. You can certainly use sqlite udf to attach the dbs using sqlite3.exe and generate a script that runs your query, but I'd rather not walk through that alley if a superior solution already exists Any thoughts anyone? As always, any help or advice will be greatly appreciated. Regards, Ivan.

Thanks for posting this Dale. I've got a couple of scripts that produce the wend error regularly, so I'll go ahead and test it out. I'll post the output should this occur. Regards, Ivan

$nDisable=1 $nEnable =0 WinActivate($hPDF) ControlClick($hPDF, "", "[CLASS:AVL_AVView;INSTANCE:15]") WinActivate($hPDF) BlockInput($nDisable) SendKeepActive($hPDF) Send("^+S") SendKeepActive("") BlockInput($nEnable)

Thanks, I copied the file to a child directory in the script path and that was remedied.

Cool, thanks Carolyn. You're right, _SQLite_Startup downloads the file if necessary by calling __SQLite_Download_SQLite3Dll which looks for http://www.autoitscript.com/autoit3/files/beta/autoit/archive/sqlite/SQLite3.dll or http://www.autoitscript.com/autoit3/files/beta/autoit/archive/sqlite/SQLite3_x64.dll I ran your script and observed no changes, but it did help me figure out what's going on. Windows blocks the dll file in the System32 directory each time I copy the file. Regards, Ivan

Thank you for the tips. I am quite aware of the x86 and x64 files. As for the slowness, it was the result of an embarrassing badly constructed query. Regards, Ivan.

Perhaps this is a fix, I downloaded _SQLite_LibVersion=3.7.13 from the sqlite site and copied the file to the systemdir folder. I did notice sqlite is slow though, but at least it works. http://www.autoitscript.com/autoit3/files/beta/autoit/archive/sqlite/SQLite3.dll doesn't on my machine. Regards, Ivan

After being away from autoit for a while, I've picked up an old project again, but run into trouble when trying to use sqlite.dll On running _SQLite_Startup(), I get @error=1 (Call Prevented by SafeMode). It does not run with _SQLite_SafeMode(False) or _SQLite_SafeMode(True) I thought SQLite3.dll could have been overwritten in @SystemDir by a 3rd party app (thunderbird or other), and I replaced it with the file in http://www.autoitscript.com/autoit3/files/beta/autoit/archive/sqlite/SQLite3.dll in an attempt to fix the issue, but I think I could have made things worse. I did unblock the dll btw. Any thoughts on how I may fix this? I'm running: >"C:\Program Files (x86)\AutoIt3\SciTE\AutoIt3Wrapper\AutoIt3Wrapper.exe" /run /prod /ErrorStdOut /in "F:db.au3" /UserParams +>02:16:43 Starting AutoIt3Wrapper v.2.1.0.8 Environment(Language:0409 Keyboard:00000409 OS:WIN_7/Service Pack 1 CPU:X64 OS:X64) >Running AU3Check (1.54.22.0) from:C:Program Files (x86)AutoIt3 +>02:16:43 AU3Check ended.rc:0 >Running:(3.3.8.1):C:Program Files (x86)AutoIt3autoit3_x64.exe Thanks, in advance for any help you may provide. Regards, Ivan

Hi guys. Does anyone know a script that might help me recover deleted files. I tried but it didn't work. Thanks. Ivan

Sublime.

Thx ProgAndy. I knew SysLinks controls were native, and found them difficult to handle in automation. Your script not only provides a means to create these controls but may also address Autoit's main purpose, automation, which gives it an additional advantage, not to dismiss the merit of any other alternatives. Taking a closer look at MrCreator's script you are quite right, it's a label with a predefined behavior. As for the rich edit alternative, I never wrote a fully fledged UDF simultation of a SysLink, because my script(s) were basically a sub part (the About) of other scripts, and I never got round to making something of general applicability that may be re-utilized. Every other About I created, I just copied entire sections of old scripts and pasted them in new scripts, edited as required ... not very efficient, shame on me, I know. Anyhow, ThumbsUp for this effort. Ivan

Thanks for sharing. MrCreator posted yesterday but I must point that SysLink is a more appropriate name selection for the control than gui hyperlink. In any case, this is much better than how I used to track links on rich edit controls to simulate the SysLink control. Great work to all (Gary, MrCreator and Yashied). The one thing I'm going to miss from simulating SysLinks via Rich edit controls is being able to apply style to text. Regards, IVAN