Topic
  • 2 replies
  • Latest Post - ‏2013-10-04T14:18:48Z by Ilyas2010
Lepakshi
Lepakshi
2 Posts

Pinned topic How to Edit TI Process without first Executing it?

‏2013-09-01T07:26:56Z |

While editing a TI process, it first executes the SQL Query before opening it. As the Query is wrong it goes into infinite loop, and the TI process hangs. Any suggestions? Thanks.

  • RodJager
    RodJager
    1 Post

    Re: How to Edit TI Process without first Executing it?

    ‏2013-09-01T23:58:20Z  

    Hi Lepakshi,

     
    Rename the related ODBC connection then try opening the TI process.
     
    Hope this helps.
     
    Regards,
     
    Rod
  • Ilyas2010
    Ilyas2010
    1 Post

    Re: How to Edit TI Process without first Executing it?

    ‏2013-10-04T14:18:48Z  

    Hi,

    You can manage your connection in prolog like :

    Query = 'Select bla bla bla...............'

    ODBCOpen( zODBC, zClient, zPassword);
    DataSourceType = 'ODBC';
    DatasourceNameForServer = zODBC;
    DatasourceUserName = zClient;
    DatasourcePassword = zPassword;
    DatasourceQuery = Expand ( Query);

     

    Regards