PostGreSql (PGDBE) and DC_DbNotify()
Posted: Tue Feb 14, 2023 8:08 am
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.
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.