Error: Subscript used with non-Array variable in Win7-64bit

[bobhickman]

Script below accesses Mysql and puts the info in $aRow. This script works flawlessly in Windows XP, but not in Windows 7-64bit. When I test with _ArrayDisplay($aRow) -(in XP), the array displays properly. I tried using 64bit AutoIt, but that did not work. Same result whether compiled or not. I have searched but I can't find a solution. Using autoit 3.3.8.1. Same results with 3.3.6. Any ideas?

Dim $array1[5],$aRow[50]

.

.

$aRow = _EzMySql_FetchData() ;loads a query into an array

$read_sec_octet = $aRow[0]

[BrewManNH]

Which DLL are you using and are you running it/compiling it to the same OS Architecture as the DLL? There's 2 dll's one 32 bit the other 64 bit, trying to run a 32 bit dll when running the script under 64 bit AutoIt will probably not work.

[bobhickman]

Thanks, I'll look at that.

[bobhickman]

I have used it both ways, the 32 bit version and the 64 bit version. It behaves the same. Any ideas?

[water]

When I test with _ArrayDisplay($aRow) -(in XP), the array displays properly. I tried using 64bit AutoIt, but that did not work.

What does "did not work" mean? Does _ArrayDisplay show an array? With no data? Or does _ArrayDisplay show no array at all?

[bobhickman]

Please look at original post.

[water]

The quote "did not work" is from the original post.

If _ArrayDisplay doesn't display anything most of the time the variable is no array.

[bobhickman]

_ArrayDisplay does display the info that was retrieved from MySql. As I stated, it works correctly in Win XP, but not in Win 7.

[water]

It does not work in Windows 7. Fine.

But once again: What does "does not work" mean? When you call _ArrayDisplay($aRow) do you get an output on the screen?

[bobhickman]

Please see the original post: "Error: Subscript used with non-Array variable."

[BrewManNH]

You should do the following:

• Post the code you're using
• Post the error message you get when running that script from SciTE
• Give details as to which dll you're using and which version of AutoIt you're using to run the script (x86 vs x64)
• Any other pertinent details explaining what isn't working, why it isn't working, what you're expecting versus what you're getting back.

[water]

Ahh, now I see! The problem description is in the title!

I just tried

#include <array.au3>
Global $a = ""
_ArrayDisplay($a)
ConsoleWrite(@error & @CRLF)

and I get @error = 1 which means: 1 - $avArray is not an array

But the script does not crash.

AutoIt 3.3.8.1

I assume _EzMySql_FetchData() doesn't return any data. What's the value of @error after _EzMySql_FetchData()?

[bobhickman]

Solved the problem. Long story short, _EzMySql_FetchData() was returning null info due to the query criteria. It caused $aRow to be dissolved and Autoit gave the correct error info since $aRow no longer existed. I have put an error check with _EzMySql_FetchData() to take care of the problem. Thanks for your help.