<Select> SQL ERROR in ACCESS

[Rota]

Hi Buddies,

I am going crazy about one SQL error in ACCESS, please help on below:

test.zip

I attached 3 different forms to open a "select *" sql from a Access file, while it always give a open error, for example:

$oRec.Open ("SELECT * FROM " & $adTable & " Where " & $adCol & " = " & $Find , $oADO)

$oRec.Open ("SELECT * FROM " & $adTable & " Where " & $adCol & " = " & $Find , $oADO)^ ERROR

I have no idea how this come... please help.

Thanks a ton.

[Rota]

Any one in help for this SQL problem...

[PsaltyDS]

Hi Buddies,

I am going crazy about one SQL error in ACCESS, please help on below:

test.zip

I attached 3 different forms to open a "select *" sql from a Access file, while it always give a open error, for example:

$oRec.Open ("SELECT * FROM " & $adTable & " Where " & $adCol & " = " & $Find , $oADO)

$oRec.Open ("SELECT * FROM " & $adTable & " Where " & $adCol & " = " & $Find , $oADO)^ ERROR

I have no idea how this come... please help.

Thanks a ton.

I would help if you posted the actual error, vice just the quoted line. Did it say something like "requires an object"? Did you test IsObj($oRec) before trying to use it?

[Rota]

Thanks PsaltyDS,

Yes, of course I used IsObj($oRec) in one of my searching function, could you please look in my attachment which I prepared 3 sample as well as my sample database, while 2 of them were totally not working in my pc, another one worked in mine but not in other pc.

[PsaltyDS]

Thanks PsaltyDS,

Yes, of course I used IsObj($oRec) in one of my searching function, could you please look in my attachment which I prepared 3 sample as well as my sample database, while 2 of them were totally not working in my pc, another one worked in mine but not in other pc.

If I think of it when I'm not in Windows-land I'll crack it open and take a look, but I don't usually work with untrusted downloads from the forums. It would help if you could just post plain text info here.

[DaRam]

It really helps ( ) that you do not include the include - #include<ACcess.au3>

Since adCol="txt1", I presume this is a Text data type column/field.

Try:

$oRec.Open ("SELECT * FROM [" & $adTable & "] WHERE [" & $adCol & "] = '" & $Find & "'", $oADO)

Or Just:

$oRec.Open ("SELECT * FROM " & $adTable & " WHERE " & $adCol & " = '" & $Find & "'", $oADO)