Debugging Immediate Window

[rodchar]

Hey all,

when i'm in debug mode, is there a way to get to a certain record in a
dataset (say like in the Immediate window or something)?

thanks,
rodchar

[Richard Myers]

"rodchar" <ro*****@discus sions.microsoft .com> wrote in message
news:A3******** *************** ***********@mic rosoft.com...

Hey all,

when i'm in debug mode, is there a way to get to a certain record in a
dataset (say like in the Immediate window or something)?

thanks,
rodchar

Yep. Asumming you've breakpointed your way into debug mode at the scope of the datset is such that
it is "alive" when your break point is hit you can use the Immediate window to :

? MyDataset.Table s.Count

...... you can do anything you like here

Note the ? is very imkportant as it asks a question which returns a result. You can also make
assignment by dropping the ?.

MyDataset.Table s(0).Rows(0)(1) = "Assign value"

hth
Richard

[Walt Ritscher]

This will return the datarow in the command window
?me.dsFleet.Tab les(0).Rows(0) ' first table, firstrow

To return the datacolumn
?me.dsFleet.Tab les("Customers" ).Rows(2)("Addr ess") ' customer table, third
row, address datacolumn

--
Walt Ritscher
www.waltritscher.com\blogs
www.scandiasoft.com
yahoo email account is a spam trap - I will not reply to any mail sent to
this address.
"rodchar" <ro*****@discus sions.microsoft .com> wrote in message
news:A3******** *************** ***********@mic rosoft.com...

Hey all,

when i'm in debug mode, is there a way to get to a certain record in a
dataset (say like in the Immediate window or something)?

thanks,
rodchar

[Ken Halter]

Richard Myers wrote:

? MyDataset.Table s.Count

..... you can do anything you like here

Note the ? is very imkportant as it asks a question which returns a result. You can also make
assignment by dropping the ?.

Note that the use of a question mark to get the Basic language to print
something goes back to the late 1970's. If you entered "?" in your Quick
Basic program, it would be converted to "PRINT" automatically.

--
Ken Halter - MS-MVP-VB - http://www.vbsight.com
Please keep all discussions in the groups..

[Richard Myers]

> Note that the use of a question mark to get the Basic language to print

something goes back to the late 1970's. If you entered "?" in your Quick
Basic program, it would be converted to "PRINT" automatically.

Now thats legacy code!
I wonder if "?" still wears flares?

[rodchar]

But what if I didn't know what the record number was. Let's say in a dataset
of 500 records I want to look at a record where a field = a specific value.
Kinda like, querying it in debug mode, is that possible?

"rodchar" wrote:

Hey all,

when i'm in debug mode, is there a way to get to a certain record in a
dataset (say like in the Immediate window or something)?

thanks,
rodchar

[rodchar]

Awesome, thank you.

"Richard Myers" wrote:

"rodchar" <ro*****@discus sions.microsoft .com> wrote in message
news:22******** *************** ***********@mic rosoft.com...

But what if I didn't know what the record number was. Let's say in a dataset
of 500 records I want to look at a record where a field = a specific value.
Kinda like, querying it in debug mode, is that possible?

? MyDataset.MyTab le.Select("Cust omerId=5").Leng th

Will give the number of rows satifying the filter condition.

If you want to display the row

? MyDataset.MyTab le.Select("Cust omerId=5")(0)

Would return the first rowin the array of return rows that satisfied the criteria of the filter
condition. If you are using a untyped dataset you will get a bunch of lines about

Item: <cannot view indexed property>

so you will have to further refine your search

? MyDataset.MyTab le.Select("Cust omerId=5")(0)(" My Property")

If you are using typed datasets your own version of the query below should pull up enough info to be
of use

? ctype(_customer s.Customer.Sele ct("CustomerId= 90004")(0), dsCustomer.Cust omerRow)

Here i am querying the Customer table in a dataset called _customer which is of type dsCustomer for
all rows which have a customerId of 90004. This will return an array of datarows;of which i am
casting the first from the base type of datarow as returned by the select method to the strongly
typed dsCustomer.Cust omerRow:

Assumming a row matching this criteria is found the immediate window will return a list of field
values for this particular row:

{dsCustomer.Cus tomerRow}
AKey: "fffffff"
CustomerId: 90004
DCity: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DCountry: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DStateRegion: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DStreet1: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DStreet2: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DSuburb: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DZipcode: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
Email: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
Fax: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
HasErrors: False
Item: <cannot view indexed property>
Item: <cannot view indexed property>
Item: <cannot view indexed property>
Item: <cannot view indexed property>
ItemArray: {Length=26}
Name: "Rodger Bannister"
PCity: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PCountry: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
Phone1: "021 240 7444"
Phone2: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PhoneFree: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PStateRegion: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PStreet1: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PStreet2: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PSuburb: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PZipcode: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
RowError: ""
RowState: Unchanged
SalesCallStatus : 4
SalesRoute: 2
SalesTerritoryI d: 3
Table: {dsCustomer.Cus tomerDataTable}
Website: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
Anything like <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred> generally
means that the strongly typed dataset contains a value of Null for that field.

hth
Richard

[rodchar]

Awesome, thank you.

"Richard Myers" wrote:

"rodchar" <ro*****@discus sions.microsoft .com> wrote in message
news:22******** *************** ***********@mic rosoft.com...

But what if I didn't know what the record number was. Let's say in a dataset
of 500 records I want to look at a record where a field = a specific value.
Kinda like, querying it in debug mode, is that possible?

? MyDataset.MyTab le.Select("Cust omerId=5").Leng th

Will give the number of rows satifying the filter condition.

If you want to display the row

? MyDataset.MyTab le.Select("Cust omerId=5")(0)

Would return the first rowin the array of return rows that satisfied the criteria of the filter
condition. If you are using a untyped dataset you will get a bunch of lines about

Item: <cannot view indexed property>

so you will have to further refine your search

? MyDataset.MyTab le.Select("Cust omerId=5")(0)(" My Property")

If you are using typed datasets your own version of the query below should pull up enough info to be
of use

? ctype(_customer s.Customer.Sele ct("CustomerId= 90004")(0), dsCustomer.Cust omerRow)

Here i am querying the Customer table in a dataset called _customer which is of type dsCustomer for
all rows which have a customerId of 90004. This will return an array of datarows;of which i am
casting the first from the base type of datarow as returned by the select method to the strongly
typed dsCustomer.Cust omerRow:

Assumming a row matching this criteria is found the immediate window will return a list of field
values for this particular row:

{dsCustomer.Cus tomerRow}
AKey: "fffffff"
CustomerId: 90004
DCity: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DCountry: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DStateRegion: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DStreet1: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DStreet2: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DSuburb: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
DZipcode: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
Email: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
Fax: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
HasErrors: False
Item: <cannot view indexed property>
Item: <cannot view indexed property>
Item: <cannot view indexed property>
Item: <cannot view indexed property>
ItemArray: {Length=26}
Name: "Rodger Bannister"
PCity: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PCountry: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
Phone1: "021 240 7444"
Phone2: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PhoneFree: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PStateRegion: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PStreet1: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PStreet2: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PSuburb: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
PZipcode: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
RowError: ""
RowState: Unchanged
SalesCallStatus : 4
SalesRoute: 2
SalesTerritoryI d: 3
Table: {dsCustomer.Cus tomerDataTable}
Website: <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred>
Anything like <error: an exception of type: {System.Data.St rongTypingExcep tion} occurred> generally
means that the strongly typed dataset contains a value of Null for that field.

hth
Richard