PC Review


Reply
Thread Tools Rate Thread

Can ADO to leave remnant data behind?

 
 
Ron Fluegge
Guest
Posts: n/a
 
      14th Jul 2007
I have encountered a situation where supposedly a function returning a
datatable does not always clear the datatable before loading. This is
according to a client, but I have not been able to verify that this is
indeed what is happening ... client evidence seems to indicate this "type"
of problem.

For example,

Dim dtMast As New dsMaster.MastDataTable

For each drSetup in dtSetup

dtMast = CreateTimeLine(drSetup.UniqueID, dtTemp1, dtTemp2)

Next

--------------

public function CreateTimeLine(...) as dsMaster.MastDataTable

Dim dtMast As dsMaster.MastDataTable
dtMast = New dsMaster.MastDataTable
:
:
return dtMast

end function

--------------

Shouldn't the "dtMast = CreateTimeLine(drSetup.UniqueID, dtTemp1, dtTemp2)"
always create a new dtMast such that all of the rows in the table are
cleared when the CreateTimeLine is called each time in the loop?

In walking through it in the debugger (VS 2003 Framework 1.1) it exhibits
that behavior each and every time (i.e., the data from the prior loop is NOT
in the database table), but has anyone encountered a situation where this
does not occur with each function call ... essentially creating a table with
rows from the last two loops instead of rows from just the latest?

Thanks

RonF


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Leave Blank If No Data George Microsoft Excel Misc 6 26th Apr 2010 03:17 AM
leave out certain data in a query.. stephendeloach via AccessMonster.com Microsoft Access Queries 2 16th Apr 2007 06:02 PM
FrontPage remnant folder =?Utf-8?B?UGV0ZQ==?= Microsoft Frontpage 3 6th Feb 2007 08:41 PM
How to remove a remnant of a program =?Utf-8?B?bW9lMTAz?= Windows XP General 3 18th Nov 2006 02:11 AM
Leave out Some Data Phillip Schmidt Microsoft Access Reports 2 11th Dec 2003 03:15 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:17 PM.