Can not Get Loop to Work


Can not Get Loop to Work
View
Options
Author
Message
Terry Bottorff
Terry Bottorff
Terry Bottorff
posted 13 Years Ago
Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)Advanced StrataFrame User (770 reputation)
Group: Forum Members
Posts: 448, Visits: 12K
What am I missing? I tried the following code:

        'For Each lobo As ResultsPerfsChecksRoughStockBO In Me.ResultsPerfsChecksRoughStockBO1.GetEnumerable
        '    cword = DecimalToText.ConvertDecimalToText(Me.ResultsPerfsChecksRoughStockBO1.netcheck)
        '    Me.ResultsPerfsChecksRoughStockBO1.amountinwords = cword
        '    y += 1
        'Next

        ' Could Not Get the Above to Work because it would only do the First Record. So I put the following in
        MessageBox.Show(Me.ResultsPerfsChecksRoughStockBO1.Sort)
        MessageBox.Show(Me.ResultsPerfsChecksRoughStockBO1.Filter)
        MessageBox.Show(Me.ResultsPerfsChecksRoughStockBO1.Count.ToString())

The First two messageboxes show nothing and the last one shows 10 which is correct. So I tried the following code and it only does the first record also?????

               If Me.ResultsPerfsChecksRoughStockBO1.MoveFirst() Then
            ' Loop Thru All Records Making Sure NetCheck is Correct and Getting Words for Netcheck
            
            Do
                nnet = Me.ResultsPerfsChecksRoughStockBO1.checkamt + Me.ResultsPerfsChecksRoughStockBO1.groundmoney -  Me.ResultsPerfsChecksRoughStockBO1.tax
                cword = DecimalToText.ConvertDecimalToText(Me.ResultsPerfsChecksRoughStockBO1.netcheck)
                Me.ResultsPerfsChecksRoughStockBO1.amountinwords = cword
                nnet = 0.0
            Loop While Me.ResultsPerfsChecksRoughStockBO1.MoveNext()
        End If

I just can not see the trees for the forest. I know it has to be something weird I am doing but I don't know what it is. Any help would be appreciated. TIA.
Reply Like 0
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...



Submit

Threaded View
Threaded View
Can not Get Loop to Work
Terry Bottorff - 13 Years Ago
     Hi Terry. Try this one: [codesnippet] For Each lobo As...
Ivan George Borges - 13 Years Ago
             Sorry to say that did not work either????
Terry Bottorff - 13 Years Ago
                 Hi Terry, Ivan's code is the correct way to handle the...
Edhy Rijo - 13 Years Ago
                     Well an interesting thing happened. While trying to debug the above...
Terry Bottorff - 13 Years Ago

Similar Topics

Post Quoted Reply
Reading This Topic

Powered by InstantForum 2017-1 Final © 2024
Execution: 0.000. 2 queries. Compression Enabled.

Login

Explore
Messages
Mentions
Search