Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Introduction (WebService Tool) • Introduction (Encryption) • Supported Browser Platforms • Introduction (Test Run Tool) • Workflow Tools • Control Types • Introduction (Email) • Setup • Introduction (Looping Tool) • BigCommerce WebService Access
versago3:form_setup

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
versago3:form_setup [2022/10/31 10:47]
dlee 		versago3:form_setup [2023/04/11 11:43] (current)
dlee
Line 32: Line 32:
   * Select or name the **Header ** and/or **Detail** table   * Select or name the **Header ** and/or **Detail** table
  
-==== SQL Query ====+===== Tables =====
  
-When this option is selected, a SELECT SQL statement can be entered manually or pasted from another source such as SQL Server Management Studio.+This section of the form set up pages allows to define the columns of the new tables if the **New tables** option is selected. 
 +If existing tables are selected, the page displays the selected table structure
  
-{{  :versago3:dv_setup03.png?direct  |}}+{{  :versago3:form_setup02.png?direct  |}}
  
-  * Enter the SELECT statement in the “Editor” area. +<WRAP center round important 80%> 
-  * Click [**Execute**] to validate the statement. +The process described below can only be used to create tables. It cannot be used to modify an existing table. This must be done directly in SQL. 
-  * Standard SQL error messages will be displayed if errors are encountered. +</WRAP>
-  * If the statement is correct, the first 50 records of the dataset are displayed in the “Results” area.+
  
-=== SQL Statement Restrictions === 
  
-  * An **Order By** clause cannot be used except in cases where the statement contains a TOP operator. The ordering (sorting) is handled by the data view's Field Display settings +==== Primary Table ====
-  * **Computed values** in the SQL statement must be assigned an alias. +
  
