Re: Does the PRINT command simply not work?



Fardreamer wrote:

> Update: So, I went to the database server and logged in as an
> administrator. What do I see? 3 message boxes with the title "SSP
> PrintVal" showing the three messages I tried to PRINT from my stored
> procedure! What kind of weird behavior is that? Is there any way to
> disable it?


This is actually documented behavior -- and mainly useless for
developers. The PRINT function seems to have been solely implemented
to enable debugging, and was designed for the local engine. When you
issue the PRINT command, the dialog box does indeed show up whereever
the engine is located (on the server for a client/server engine).

Want one better? Your procedures did not hang -- they were awaiting
the completion of the PRINT command. If you had simply gone to the
server and clicked OK on the dialog box, it would have proceeded and
terminated normally.

In short, use PRINT **ONLY** for debugging your procs. If you must
return some message, consider building an entry in a Log File somewhere
and having the user view that periodically.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - November, 2005 ***
*** Chicago: Pervasive DataExchange Class - November, 2005 ***
.



Relevant Pages

  • Re: Performance PSQL 10
    ... at 9.5 on a Linux Redhat ES server installation. ... We crash the SQL engine occasionally. ... environment settings, pretty much we tried everything the Pervasive ... What we REALLY need is a long enough pause and a site willing to crash ...
    (comp.databases.btrieve)
  • Re: Have you had good results with Trend Micro support?
    ... I had the same problem with server pattern would not update but all else ... would (the new 8.5 engine was installed on all servers and clients). ... XP/Vista clients and the SBS2k3R2 standard server software to include the ... It's the SBS server's TM Client ...
    (microsoft.public.windows.server.sbs)
  • Re: Have you had good results with Trend Micro support?
    ... I had the same problem with server pattern would not update but all else ... would (the new 8.5 engine was installed on all servers and clients). ... XP/Vista clients and the SBS2k3R2 standard server software to include the ... server client, MSA and security server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Have you had good results with Trend Micro support?
    ... "Our developers have checked the issue and has a hotfix for the said ... It worked on my server. ... would (the new 8.5 engine was installed on all servers and clients). ... server client, MSA and security server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Pricing
    ... So would this price be for just a Ms Access (native jet engine - inventory) ... I am trying to determine what this will cost me with out a BE server? ... FAITH ESTIMATE what seems to be the normal price for a developer to charge? ...
    (comp.databases.ms-access)