Search found 180 matches: increment

Return to advanced search

Request : function GetSerialCol()

... will use      // use nextval() for Sequence !      cIns += "nextval('" + cTable + "___record_seq')" + "," to "increment" FIELD "__record" when INSERT new Record
by Jimmy
Sun Sep 24, 2023 9:20 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Request : function GetSerialCol()
Replies: 8
Views: 581

Re: need Help with oBro:bSeek

can somebody point me to working "increment" Seek :?: Incremental seek works automatically if the programmer does not do anything to disturb the automatic behavior of xbrowse. XBROWSER "any.dbf" AUTOSORT Start clicking on ...
by nageswaragunupudi
Wed Aug 16, 2023 4:59 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: need Help with oBro:bSeek
Replies: 3
Views: 215

need Help with oBro:bSeek

hi, can somebody point me to working "increment" Seek :?: Question : a.) i guess it need an Index to SEEK. *CDX seems to be open "automatic" but *.NTX must be open before ? b.) if *.CDX have TAGs, how to change TAG when click ...
by Jimmy
Tue Aug 15, 2023 1:24 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: need Help with oBro:bSeek
Replies: 3
Views: 215

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

... __lock_owner integer NOT NULL DEFAULT 0, " also PRIMARY KEY is "add" when create SQL-Table to use NextVal() "internal" to increment UNIQUE "RecNo" --- 1st. "Problem" for a xBase User are FWPG_ImportFromDBF() which use 4th Parameter as "default" ...
by Jimmy
Sun Aug 06, 2023 12:44 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 719

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

... have multiple columns also) btw. how can i make FIELD "id" as READ-ONLY when "edit" :?: You do not have to do anything. Auto-increment fields are always treated as ReadOnly both by XBrowse and DataRow.
by nageswaragunupudi
Sat Aug 05, 2023 9:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 719

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

... KEY is based on "__record"    cQuery += " CONSTRAINT " + cTable + "_pkey PRIMARY KEY (__record)" when INSERT it increment next UNIQUE number this Way   cIns += "nextval('" + cTable + "___record_seq')" + ","   --- i found in c:\fwh\source\function\pgsuport.prg ...
by Jimmy
Wed Aug 02, 2023 11:17 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 719

Re: "id" for PRIMARY KEY ?

Jimmy I create my own primary keys that way I control when a table is appended .. if you use auto increment an attacker could force an table append or "Inject" records into your tables and the database doesn't care .. the primary keys are generated automatically ...
by nageswaragunupudi
Tue Jul 25, 2023 2:10 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: "id" for PRIMARY KEY ?
Replies: 9
Views: 479

Re: "id" for PRIMARY KEY ?

Jimmy I create my own primary keys that way I control when a table is appended .. if you use auto increment an attacker could force an table append or "Inject" records into your tables and the database doesn't care .. the primary keys are generated automatically ...
by Rick Lipkin
Tue Jul 25, 2023 1:48 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: "id" for PRIMARY KEY ?
Replies: 9
Views: 479

Re: XBROWSE Column Question

hi,

FUNCTION FindColumnHeader() is NOT for "increment" Seek, it is to place Cursor on Header which meet IndexKey()

i can´t find e.g. STRZERO, in RddIncrSeek(), of XBROWSE ... but it seems to work ,,, how can it work ... hm
by Jimmy
Mon May 08, 2023 3:29 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: XBROWSE Column Question
Replies: 23
Views: 876

Re: XBROWSE : Seek(), OrdwildSeek() and "increment"

Good idea. We will try to protect some more methods/datas.
Still we can not do it for all because some methods/datas are used both by the browse object and column object.

There are lots of examples of xbrowse in the forums and lastly we are always here to support you in every way.
by nageswaragunupudi
Mon May 08, 2023 1:57 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: XBROWSE : Seek(), OrdwildSeek() and "increment"
Replies: 3
Views: 278

Re: XBROWSE : Seek(), OrdwildSeek() and "increment"

hi

thx for Anwser

i´m still a Newbie and it is hard to learn when have no Documentation or Sample CODE

what do you think to declare Method as "PROTECT" if User should not use a Method "direct<"
by Jimmy
Mon May 08, 2023 12:22 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: XBROWSE : Seek(), OrdwildSeek() and "increment"
Replies: 3
Views: 278

Re: XBROWSE : Seek(), OrdwildSeek() and "increment"

XBrowse and TDataRow (alias FW_Record) work with all kinds of datasources viz., dbf, tdatabase, ado (any rdbms), dolphin, tmysql, fw-mysql, postgre, eagle, etc. This enables the application programmer to write highly portable code. He can use exactly the same code with any of these datasources. We h...
by nageswaragunupudi
Sat May 06, 2023 12:26 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: XBROWSE : Seek(), OrdwildSeek() and "increment"
Replies: 3
Views: 278

XBROWSE : Seek(), OrdwildSeek() and "increment"

hi, how does XBROWSE "increment" Seek work ... i find no Sample for DBF does it have a "own" GET or does it use INKEY() or do i have to write my "own" Input-Box :?: --- i saw OrdWildSeek() using ::lSeekWild ...
by Jimmy
Fri May 05, 2023 7:37 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: XBROWSE : Seek(), OrdwildSeek() and "increment"
Replies: 3
Views: 278

Re: Error XBROWSE SEEK (while no Index) after change RDD

hi, Version of FWH? 22.07 Line numbers are not matching with FWH2212 xbrowse.prg, unless modified. Are you using Incremental Filter or Seek? Incremental seek works only for indexed DBF, when an index is selected. i do NOT use any Index and that OEM DBF have no *.CDX i "just" ...
by Jimmy
Tue May 02, 2023 3:43 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error XBROWSE SEEK (while no Index) after change RDD
Replies: 9
Views: 567

Error XBROWSE SEEK (while no Index) after change RDD

... nRDD - 1 )      ENDIF   ENDIF   SET DBFLOCKSCHEME TO SP_nRDDlock()RETURN what is going wrong and "why" does "increment SEEK" will be active after change RDD Settings :?:
by Jimmy
Mon May 01, 2023 2:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error XBROWSE SEEK (while no Index) after change RDD
Replies: 9
Views: 567
Next

Return to advanced search