Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Using TWBS Credit Card Processing • Introduction (ExchangeConnector)
versago3:dataview_display

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
versago3:dataview_display [2023/04/13 11:15]
dlee 		versago3:dataview_display [2024/03/14 14:16] (current)
dlee [Field Display]
Line 26: Line 26:
   * **Database Source Files** are identified by reference to specific records in a database.  The information provided below refers to files uploaded via a Versago form.   * **Database Source Files** are identified by reference to specific records in a database.  The information provided below refers to files uploaded via a Versago form.
   * The data is found in a table named "TWBS_VGO_FormAttachments".  This table is found in the database where the data captured in the form is stored.   * The data is found in a table named "TWBS_VGO_FormAttachments".  This table is found in the database where the data captured in the form is stored.
-    * Two values are required from the record: FileName and FileContent.  __FileContent__ is the binary data that will be converted for download.  __FileName__ is used as the reference to the binary data. +    * Two values are required from the record: FileName and FileContent.  __FileContent__ is the binary data that will be converted for download.  __FileName__ contains the file name of the binary. 
-    * When the data type of the column is binary, blob, or varbinary the __File Name__ field for the FileContent row presents a drop-down list of fields from the report query.  Select the column name that contains the associated file name. +    * The Display Type of __FileContent__ should be set to File 
-    * It is not necessary to display the __FileName__ value in the report, but showing the user the name of the file is typically very helpful.+    * It is not necessary to display the __FileName__ value in the report, but showing the name of the file is typically very helpful.
   
 The **files in a database** approach does require that the __FileContent__ value is not NULL.  As it is very possible that a report row will not have a corresponding report to download, use the following SQ.  Setting FileContent to 0 when the database value is NULL allows the report to execute without errors.   The **files in a database** approach does require that the __FileContent__ value is not NULL.  As it is very possible that a report row will not have a corresponding report to download, use the following SQ.  Setting FileContent to 0 when the database value is NULL allows the report to execute without errors.  
versago3/dataview_display.1681398950.txt.gz · Last modified: 2023/04/13 11:15 by dlee

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki