>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.
Ok, I get you... I don't do any direct table manipulation in ASP. Instead, I use a middle tier object and return XML data islands to my ASP. Sorry I can't help you with this problem.
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown