Problems with SQL DYNAMIC inV5 r109
Posted 13 February 2003 - 10:54 PM
It seems that the dynamic WHERE clause will only be evaluated once within the function. If the WHERE clause is changed and the SELECT executed again the data set is not changed and the original results are returned.
Has anyone else encountered this or EVEN come up with a work around.
Posted 14 February 2003 - 02:15 AM
This can be set as an environment variable or set in the [ENVIRONMENT] section of the pro4.ini.
Search other posts on this site for more info on dynamic SQL
Posted 17 February 2003 - 11:56 PM
I believe that in the Version 5.5 SQL interface re-write; the performance hit on the use of this variable is so negligible that it has become almost redundant. I would however recommend that it is always set if you are using DYNAMIC SQL.
Posted 19 February 2003 - 09:49 PM
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users