View Incident Report

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

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

Resolution

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap