Re: Veiwing Datasets in Debug Mode

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Isn't a Dataset a .Net thing? Also, he may be talking about the Viewers (I
think that's what they are called - Jeff Johnson would know since I think he
has developed some custom ones) that let you view in detail objects while in
debug mode in .Net

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--
Read. Decide. Sign the petition to Microsoft.
http://classicvb.org/petition/


"Douglas Marquardt" <no_spam@xxxxxxxxx> wrote in message
news:uLmwFKfZFHA.3852@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Daren:
>
> A couple of ways I can think of off the top of my head:
>
> 1. Loop through the rs and print each fld, i.e.
>
> Do While Not rs.EOF
> For Each fld In rs.Fields
> Debug.Print fld.Value,
> Next fld
> Debug.Print
> rs.MoveNext
> Loop
>
> 2. Show a modal form with a grid,i.e.
>
> Set frmDebug.Grid.DataSource = rs
> frmDebug.Show vbModal
> Unload frmDebug
>
> Note: You may want to clone the original rs instead of using the
original.
>
> hth,
>
> Doug.
>
>
> "Daren Hawes" <newsgroups@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:O73uytbZFHA.3712@xxxxxxxxxxxxxxxxxxxxxxx
> > Is there a way to view the contents of a Dataset in Debug mode?
> >
> > Thx
> >
> >
>
>


.

Relevant Pages

  • Re: Veiwing Datasets in Debug Mode
    ... > Chris Hanscom - Microsoft MVP ... >> For Each fld In rs.Fields ... >> Doug. ... >>> Is there a way to view the contents of a Dataset in Debug mode? ...
    (microsoft.public.vb.bugs)
  • RE: Jump to specific record in recordset
    ... the outer Do Loop, I always return to the first record of the inner recordset ... For Each fld In tdf.Fields ... Set rsCurrent = MyDB.OpenRecordset("SELECT * FROM qryOrderProductsBase ...
    (microsoft.public.access.modulesdaovba)
  • Re: Count VB
    ... >Your code doesn't loop through the field names, ... > Dim fld As DAO.Field ... >> Function CountBlanks(FiledName As String, ...
    (microsoft.public.access.modulesdaovba)
  • Re: FastCode : Exponential
    ... the number of loop changes the precision of the calculation. ... FLD Value ... FSTP ST ...
    (borland.public.delphi.language.basm)
  • Re: For Each
    ... I don't believe you can loop through the records with a "For Each", because, ... to the best of my knowledge, the individual records in the recordset are not ... For Each fld In rst.Fields ... > Rachiano Haselhoef. ...
    (microsoft.public.access.formscoding)