-==== B1 Query ==== +  - **FieldName** is the column name used in the database, not what appears to the user on the form 
- +    - The name can use letters, numbers, and the underscore (_) character. Spaces and other special characters are not permitted. 
-This option should only be used with connections to SAP Business One. This option allows to select user queries built in SAP Business One. +  - **Data Type** is selected from the drop-down option list. 
- +    - Use of the Binary option is not supported in Versago Forms (v2) and should not be used. 
-==== Stored Procedure ==== +    - Date is always created in the database as a DateTime data type. 
- +    - The data type for Number is set based on the Format (below). 
-In some rare instances it may be necessary to use an SQL Stored Procedure as the data source. This approach is not recommended if any other option is available. +  - **Format** is used for data types of Date and Numeric. 
- +    - Date data type 
-Store procedure parameters must be configured in the **//[[versago3:dataview_filters|Filters]]//** page. +      - The Date data type is always created in the database as a DateTime data type, irrespective of format. 
-====View==== +    - Number data type 
- +      - Format of Integer is always created in the database as an Integer (whole number) data type. 
-This option allows the use of a database View as the data source +      - Format of Decimal is always created in the database as Decimal data type. 
-   +    - Text data type 
-==== Crystal Report ==== +      - Text format is created as nvarchar data type. 
- +      - Text(max) is created as nvarchar(max) data type. 
-A Data View can be configured to display a Crystal Report. When this option is selected, the Crystal Report definition file is uploaded to the Versago site and used as the presentation method. +  - **Size** is the number of characters of the column in the database. 
- +    - For Text fields this is the maximum number of characters that can be entered. 
-<WRAP center round important 80% > +  - **Precision** indicates the number of decimals for Numeric/Decimal columns.
-The data source used in the Crystal Report definition **must** be the same as that of the Versago Data View connection. +
-</WRAP>  +
- +
-  * Select Crystal Report as the data source type. +
-  * A dialog box is presented where a Crystal Report definition file (.RPT) can be selected. +
- +
-The Crystal Report source file is copied from the original location to the folder “C:\Program Files (x86)\TWBS\Versago\Websites\Versago Administration Web Site\Reports.” A number is prefixed to the file name to ensure it uniqueness. If the Crystal Report needs to be modified, you can either modify this file or modify it elsewhere and re-register the new version in Versago. +
- +
---- +
-=====**Need to review**===== +
- +
-===SQL Server=== +
-When designing a Crystal Report that will use a __SQL Server__ database as its data source, the report connection type must be **OLE DB (ADO)**. This connection type has three options for the data provider: **SQL Native Client**, **Microsoft OLE DB Driver for SQL Server**, and **Microsoft OLE DB Provider for SQL Server**.  Any of these options should work with Versago. +
- +
-===HANA=== +
-When designing a Crystal Report that will us a __HANA__ database as its data source, the report connection type be **ODBC (RDO)**.  **{{ :versago:b1h_90_ht_setupdsforcrl.pdf |This document }}** explains how to configure this type of connection for use with HANA.  Two options are described in the document.  Be sure to use the **B1CRHPROXY32** option.  Here is a sample connection string to use as a starting point. +
- +
-<code> +
-DRIVER={B1CRHPROXY32};SERVERNODE=<YourServer>:30015;DATABASE=<YourDB> +
-</code> +
- +
-Replace <YourServer> and <YourDB> (without the < > symbols) with the appropriate values.+
  
 +<WRAP center round important 80%>
 +One field must be selected as the **Primary Field**. This field is used by Versago to identify each unique record.
 +</WRAP>
  
 +==== Recommended fields ====
 +We recommend the creation of the following fields using the shown naming convention.
  
 +^Field Name         ^Usage                                                                                                                               ^Comments                                                                                                              ^
 +|vgoRecNum          |Primary key                                                                                                                         |Required for any form table. Must be Numeric/Integer.                                                                 |
 +|vgoCreatedBy       |Email of user creating a new record                                                                                                 |Should be included in any header form table                                                                           |
 +|vgoCreateDate      |Date a new record is created                                                                                                        |Should be included in any header form table                                                                           |
 +|vgoCreatedById     |Versago User ID of user creating a new record                                                                                       |Should be included in any header form table. Used for reporting and profile access control                            |
 +|vgoLastModifiedBy  |Email of user modifying an existing record                                                                                          |Only needed if records will be updated using the same form where they were created, and if change tracking is desired.|
 +|vgoLastModifiedDate|Date an existing record is modified                                                                                                 |Only needed if records will be updated using the same form where they were created, and if change tracking is desired.|
 +|vgoLastModifiedById|Versago User ID of user modifying an existing record                                                                                |Only needed if records will be updated using the same form where they were created, and if change tracking is desired.|
 +|vgoProcessStatus   |“Flag” value to indicate if a record has been processed in some way (e.g. via Bizweaver)                                            |                                                                           |
 +|vgoProcessDate     |Date a record has been processed in some way (e.g. via Bizweaver)                                                                   |                                                                          |
 +|vgoLinkID          |Can be used to capture the ID of a record created in another system when the form record is processed in some way (e.g. Bizweaver)  |                                                                                                                      |
 +|vgoLinkDate        |Can be used to capture the date a record is created in another system when the form record is processed in some way (e.g. Bizweaver)|Like vgoProcessDate but used if two separate date stamps are desired.                                                 |
 +|                   |                                                                                                                                    |
 +===== Detail Table =====
  
 +A detail table is only used when the form type is Header/Detail. The definition process is the same as shown for the primary table. The only differences are the table name and the definition of the **Link** field to connect the header table record with the detail table records. The Linked Field must be the same name, data type, and format as the Primary Key in the header table.
  
 +<WRAP center round important 80%>
 +The detail table cannot have a **Primary Key**. This is an important consideration when using existing tables. 
 +</WRAP>
 ---- ----
 **[[versago3:forms#Add/Edit Form]]** **[[versago3:forms#Add/Edit Form]]**
versago3/form_setup.1667227666.txt.gz · Last modified: 2022/10/31 10:47 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