Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ASP and FoxPro View
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00256715
Message ID:
00256775
Views:
19
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform