>> Can someone assist me and locate the problem.
Or how to trap it and overcome the issue<<
Any chance there is a global or object-based error handler in place that is
ignoring either the SQL-SELECT not finding the wininvs table or unable to
open the
*-------------------------------------------
TRY
* Following code could try to query into a table that is open by this or
another workstation
SELECT * FROM wininvs WHERE str(invnum,10)+client==trcask519 INTO TABLE
(myfile)
*< USE && Could be wrong workarea
USE IN (SELECT(JUSTSTEM(myfile))) && Just close the workarea if it is
open
*< SELECT 100 && Bad idea to pick a non-random workarea
SELECT 0 && Next available workarea
USE (myfile) ALIAS wintemp EXCLUSIVE
GO top
CATCH TO loException
MESSAGEBOX("ERROR: " + loException.Message + " (" + loException.ErrorNo +
") " + ;
" on line " + loException.LineNo)
ENDTRY
*-------------------------------------------
This way your code will fail with a message if any line of code has a
problem executing.
Rick
White Light Computing, Inc.
www.whitelightcomputing.com
www.swfox.net
www.rickschummer.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/012901cb9b1d$b7e5aaf0$27b100...@com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
