Re: VB6/SQl Server 2000 (Vaughn)

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thank you for your reponse William.I'll state my case more prcisely, so that
you may be able to suggest a solution.

I have statements like :-

/*
declare @errorcode int
......
select 'Entering [Proc1] at :' + convert(varchar, getdate(), 109)
exec @errorcode = proc1(param1,param2);
if @errorcode = 0
.....
......

begin
select @Var1Name = Name
from table_name1
where age = 50
@Errorcode = @@error
end
......
If (@errocode = 0)
select '[Proc1] ran successfully'
.....
*/

in my stored procedure. Presently I am using SELECT instead of PRINT command
to store concatenated results and other debug statements (as is seen above).
I want to be able to access these "select statements" and value of the
ErrorCode variable, in Vb6 forms, for display. In the current scenario ,I was
trying to do it using GetClipString() function which dint work.

If proc1 in turn calls proc2 and proc2 has debug statements, I will need to
display them as well. If I want to use ADO, what components do I have to
include in my project ? Is it possibe to achieve what I want without changing
SELECT to PRINT ?

Thank you in advance

- Vikas

"William Vaughn" wrote:

IIRC VB6 had stored procedure debugging which permitted one to step through
the SP from VB. However, it seems to me that it took a lot of work (and
magic) to get working. Yes, Visual Studio supports this as well using
different technology that works a lot better.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Vikas" <Vikas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:76F6A6B6-6DFF-49ED-82EF-E4EA784A6900@xxxxxxxxxxxxxxxx
I have debug statements in my Stored Procedures, which I want to display to
a
"text" control placed on a VB6.0 form.Events flow from one SP to
another and I want all the statements.

In short, I want to trace the path ,of the flow of events, at the server
side - Customized debug statements as well as errors, if any.

I tried by connecting the first SP (from wher I want the trace to start)
to
a resultset
object. and then tried using GetClipString() function of the resultset .
But
it doesnt go through the entire flow.

Is there soem other way of doing this ? . Please help.

- Vikas

.

Relevant Pages

  • Re: VB6/SQl Server 2000
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... In short, I want to trace the path,of the flow of events, at the server ... I tried by connecting the first SP (from wher I want the trace to start) to ... and then tried using GetClipStringfunction of the resultset. ...
    (microsoft.public.vb.database)
  • Re: run Profiler on a specific SP/Query/Function
    ... more than Completed events? ... so you get a better grip over the flow. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Forced to use Table.Rows(...).EndEdit when using data binding
    ... A data adapter is used to manage the flow of data between SQL server ... method fail to write the changes to the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Push or Pull for Replication-Based failover
    ... of the distribution agent. ... I think you're mixing PUSH/PULL with the flow of ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)