× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Using EB.DEV.HELPER to create Application

Start
Prev
1
Next
End

woolala
Topic Author
Offline
Junior Member

6 years 2 months ago #21593 by woolala

Using EB.DEV.HELPER to create Application was created by woolala

Hello All,

I have some questions about EB.DEV.HELPER.
First, after the establishment of the completion of the application, it will also create a data table in SQL Server.
But this is a bit different from other applications, XMLRECORD data type will be varbinary(MAX) not xml.

Second, if executes commands jstat -v in jshell to see application,
it will also find that application name doesn't match table name in SQL Server.
e.g.

*-----------------------------------------------------------------------------
    SUBROUTINE IBBK.FUNDS.TRANSFER
*-----------------------------------------------------------------------------
* <region name= Inserts>
    $INSERT I_COMMON
    $INSERT I_EQUATE
    $INSERT I_Table
* </region>
*-----------------------------------------------------------------------------
    Table.name = 'IBBK.FUNDS.TRANSFER'        ;* Full application name including product prefix
    Table.title = 'IBBK.FUNDS.TRANSFER'       ;* Screen title
    Table.stereotype = 'H'    ;* H, U, L, W or T
    Table.product = 'EB'      ;* Must be on EB.PRODUCT
    Table.subProduct = ''     ;* Must be on EB.SUB.PRODUCT
    Table.classification = 'FIN'        ;* As per FILE.CONTROL
    Table.systemClearFile = 'Y'         ;* As per FILE.CONTROL
    Table.relatedFiles = ''   ;* As per FILE.CONTROL
    Table.isPostClosingFile = ''        ;* As per FILE.CONTROL
    Table.equatePrefix = 'IBBK.FT'      ;* Use to create I_F.EB.LOG.PARAMETER
*-----------------------------------------------------------------------------
    Table.idPrefix = ''       ;* Used by EB.FORMAT.ID if set
    Table.blockedFunctions = ''         ;* Space delimeted list of blocked functions
    Table.trigger = ''        ;* Trigger field used for OPERATION style fields
*-----------------------------------------------------------------------------
    RETURN

The IBBK.FUNDS.TRANSFER would be dbo.FBNK_IBBK_FUNDS_TRANSFER
But it becomes dbo.FBNK_IBBK000

jsh T245060 ~ -->jstat -s FBNK.IBBK.FUNDS.TRANSFER
Microsoft SQL Server - V10.50.1600

Server SCN00EPA01, Version R09.1.90885, File = default_FBNK_IBBK000
Type = XMLMSSQL, Table = FBNK_IBBK000
Schema = T24DBUSER

Anyone knows how to solved this? Thanks for help.

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Time to create page: 0.090 seconds