MS Access UDF

[BalooBear]

A bit of help needed as I upgraded AutoIt to 3.3.14.2 and my script based on this UDF started failing with Error Code (94) : ==> The requested action with this object has failed on the line  .QueryDefs

The calls need to replicate the error are;

Local $l_o_DataBase = _AccessOpen($sFullName)

local $l_qdf = $l_o_DataBase.QueryDefs($sStatus)

Rolling back to version AutoIt 3.3.12.0 with no code changes makes everything work fine again?

Which part of the update broke my code and what should I change?  The UDF I'm using is the original version in this post by "aymhenry" (thanks very much!)...

[mLipok]

Can you show content of your SciTE console output pane ?

[BalooBear]

17 hours ago, mLipok said:

Can you show content of your SciTE console output pane ?

As I had to keep working, I re-did the test on a Windows 10 machine and received similar results.  I hope you see the error message with 3.3.14.2 which was is the same as before, just different line number.  "The requested action with object has failed.:"  This error was generated when I am retrieving a value from a access query in the database.

Version 3.3.12.0 worked fine, with no error messages and no code was modified...

Thanks for taking a look mLipok...

 

[mLipok]

Try this:

$oField = $l_rst.Fileds($sHIVEDB_Flower_Info_Param_Flower_Params)
If @error Then MsgBox($MB_ICONERROR, 'TEST', '@error = ' & @error & @CRLF & '@extended = ' & @extended)

$_mFlower($_Flower_Params) = $oField.Value

 

btw.
I encourage you to look at this UDF

 

 

 

Edited April 14, 2016 by mLipok

[kcvinu]

@mLipok I am sorry, i didn't get any free time to participate in this discussion due to my busy work schedule. I am getting notifications about this thread and i really want to test your udf but i am completely away from programming.  But i will test it as soon as i get free time. 

[BalooBear]

21 hours ago, mLipok said:

Try this:

$oField = $l_rst.Fileds($sHIVEDB_Flower_Info_Param_Flower_Params)
If @error Then MsgBox($MB_ICONERROR, 'TEST', '@error = ' & @error & @CRLF & '@extended = ' & @extended)

$_mFlower($_Flower_Params) = $oField.Value

 

btw.
I encourage you to look at this UDF

 

 

 

I tried the modification, but receive the same error message...

 (917) : ==> The requested action with this object has failed.:
$_mFlower[$_Flower_Params] = $oField.Value
$_mFlower[$_Flower_Params] = $oField^ ERROR

I'll take a look at the other UDF... thanks...