Thanks for your reply,
Here is the code of the FoxPro view named MOVE_OUT:
SELECT Invprentry.exp_num, Invprentry.Pending, Invmov_out.bill_o_lading,;
Invmov_out.carr_name, Invmov_out.date, Invmov_out.cust_ord,;
Lot_out.lot_num, Lot_out.unit_num, Lot_out.unit_qty, Lot_out.net_wght ;
FROM globaldb!invprentry INNER JOIN globaldb!invmov_out;
INNER JOIN globaldb!lot_out ;
ON Invmov_out.imo_id = Lot_out.imo_id ;
ON Invprentry.inv_id = Invmov_out.inv_id
And the ASP Code is:
...
LocPending=".T."
SqlQuery= "SELECT * FROM Move_Out WHERE PENDING="&LocPending
Set MoveOut = SQLConn.Execute(SqlQuery)
Is it possible to Requery from ASP Code?. How?
Best Regards,
Erick,
You go with what you know at the time.
You go with what you know at the time