Icon View Incident Report

Serious Serious
Reported By: David Strange
Reported On: 10/22/2004
For: Version 4.13 Build 1
# 1882 CURRENT_GUID Function Returning Same Value During SQL UPDATE Statement

I just wrote a quick test program with a 2 field table. I only wanted some records to update, so I wrote the following statement. That seems to want to update the records, but the problem is it uses the same value for CURRENT_GUID each time so I get a primary key error.

update mytable set myid=CURRENT_GUID
where details = ''a''

Comments Comments
The CURRENT_GUID, CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP functions were being treated as constants.

Resolution Resolution
Fixed Problem on 10/23/2004 in version 4.14 build 1