Leaderboard

You could have tested that quite easily by now Jos

https://www.autoitscript.com/forum/topic/178680-customowner-drawn-multi-line-header-in-listview/ Saludos

$x = _Base64_Encode("jilles" & chr(0) & "jilles" & Chr(0) & "sesame") $x = StringReplace($x,@crlf,"") ConsoleWrite($x & ":" & stringLen($x) & @CRLF) ; It should be "amlsbGVzAGppbGxlcwBzZXNhbWU=" if $x == 'amlsbGVzAGppbGxlcwBzZXNhbWU=' then ConsoleWrite("Yes!!!!" & @CRLF) Else ConsoleWrite("No!!!!" & @CRLF) EndIf

NULL in AutoIt like a null ptr not null character. YOu should do this _Base64_Encode("jilles" & chr(0) & "jilles" & chr(0) & "sesame") Saludos

As Bowmore showed this can be achieved thru a simple join, yet I'd recommend you normalize your schema by using foreign keys. The query would be essentially the same but linking fields would now be made by row IDs, almost always 64-bit integers.

Actually, every variable that functions use as parameter should be passed as argument, no matter if it's global or not. Only global constants are free of that.

You did not mention which database you are using, but the following should give you the required result on most databases that follow the latest ANSI SQL standard. SELECT a.field1, c.field3 FROM a JOIN x ON (a.field1 = x.afield1) JOIN b ON (x.bfield1 = b.field1) JOIN y ON (b.field1 = y.bfield1) JOIN c ON (y.cfield1 = c.field1) WHERE c.field3 = 'stringvalue'

According to the help file keyword Null always evaluates to Null or an empty string: "Null evaluates only to Null, still in mathematical operations this keyword has value of 0, and as string it has no value (empty string)." So - as always - the help file is your friend

... multiplied by 10^301 but don't expect unit granularity over the whole range!

Believe the TimerDiff() returns a double type so 1.79769e+308 give or take a few. Jos

I am forking this UDF, I hope you don't mind .

My understanding is that it is to do with pipes, bottlenecks and timing, Which to me, means you can have simultaneous processes occurring (cores), but then they share output and input pathways, and that is where timing comes into it. First come first served is where I imagine the racing occurs. I am however far from being an expert, and so could be completely wrong in what my mind has pieced together, from things I have read and what seems logical. It has also been some time between readings ... usually only when considering my next PC. I have forgotten for instance, where the Southbridge fits into all that ... just remember it improves things in that regard ... alternate pathways or something. My advice, is don't get old ... you forget or misremember things ..... oops too late.

Hi Water, Just wanted to give LONG overdue kudos and thanks for your AD UDF. This is one of my three top used UDFs at the office, and has GREATLY simplified data gathering for some very complex reports, as well as automating several tasks. I have even been able to free up one admin completely from our annual security audit process (for which he is also very grateful) thanks to the use of your UDF. Thank you.