Replace the code you have posted above with this code
Dim sArtistKey As String
Dim sAlbumKey As String
Dim sTrackKey As String
Dim rst1, rst2, rst3 As Recordset
' Open a recordset and loop through it to fill tvwMusic
' Fill Level 1 using ArtistID as Key property
If rst1.State =...
...and you are welcome, have you stepped through the code to check where the "Out of bounds" error actually occurs?
Which key is not unique? Artist or Album? The Treeview control's Key property requires some non-numeric value, so using only the Autonumber field will not work. You will have...
Hi kimtp,
I think I see your problem.
BUG-FIX:
In your code for Level 2 change the line,
frmSSTab.tvwMusic.Nodes.Add rst.Fields("ArtistID").Value, tvwChild, sOrderKey, rst.Fields("Album").Value
to this,
frmSSTab.tvwMusic.Nodes.Add "a" & rst.Fields("ArtistID").Value, tvwChild, sOrderKey...
Hi Devilboy916,
When importing from a CSV data source file, DTS assigns a varchar/nvarchar datatype for each column in the CSV file.
You could use a "staging" table in MSSQL to import all the Source CSV data, and then use a Transform Data Task to load data into the Destination table.
In the...
gmctrek,
In case you have not yet been answered on this one.
You will need to assign the "HireDate" Global Variable using the Dynamic Properties Task before you run this ActiveX code.
The "DTSTask_DTSDataPumpTask_1" Task is created as a CustomTask when you "Set oDataPump = ...".
HTH...
Hi madhav23,
I am using a font file named "C39HALF.TTF" for my bar-codes on a set of logistics reports.
You can make most text data appear in a bar-code as long as you have the "start-bit" and "stop-bit", which crystalreporting has refered to above as termination...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.