Reported By: David Strange Reported On: 10/22/2004 For: Version 4.13 Build 1
# 1882CURRENT_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''
CommentsThe CURRENT_GUID, CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP functions were being treated as constants.
ResolutionFixed Problem on 10/23/2004 in version 4.14 build 1