Copied and pasted the example, both SQL and script.
Saved the SBL file in the UserDocs and Scripts directory, since I wasn’t sure where BOb would look.
Fixed the errors in the example SQL statment. Hope the 1 line SBL was correct.
Yet still I can not get the @script function to work using FreeHand SQL as the data provider. All it does is connect … it never returns any results. The Check SQL function never executes. Remove the @script function call and it works.
Is there something not set? Is the script file in the wrong location? Has anyone got this to work? If so, could you provide an error-free example? The BOb documentation states that it will work, but then again …
Against the “Club” Access database…
I got everything to work with this script: Sub main
application.variables.item(“Customer name”).value = “William” End sub
And this SQL statement:
SELECT
last_name,first_name
FROM
Customer
WHERE
(first_name=@script(‘Customer name’,‘a’,‘example’))
I saved the script as Example.spt under the BO\Scripts directory.
Cheers,
Luis Gonzalez
From: Jim Droppa [SMTP:jpord@MAILEXCITE.COM]
Yet still I can not get the @script function to work using FreeHand SQL as the data provider. All it does is connect … it never returns any results. The Check SQL function never executes. Remove the @script function call and it works.
Is there something not set? Is the script file in the wrong location? Has anyone got this to work? If so, could you provide an error-free example? The BOb documentation states that it will work, but then again …