Eyes on Query in Script...Query

[[email protected]]

Hello,

I've looked at this script until I'm blind. The query works if I run it standalone, but not in the script. The variables are set, but does bring back the query which in this case is > 0...Can anyone see anything funny in the Query Selection:

'Date Created: 13-Mar-2009 02:26:53 AM
'Last Updated: 08-Apr-2009 02:44:37 PM
'Created By : Ryland
'Updated By : Ryland

DIM global_var_A as c
DIM GLOBAL user as C
DIM GLOBAL pword as C
DIM GLOBAL level as C
DIM GLOBAL varC_result as C
dim global try as n
dim global way as c
dim ans as n
dim time_in as c
dim tbl_1 as p
dim qry_1 as p
dim recs_1 as n
DIM global v_personnel as c
dim XDialogStyle as p


'see if tool has already been checked out of stock

tbl_1=table.open("invoice_items")
query.filter="(Product_id = Var->v_product ) .and. (Customer_id = Var->v_personnel ) .and. date_is_today(Tool_issue_date)"
query.order=""
query.options="T"
qry_1=tbl_1.query_create()
recs_1=qry_1.records_get()

msgbox(v_personnel)
msgbox(v_product)
if recs_1 = 0 then
msgbox("Tool not Issued To This Customer ... See Tool Room Custodian or Supervisor for Override")



else
msgbox("Tool OK to Return")
end if

end

Thanks Ryland

[aschone]

Re: Eyes on Query in Script...Query

query.filter="(Product_id = Var->v_product ) .and. (Customer_id = Var->v_personnel ) .and. date_is_today(Tool_issue_date)"

Try this...

query.filter="(Product_id = " + Var->v_product+" ) .and. (Customer_id = "+ Var->v_personnel+" ) .and. date_is_today("+Tool_issue_date+")"

May even have to be like...

query.filter="(Product_id = " + Var->v_product+" ) .and. (Customer_id = "+ Var->v_personnel+" ) .and. date_is_today( {"+Tool_issue_date+"})"

[Tom Cone Jr]

Re: Eyes on Query in Script...Query

Ryland, some of the variables used in the query filter expression do not appear to have been dimmed in the script itself.

[G Gabriel]

Re: Eyes on Query in Script...Query

Why not:
query.filter="(Product_id = Var->v_product ) .and. (Customer_id = Var->v_personnel ) .and. (Tool_issue_date=date())"

[[email protected]]

Re: Eyes on Query in Script...Query

Thanks,

This one seemed to do the trick. it was getting screwed up on the date somehow in the script, but I ran this last version and it appeared to like it returning the correct record back.

The other suggestion above may work with another type of query in a script that I was having trouble with by checking the +"" and the end as I do have instances of that in the data.

Thanks all for your help.

Ryland