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.
Ilyas2010 270006PJM41 Post
Re: How to Edit TI Process without first Executing it?2013-10-04T14:18:48ZThis is the accepted answer. This is the accepted answer.
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);