Brad Active Member Licensed User Longtime User Aug 30, 2011 #1 The code below retrieves an object from a listview, writes the data to a csv file then emails it. The first time through it works correctly but if I have it do it again without reloading the listview, the csv file is empty except for the header and ct.minutes is set to zero. The number of zeros equal the exact number of records so I know that it's stepping through the listview correctly. Code: For i = 0 To lvcalls.Size - 1 ct.Initialize ct = lvcalls.GetItem(i) pline = ct.Ctype & "," & ct.Name & "," & ct.number & "," & ct.date & "," & ct.time & "," & ct.minutes detailFile.WriteLine(pline) Next detailFile.Close Another odd thing is if I create the csv files using 'File.DirInternal' and attach it to an email, the file appears to be attached but the attachment is missing when I receive it. The way I was able to receive the attachment is to create the file using 'File.DirDefaultExternal'. Dunno if that makes sense to anyone.
The code below retrieves an object from a listview, writes the data to a csv file then emails it. The first time through it works correctly but if I have it do it again without reloading the listview, the csv file is empty except for the header and ct.minutes is set to zero. The number of zeros equal the exact number of records so I know that it's stepping through the listview correctly. Code: For i = 0 To lvcalls.Size - 1 ct.Initialize ct = lvcalls.GetItem(i) pline = ct.Ctype & "," & ct.Name & "," & ct.number & "," & ct.date & "," & ct.time & "," & ct.minutes detailFile.WriteLine(pline) Next detailFile.Close Another odd thing is if I create the csv files using 'File.DirInternal' and attach it to an email, the file appears to be attached but the attachment is missing when I receive it. The way I was able to receive the attachment is to create the file using 'File.DirDefaultExternal'. Dunno if that makes sense to anyone.
Erel B4X founder Staff member Licensed User Longtime User Aug 30, 2011 #2 Are you correctly opening the file? Another odd thing is if I create the csv files using 'File.DirInternal' and attach it to an email, the file appears to be attached but the attachment is missing when I receive it. The way I was able to receive the attachment is to create the file using 'File.DirDefaultExternal'. Dunno if that makes sense to anyone. Click to expand... The mail application doesn't have access to your internal application folder. You can use the new Net library and send the mail from your application instead. Upvote 0
Are you correctly opening the file? Another odd thing is if I create the csv files using 'File.DirInternal' and attach it to an email, the file appears to be attached but the attachment is missing when I receive it. The way I was able to receive the attachment is to create the file using 'File.DirDefaultExternal'. Dunno if that makes sense to anyone. Click to expand... The mail application doesn't have access to your internal application folder. You can use the new Net library and send the mail from your application instead.
Brad Active Member Licensed User Longtime User Aug 30, 2011 #3 Yes I am Erel. As a test I displayed the first record of ct.name in a msgbox just before the For loop. The first time through it displayed the correct name and the second time through it was blank. I'll take a look at the net library..Thanks! Upvote 0
Yes I am Erel. As a test I displayed the first record of ct.name in a msgbox just before the For loop. The first time through it displayed the correct name and the second time through it was blank. I'll take a look at the net library..Thanks!
Brad Active Member Licensed User Longtime User Aug 31, 2011 #4 Found the problem! I had to dim the object within the loop. easy fix for hours of banging my head on the wall. sheesh Upvote 0
Found the problem! I had to dim the object within the loop. easy fix for hours of banging my head on the wall. sheesh
