PostGreSql (PGDBE) and DC_DbNotify()

[rdonnay]

A longtime customer, Shelstone Lorde, recently reported a problem with DC_DbNotify() when converting his application from FOXCDX to PGDBE.

The problem was due to the fact that PGDBE allows field names to be mixed case, whereas FOXCDX only saves and reports field names in upper case.

To fix this problem, a small change needs to be made to _DCFUNCT.PRG.

Code: Select all

At line 6267 (build 268) of _DCFUNCT.PRG, make the following change:

Was:       IF !Empty(aUpdateFields) .AND. Ascan(aUpdateFields,aFields[i,1]) == 0

Is:        IF !Empty(aUpdateFields) .AND. Ascan(aUpdateFields,{|c|Upper(c)==Upper(aFields[i,1])}) == 0

Rebuild DCLIPX.DLL by running BUILD20.BAT file.