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

4 posts / 0 new
Log in or register to post comments
Last post
Tue, 06/26/2018 - 07:31
#1
Pawelski_33
Offline
Joined: 06/05/2018 - 12:16
Exporting database - Only field names exported (with no data)

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.

Files: 
Plain text icon Export Function called from other function.txt
Top
Tue, 06/26/2018 - 08:59
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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

Top
Wed, 06/27/2018 - 08:49
Pawelski_33
Offline
Joined: 06/05/2018 - 12:16

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.
 
 

Top
Wed, 06/27/2018 - 09:36
(Reply to #3)
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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

Top