Exporting database - Only field names exported (with no data)

Pawelski_33

Forums

Hi ,
I am exporting (to excel) the database by calling customized ExportDBOnly (which I use throughout of the programme) from other fuction GapDetection.However the only bit imported is the name of the fields and no data is actually included in the excel file (despite IncludeAllFiled method used).
I attached the copy of my code.

Brian Element Tue, 06/26/2018 - 08:59

Hi Pawelski_33,

Thanks for the code, there looks like there is an extra space between the TargetDb. and the Count, there should be a space and that is probably why you are not getting any data.

ExportData.PerformTask ExportPath, TaskName, ExportType, 1, TargetDb. Count, " "

Brian

Pawelski_33 Wed, 06/27/2018 - 08:49

Thank you Brian - you are GENIUS... that and space within double quote ""  in relation to Criteria element of task.PerformTask was the primary root of the issue.
I ve spent couple of hours trying to figure out what the problem was - thank you.
 
 

Brian Element Wed, 06/27/2018 - 09:36

I have been there, spending a couple of hours trying to figure out what is not working just to realize that all it was was an extra space or a forgotten period or comma, programming take patience and is definitely not for everyone lol