FiveTech Software tech support forums

... use a GRID but under Fivewin i like to use XBROWSEr --- Fivewin does have ALL what is need but PRIMARY KEY is "identify" wrong in METHOD SavePQQ() it does work when use Fivewin Sample but not with PostgreSQL Table made by "other" like Xbase++ but what Sense make a Concept which ...

... which is used by Fivewin so Xbase++ User will ask : why use "extra" CODE when all are include in Fivewin as i can say it is METHOD SavePQQ(), which are NOT working as it use "your" Concept, which nobody seems to use it i request a Concept which IS used by Xbase++ User. ...

as i can say METHOD SavePQQ() work with Fivewin Sample but NOT with Xbase++ PostgreSQL Table as i say it is NOT a Problem of CLASS TPQServer(), it is METHOD SavePQQ() of Fivewin SavePQQ() is a method of TDataRow class of FWH. That ...

hi, as i can say METHOD SavePQQ() work with Fivewin Sample but NOT with Xbase++ PostgreSQL Table but when "nobody" is using PostgreSQL under Fivewin yet, why not change / new METHOD SavePQQ() to make it "ready" for ...

my Fivewin Version 23/07 does NOT work correct with "SavePQQ()" While we totally disagree, we suggest a totally different approach for you. For the purpose of reading, editing and saving PostGre records, please totally avoid using FWH's TDataRow. ...

... Fivewin User. but i have Problem when use PostgreSQL Table which was create by Xbase++ my Fivewin Version 23/07 does NOT work correct with "SavePQQ()" PRIMARY KEY will NOT correct recognize so WHERE does not work --- if nobody work with PostgreSQL and TPQServer() Constribution i would ...

... with PRIMARY KEY made by Xbase++ Concept of PgDBE Alaska seems to use PRIMARY KEY in "other" Way so it does not work correct with "SavePQQ()" --- i got a Workaround*** from Rao, but if "nobody" is using PostgreSQL yet we can prepare it for all Xbase++ User https://forums.fivetechsupport.com/viewtopic.php?t=43733 ...

hi, thx for Answer Please copy the method SavePQQ() to a separate function "MySavePQQ( oRec )" in your program and make the changes you need. i can use your Sample with XBROWSE and :bLDblClick for "save" ok, i will try that ...

If you want to change the logic of the method SavePQQ(), please do this way. oRec := TDataRow():New( oRs, [lAppend] )oRec:bSave := { |oRec| MySavePQQ( oRec ) }oRec:Edit() Please copy the method SavePQQ() ...

... out #ifdef and #endif in your copy and test. i do have include Copy of PGSUPORT.PRG and it work like i need p.s. have also include copy of METHOD SavePQQ() CLASS TDataRow to work with GetSerialCol() as currval() is NOT the right Way (for Alaska Concept) i have to re-write CODE for APPEND a new ...

... Way" where FIELD "ID" was add FIELD "ID" is used as PRIMARY KEY and work "autoincrement" but METHOD SavePQQ() use currval() AFTER (!) INSERT when APPEND so Fivewin Sample c:\fwh\samples\testpgre.prg FAIL when try to APPEND new Data https://i.postimg.cc/m2DKsW4m/add-Cusomer-fail.jpg ...

hi, i do understand when you say that PRIMARY KEY "can" have a.) more that 1 x FIELD b.) other than Type SERIAL but it is not the Situation i talk about --- i talk about User which want to "upgrade" from DBF to SQL and use Postgre and have no Idea how a.) xBase have RecNo() which...

nageswaragunupudi wrote:

using c:\fwh\samples\testpgre.prg i can open Table "CUSTOMER"
it work fine when "edit" but when try to APPEND it does crash
Image
it have to do with

We will get back soon with a solution

Fixed.
Please wait a little and we will send you the modified "pgsuport.prg"

using c:\fwh\samples\testpgre.prg i can open Table "CUSTOMER"
it work fine when "edit" but when try to APPEND it does crash
Image
it have to do with

We will get back soon with a solution

in multi-User Environment 2 User can APPEND "same" at "same Time" so i can´t use Information like "First+Last" as "Key" you need a PRIMARY KEY Type SERIAL where nextVal() ( NOT currval() ) is used when INSERT new Record As I said in my earlier post, it is alw...