Search found 31 matches: incremented

Return to advanced search

Re: Consulta sobre MySql y autoincrement

... next record: INSERT INTO mytable ID,..... VALUES ( 101, .... ) New record will be inserted with value of 101 for ID and subsequent inserts will be incremented from 101 onwards. Hope I am clear.
by nageswaragunupudi
Fri Sep 03, 2021 5:04 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Consulta sobre MySql y autoincrement
Replies: 6
Views: 709

Re: Program techniques : change indexorder or use aliases

... ) ) --> nAge of ID 108 CUSTOMER->( FW_DBFLOOKUP( 99, "ID", "FIELD->SALARY += 100" ) ) --> Salary field is incremented and written to table and returns the value ITEMS->( FW_DBLOOKUP( 101, "ITEMCODE", { || FIELD->QTY -= nOldQty } ) ITEMS->( ...
by Marc Venken
Wed Nov 04, 2020 11:30 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Program techniques : change indexorder or use aliases
Replies: 4
Views: 652

Re: to Nages: test for tdatabase

... sequence numbers. All this logic is no more required if we use AutoIncrement fields. Here is the important difference: You are fetching the incremented value at the time of appending the record. Here we are required to fetch the incremented value in advance and display it in the Append Dialog ...
by nageswaragunupudi
Sat Apr 27, 2019 6:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: to Nages: test for tdatabase
Replies: 37
Views: 5620

Re: MariaDB doubt about field

Hi Mr. Rao,

Everytime press + and cancel button id is incremented by 1. Is there any solution to increment when press cancel button?

Thanks.
by Horizon
Mon Mar 11, 2019 7:30 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB doubt about field
Replies: 13
Views: 1827

Re: Autoincrement field for DBFCDX

... me ) decided to use a PK that was an auto Increment .. all the attacker needed to do is add records to tables ( inject ) and since the PK was auto incremented, there was nothing to stop the creation of new rows. If the PK were code driven .. meaning the PK was created by the developers code .. ...
by Enrico Maria Giordano
Sat Mar 24, 2018 5:35 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Autoincrement field for DBFCDX
Replies: 9
Views: 1745

Re: Autoincrement field for DBFCDX

... me ) decided to use a PK that was an auto Increment .. all the attacker needed to do is add records to tables ( inject ) and since the PK was auto incremented, there was nothing to stop the creation of new rows. If the PK were code driven .. meaning the PK was created by the developers code .. ...
by Rick Lipkin
Sat Mar 24, 2018 4:12 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Autoincrement field for DBFCDX
Replies: 9
Views: 1745

New FTDN September/Septiembre 2017 (FWH 17.09)

... ) ) --> nAge of ID 108 CUSTOMER->( FW_DBFLOOKUP( 99, "ID", "FIELD->SALARY += 100" ) ) --> Salary field is incremented and written to table and returns the value ITEMS->( FW_DBLOOKUP( 101, "ITEMCODE", { || FIELD->QTY -= nOldQty } ) ITEMS->( ...
by Antonio Linares
Wed Oct 04, 2017 7:43 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN September/Septiembre 2017 (FWH 17.09)
Replies: 3
Views: 3309

Re: OFnt:END() generating logfile

...   oFont:End()   Enddo  Mr Cristobal This is not a case of under release of fonts. This is a case where a font is released more than it is incremented.
by nageswaragunupudi
Tue May 23, 2017 1:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: OFnt:END() generating logfile
Replies: 11
Views: 1995

Re: Print-preview with different results ?

... Notice placement is a calculation of the printer nHorzRez() and nVertRez() ( which it appears you are doing ) .. also Line spacing is incremented or de-incremented by the font:nHeight .. not very pretty, but it works with just about any printer and places your text and pictures in ...
by Rick Lipkin
Mon May 30, 2016 3:01 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Print-preview with different results ?
Replies: 10
Views: 3115

Re: DBF to SQL converter program

... being renumbered)?   No, it is totally different than an auto-increment field. Yes, every time you update the record the rowversion field is auto-incremented. Let's say you have a sequences table (as you do) where you store sequences for each field of each table that is to be sequentially incremented. ...
by reinaldocrespo
Tue Aug 25, 2015 7:17 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL converter program
Replies: 59
Views: 17901

Re: ADO and Lock

... guarantee no one else has changed the field on a race condition. Just like auto-inc fields rowversion fields are maintained by the SQL engine and incremented anytime a record is updated. Here is the code which explains itself a lot better than words: //-------------------------------------------------//DECLARE ...
by reinaldocrespo
Mon Aug 24, 2015 7:57 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO and Lock
Replies: 27
Views: 6525

Re: DBF to SQL converter program

... all the fieldnames just so I could use Hungarian notation. I would change any that were necessary to avoid reserved word issues. As far as auto-incremented primary-key fields go--they worry me. Since as Reinaldo pointed out, they can get renumbered under several situations which could make your ...
by James Bott
Fri Aug 21, 2015 5:18 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL converter program
Replies: 59
Views: 17901

Re: ADO and Lock

... do not make good invoice numbers. If you ever merge data, replicate, res-structure, move records, you will not have any control over these auto-incremented values and they may reset creating havoc with child-relationships. If you still prefer to use auto-increment field as invoice numbers here ...
by reinaldocrespo
Wed Aug 05, 2015 2:11 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO and Lock
Replies: 27
Views: 6525

Re: Fuente sin destruir

... care of releasing this font and there should be no problem. When we assign a font to header or footer or data, the font object's counter is not incremented. So xbrowse does not need to destroy the font.
by nageswaragunupudi
Sat Mar 14, 2015 7:46 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Fuente sin destruir
Replies: 10
Views: 1304

Re: Strange Font Problem in fwh 1412

... we are not creating a totally new object with totally new :hFont. This function actually returns the same object with its internal counter :nCount incremented. Actually, the internal method :Modify() achieves the same effect. oClone := Clone_Font( oArial ) // your method is exactly same as oClone ...
by nageswaragunupudi
Wed Jan 28, 2015 1:24 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Strange Font Problem in fwh 1412
Replies: 18
Views: 3907
Next

Return to advanced search