Sqlite get2dtable no value return

[Stacker]

Hi all i have this problem,
I need to call sometimes the function below   and i need return value outside.

But when i write _Arraydisp($aResult)  inside function show result, when i put outside nothing to show

 

Func _SqliteQuery($req)
    _SqlStart()
    $iRval = _SQLite_GetTable2d (-1, $req, $aResult, $iRows, $iColumns)
    _SQLite_Close()
    _SQLite_Shutdown()
EndFunc

Edited April 18, 2016 by Stacker

[jchd]

You seem to startup and shutdown the engine at every query invokation, which is pretty wasteful. I hope your _SqlStart opens a DB.

Now your code doesn't make sense: $aResult isn't declared, just as $iRows and $iColumns, and nothing is retruned from the function.

Post full runable code and you'll surely get more useful help.

[Stacker]

Hi jchd, code is to long...

I startup and shutdown at query function because i use once in 6-7 hour

i declare the variable with Global $aResult, $iRows, $iColumns, $iRval,$req at the start of my script

[jchd]

27 minutes ago, Stacker said:

I startup and shutdown at query function because i use once in 6-7 hour

That doesn't bring you anything valuable. You should startup and open at program launch, then close and shutdown at program termination.

Now if the resultset is empty that may be because your query is invalid or doesn't select any row. You don't check return code so you don't know. Another possibility is that your code overwrites the result array before you display it. Again, no code = no useful help.

[Skysnake]

Hi @Stacker

I have noticed you have a custom query with the same name as a standard AutoIt query... This is from the Help file:

_SQLite_Query(-1, "SELECT c FROM aTest ORDER BY a;", $hQuery) ; the query

All examples have the structure of (a) starting SQLite, (b) query, (c) process query, (d) SQLite Shutdown.

I am guessing at conflict between the name of your function and the built-in Autoit function.  Can you run this query separately?  Perhaps the issue is that SQLite3.dll is not present?  See here:

https://www.autoitscript.com/forum/topic/178823-sqlite-in-distros-33142-and-beta-33150/

Edit

I agree with @jchd you are not giving us enough to work with. More code, better examples...

Edited April 18, 2016 by Skysnake

[jchd]

2 minutes ago, Skysnake said:

I am guessing at conflict between the name of your function and the built-in Autoit function.

Are you sure? _SqliteQuery != _SQLite_Query and if two functions would have the same name, the script wouldn't run nor compile.

[Skysnake]

I bow before your superior reading skills.

 

[jchd]

Don't rely on it!

[Skysnake]

@jchd, while we are here, how would one enumerate current SQLite connections?  Found this comment from 2011:

Quote

as of 2007, there is  no sqlite public api for querying  the number of open connections to a sqlite database

Do you have some advise, please? 

[Stacker]

SOLVED - Sorry, today i need more coffe

I reWrite code now variable $req"SELECT ...." is not argument of function. 

I call without arg.

_SqliteQuery()

_arraydisp working outside.

Coffe work!!

[Skysnake]

LOL

Glad we could help

 

[Stacker]

Thank you