Jump to content


Photo

SQL DYNAMIC not wokring correctly


No replies to this topic

#1 Rob Donovan

Rob Donovan

    rob@proivrc.com

  • Admin
  • 1,640 posts
  • Gender:Male
  • Location:Spain

Posted 16 November 2003 - 03:56 AM

Track ID: BUG00004
Kernel Version: 5.0r109
Platform: Any

Fixed in: 5.5r308

When using the SQL DYNAMIC logic command.

If you call an LS that uses this, and then change the where statement and call the LS again, then ProIV does not send the new SQL to Oracle, it sends the original.

To get around this, you can set REPARSE=Y in the pro4.ini file, but this makes all SQL take about twice as long.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users