... "states", nil, { { 0, "KK", "KState" } } ) For Upsert() to work, we need to include primary key also. My table have 20 fields, but in this part of process I need edit or insert just a few. But you can use normal Insert like this: oCn:Insert( ...
... "states", nil, { { 0, "KK", "KState" } } ) For Upsert() to work, we need to include primary key also. But you can use normal Insert like this: oCn:Insert( "states", "code,name", { { "KK", ...
... from the one on your desired subnet is not necessarily a bad configuration. Here's why: Function Behavior: GetHostByName typically returns the primary IP address associated with the hostname. This might not always be the IP address you're expecting, especially when your system has multiple ...
If the table on both the servers has exactly the same structure, same primary key and all fields in the same order: aData := oLocalServer:Execute( "select * from table [where <cond>]" // returns array of values)oRemoteServer:Upsert( ...
... flags, as seen in C:\FWH\source\function\getsysin.prg. These constants are designed to return the width and height of the client area for the primary display monitor, excluding the taskbar and other docked bars from the work area of the screen. What are your values if you move the taskbar ...
... First, clients who have the problem were not using ARM computers. I was able to see the problem using mine ( C2 below ). Computer 1 ( C1) is my primary programming computer. I am running Windows 11, 23H2. Builds are done with Harbour ( 32 & 64 ), FWH ( latest versions ), and Microsoft Visual ...
... Solution to use LibPQ.DLL. under Xbase++ / HMG is 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" ...
... it use "your" Concept, which nobody seems to use it i request a Concept which IS used by Xbase++ User. it need to get "right" PRIMARY KEY which FUNCTION GetSerialCol() does so i´m asking to "enable" existing FUNCTION GetSerialCol(), thats all
... PostGre records, please totally avoid using FWH's TDataRow. Also totally avoid using any functions of FWPGSUPPORT.PRG for reading, saving and primary keys. Instead you may directly use methods of TPQquery and TPQrow classes of Harbour's hbpgsql.lib. This is very simple. This is the way to ...
... 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 like to ask for ...
hi Natter, YES, i mean TPQServer Constribution which can be used with Fivewin i have "Problem" 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 ...
... Side of "edit" ( which make no Sense when "edit" ) :?: --- but CODE still does not work as it does not "recognize" PRIMARY KEY made by Xbase++ Concept https://i.postimg.cc/mDZ2CCW3/PG-Save02.jpg when use Alaska PgDBE PRIMARY KEY, which point to "internal" ...
... we have #ifdef UNUSEDFUNCSSTATIC function GetSerialCol can you please "enable" it i need it for PostgreSQL PRIMARY KEY of Table made by Alaska cQuery += " CONSTRAINT " + cTable + "_pkey PRIMARY KEY (__record)" it will use // use nextval() ...
... Changes?" ) oRs:SaveBatch() else oRs:CancelBatch() endifendifXBROWSER oRs It is very important that the Primary Key(s) should be included in the rowset.