List of Contributions

Jaykar

Contact Details

Jaykar


My Content

1 to 20 of 29 total

$FTOPTIX #Sounds

Posted By Jaykar Mar 14, 2026 07:30:00 AM
Found In Egroup: Advanced Software \ view thread
How can I implement conditional Text-to-Speech in FactoryTalk Optix NetLogic when System.Speech is not supported in the project runtime? What is the recommended industrial approach? -------------------------------------------

#FT OPTIX #REPORTING

Posted By Jaykar Sep 03, 2025 06:57:00 AM
Found In Egroup: Advanced Software \ view thread
Hello Everyone, I am stuck with a project and need some help. I have 24 reports with multiple parameters, and the reports are deployed on a VM using Runtime. The client is accessing these reports through the Web Presentation Engine. Problem 1 – PDF Export Issue: When the client exports the report ...

FToptix #SQL #QUERY

Posted By Jaykar Aug 11, 2025 07:18:00 AM
Found In Egroup: Advanced Software \ view thread
Hello everyone, I am encountering a syntax error when running the following SQL query in FTOptix, although the same query executes successfully in DB SQLite: 2025-08-11 17:35:43.791;urn:FTOptix:NativeUI;0;Warning;0;Invalid SQL query "SELECT strftime('%m', "LocalTimestamp") AS Month, AVG("A_T_DBT(°C)") ...

#FT-OPTIX #REPORT #PDF-EXCEL

Posted By Jaykar Jun 27, 2025 04:11:00 AM
Found In Egroup: Advanced Software \ view thread
How can I implement functionality so that when a user generates a PDF or Excel report, a 'Save As' dialog opens-just like in a typical file download-allowing the user to choose where to save the file? I'm looking for solutions applicable to both native and web presentation.

FToptix #Runtime #System Error

Posted By Jaykar Jun 16, 2025 05:23:00 AM
Found In Egroup: Advanced Software \ view thread
I've placed my application FTOptixRuntime.exe in the Startup folder: C:\Users\Admin\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup It should auto-run on system startup, but it shows an error. When I run it manually, it works without error.

RE: FToptix #Embedded Database #Purging

Posted By Jaykar Jun 03, 2025 06:58:00 AM
Found In Egroup: Advanced Software \ view thread
I only need to keep data from the past 3 months, based on the current date. What would be the best approach for this? Should I use NetLogic, or is there any built-in functionality available?

FToptix #Embedded Database #Purging

Posted By Jaykar Jun 03, 2025 05:11:00 AM
Found In Egroup: Advanced Software \ view thread
Hello, due to limited time, I haven't been able to explore much. Can someone please suggest the best approach to apply purging to a table in an embedded database?

FToptix #Development #Security

Posted By Jaykar May 18, 2025 11:30:00 PM
Found In Egroup: Advanced Software \ view thread
I want to protect the Development section of FT Optix. How can I achieve this?

FToptix #Devlopment #Security

Posted By Jaykar Apr 28, 2025 02:30:00 AM
Found In Egroup: Advanced Software \ view thread
I want to protect the development section in FTOptix, specifically the NetLogic or any particular part of the project. My goal is to prevent unauthorized users from modifying the NetLogic code without permission. What is the best possible way to achieve this?

RE: FToptix #NetLogic #Interaction with Excel

Posted By Jaykar Apr 16, 2025 11:35:00 PM
Found In Egroup: Advanced Software \ view thread
thanks for Reply, Could you please provide a reference on how to write data to an Excel file and access specific cells?

FToptix #NetLogic #Interaction with Excel

Posted By Jaykar Apr 16, 2025 12:55:00 PM
Found In Egroup: Advanced Software \ view thread
Can we link Excel directly with OPTIX for writing value, like we do with Windows Forms?

FTOptix: Expression_Evaluator

Posted By Jaykar Apr 07, 2025 08:12:00 AM
Found In Egroup: Advanced Software \ view thread
I am trying to apply a condition where if (0) == "NULL", the value in the spin box should be set to zero (which works). However, if (0) is not "NULL", variable (1) should take the input value from the spin box. Currently, (1) is still being assigned a value of zero, even when the condition is not met." ...

RE: FToptix, ComboBox

Posted By Jaykar Apr 01, 2025 12:47:00 AM
Found In Egroup: Advanced Software \ view thread
2025-04-01 11:10:59.707;urn:FTOptix:NativeUI;0;Warning;0;Invalid SQL query "SELECT DISTINCT Recipe_Name FROM tbl_Recp_Main ORDER BY Recipe_Name": Syntax error at 16;Final_Screen/UI/NativePresentationEngine/Sessions/Session-26555c7f3d6e71782c6b4596ce410b07/UIRoot/Main_Screen1/VerticalLayout1/Horizont ...

RE: FToptix, ComboBox

Posted By Jaykar Mar 29, 2025 01:59:00 AM
Found In Egroup: Advanced Software \ view thread
Thanks @Delete for your guidance. I need to store the value of the selected item from the ComboBox as a global variable to use it in an SQL query. how can i achieve this? .

FToptix, ComboBox

Posted By Jaykar Mar 28, 2025 08:26:00 AM
Found In Egroup: Advanced Software \ view thread
I am trying to add items to a ComboBox or ListBox through NetLogic, and after that, I want to access the selected items to filter the SQL query. I have gone through the NetLogic Cheat Sheet but haven't had success. Any hints or references would be greatly appreciated!

RE: FToptix report design

Posted By Jaykar Mar 01, 2025 01:01:00 AM
Found In Egroup: Advanced Software \ view thread
may i designed sub headers in datagrid?

RE: #FToptix #Datagrid #Filter

Posted By Jaykar Nov 04, 2024 11:17:00 PM
Found In Egroup: Advanced Software \ view thread
Thanks for your response! I'm new to OptiX and still figuring things out. I understand the 4th field should be linked to the Textbox, but I'm unsure how to create the DynamicLink. Could you guide me on how to do this correctly? I've attached some pictures for context. Any help would be much app ...

RE: #FToptix #Datagrid #Filter

Posted By Jaykar Nov 04, 2024 11:12:00 PM
Found In Egroup: Advanced Software \ view thread

#FToptix #Datagrid #Filter

Posted By Jaykar Nov 04, 2024 07:36:00 AM
Found In Egroup: Advanced Software \ view thread
i have to filter a datagrid based on column name - Current load no. this is my query: SELECT * FROM (1:sql_identifier) WHERE LocalTimestamp BETWEEN (2:sql_literal) AND (3:sql_literal) and CURRENT LOAD NO = (4:sql_lietral) ORDER BY LocalTimestamp DESC how can i proceed further, i tried with ...

RE: FT Optix : Run Datalogger although FT Optix Runtime Stops

Posted By Jaykar Oct 30, 2024 12:04:00 AM
Found In Egroup: Advanced Software \ view thread
May i copy that database file in new exported runtime? I don't want to lose my previous data.