Re: auto increment

Author: Gérard Lochon

Posted: 2012-09-05 at 06:05:41

> Gerard,

> That is true for ALL the data not just the pointer table so that isn't an

> issue when DBF's are used because the whole of the DBF structure > is

> available to change as long as the user has access rights.

Yes indeed, that's the genetic lack of open systems, but i wanted to

especially point that because in only one operation you can make a lot of

desagrements in many tables ; multiples accesses to each dbf to modify them

needs a longer time and maybe is easier to trace back.

> Normally a "$ Share is sufficient to hide the data away from potential

> prying eyes on server hosted hardware. In any case, ALL data is

> available for hacking if one has the relevant expertise.

> My point in identifying this method was to indicate that there is a simple

> Multi-User alternative to using Autoincrement which is robust and

> reliable.

You know, my mind is always wondering when i see asks and further

discussions about that problem ; because it is not new,

and through dozens of years still the same old chats are remaining, as

algorithmic solutions have been found long time ago.

So, sometimes it becomes boring.

So that, so what ? It looks like a psychotic fix about this point, but what

about the multi-user update of a "normal" value, like a stock value ?

That is the same game.

In earlier 70's, when neither RDBS nor L4G existed, we had, using procedural

languages (as COBOL) to respond to the same questions.

And we did it. It is curious that this knowlegde basis can't be transmitted

trough generations of valorous programmers ...

> The only really secure way of hiding your data is not to put it in DBF's

> in the first place but to put it into a SQL container like M$SQL or >

> MySQL etc.

IMO, the only really secure way is to fully understand the underlying

mechanisms, and practise, practise ...

MSSQL is not written in MSSQL language, nor MySql is written in MySql

language.

They are written in low-level language, the same ones that we used long ago.

Presentation and application layers have obscured minds.

Gérard.

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/02ED87C28F7548F19B3B421B39CF4311@MuriellePC

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2012 Gérard Lochon