Remove Just MySQL datasources

mmurdock · Post by **mmurdock** » Fri Jun 01, 2012 5:41 pm

I currently use this command to clear all of the datasources:

StiReport1.Dictionary.Databases.Clear()

This of course clears all of the databases. Is there a way to just have it clear the MySQL databases and leave all others?

Thanks,

Mat

mmurdock · Post by **mmurdock** » Fri Jun 01, 2012 8:43 pm

Actually if I could remove the datasource by name that would work.

I tried to do this: StiReport1.Dictionary.Databases.Remove("blah") but I this error "Cannot remove the specified item because it was not found in the specified Collection."

Any help would be great.

Mat

mmurdock · Post by **mmurdock** » Fri Jun 01, 2012 9:30 pm

Well, this is what I came up with.

Code: Select all


Dim I As Integer = 0

        Dim intOriginalNumberOfConnections As Integer = StiReport1.Dictionary.Databases.Items.Length

        While StiReport1.Dictionary.Databases.Items.Length > I

            If StiReport1.Dictionary.Databases.Item(I).Name = "blah" Then

                StiReport1.Dictionary.Databases.RemoveAt(I)

            End If

            If intOriginalNumberOfConnections  StiReport1.Dictionary.Databases.Items.Length Then

                I = 0

            Else

                I = I + 1

            End If

        End While

Post by **Andrew** » Sat Jun 02, 2012 1:41 am

Hello,

Do I understand you correct that you found a decision for your question?

Thank you.