Skip to Content
0
Jun 14, 2020 at 03:50 PM

Change table name in From clause of SQL query run time

83 Views Last edit Jun 18, 2020 at 01:05 PM 2 rev

Hi,

I am using Crystal report 16 and want to update table name in SQL query I received from rpt file through code. Please suggest how can I edit From clause in SQL statement?

I am aware about SetSQLCommandTable() but in my code, I am updating the where clause through recordselctionformula(), So I believe I have to provide complete SQL Query(along with Select, From where) in SetSQLCommandTable() argument if I want to use it. Another problem is that If query use join then I can use this function.