Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to find run-time values

How to

How to find run-time values

by  Rolliee  Posted    (Edited  )
From time to time, I want to know what, fokr instance, the SQL actually was at a run-time event. This allows me to, at a latere date, view the value or it - or any other similar value. I can add a time date ref to the filename or the user to make it more unique and keep all such events.

private sub TellMe(SQLstr as string)

OPEN "\MyFolder\TellMe.txt" FOR APPEND as #1

print #1, "My Helps " & space(23) & now()
print #1, "The SQL was ";
print #1, SQLstr

close #1

exit sub
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top