_accessQueryLike MSAccess UDF

[BryonR]

The array is comming back as $adfull correct? When I put that in my msg box its saying I havn't declared it.

I'm currently using the UDF to store information I want to take it to the next step and pull that out for display.

I'm sure I'm just using the Syntax a nuge would be great.

  Quote

If you bothered reading the header you would have noticed that it returns an array

CODE;

$test = _accessQueryLike($database, "tbl_call","desc","test")

If IsArray($test) Then

For $i = 1 To Ubound($test) -1

MsgBox(0,"test",$test[$i])

Next

EndIf

;

EDIT: Please post support questions in the support forum, not as a new thread in Example scripts. Now I'll see if I can get some nice Mod to move this one.

Edited May 8, 2009 by BryonR

[PsaltyDS]

  BryonR said:

The array is comming back as $adfull correct? When I put that in my msg box its saying I havn't declared it.

I'm currently using the UDF to store information I want to take it to the next step and pull that out for display.

I'm sure I'm just using the Syntax a nuge would be great.

The variable $adfull is not used in the code posted. What are you talking about?

[BryonR]

[/code]
#include <Access.au3>

$database = "c:\database\support.mdb"
$test = _accessQueryLike($database, "tbl_call","date","test")
MsgBox(0,"test",$adFull)
[code]

Its in the Access.au3 incude file, unless I'm just way off base and not thinking correctly.

-Bryon

Edited May 8, 2009 by BryonR

[GEOSoft]

  BryonR said:

[/code]
#include <Access.au3>

$database = "c:\database\support.mdb"
$test = _accessQueryLike($database, "tbl_call","date","test")
MsgBox(0,"test",$adFull)
[code]

Its in the Access.au3 incude file, unless I'm just way off base and not thinking correctly.

-Bryon

$test is an array and if you had read the header for that function you would have seen that. I'm re-writing that function anyway but it won't break what you have now.

#include <Access.au3>
#include<array.au3>
$database = "c:\database\support.mdb"
$test = _accessQueryLike($database, "tbl_call","date","test")
_ArrayDisplay($test, "Returned Array")

[BryonR]

Thank you GeoSoft... I was getting tunnle vision and didn't think about adding the extra include.

BTW great UDF I use it quite a bit at least the store part

-Bryon

[GEOSoft]

  BryonR said:

Thank you GeoSoft... I was getting tunnle vision and didn't think about adding the extra include.

BTW great UDF I use it quite a bit at least the store part

-Bryon

YW. I just used the extra file for _ArrayDisplay() You could also have done it by looping through the elements. The important part is that it returns an array, not a string.

BTW; If you have been using this for a while, make sure you go back to the site and download the latest version so it will work with Access 2007

Edited May 8, 2009 by GEOSoft