FiveTech Software tech support forums

... or procedures in your Mod Harbour code. Data Handling and Business Logic: Mod Harbour can interact with various data storage solutions, including relational databases (e.g., MySQL, PostgreSQL) and NoSQL databases. You'll write the necessary code to handle data retrieval, storage, and business ...

You need to use relational databases like this:

ITEMS.DBF
ITEMID <---primary key (auto incrementing)
DESCRIPTION
CATAGORYID
BRANDID

CATAGORY.DBF
CATAGORYID <--- primary key (auto incrementing)
CATAGORYNAME

BRAND.DBF
BRANDID <--- primary key (auto incrementing)
BRANDNAME

... 50 * 2,500 = 125,000, Wow! And that is just for one parent! Creating an Excel file containing all that data is extremely inefficient. That is why relational databases were born. If it was my client, the first thing I would be asking is what are you trying to accomplish with this? It seems it would ...

... 50 * 2,500 = 125,000, Wow! And that is just for one parent! Creating an Excel file containing all that data is extremely inefficient. That is why relational databases were born. If it was my client, the first thing I would be asking is what are you trying to accomplish with this? It seems it would ...

... key, unique) CUSTNO RESERVITEMS.DBF FIELDS: (Multiple items per RESERVNO) RESERVNO (primary key, unique) ITEMNNO Did you read the document about relational databases that I provided a link to in another response to one of your questions? You really need to if you haven't. Using relational databases ...

... is already in the archive? This is a classic problem when you are not using unique primary-keys. Primary-keys are one of the basic principles of relational-database programming. Another principle is to store each piece of data, only once. In the real-world, you are going find duplicate names--people, ...

... customer code, for example Falconi Silvio is the customer with code 0005 and topolino, pluto, and minni are Silvio's guests. You talk to me about relational brooms but I've never done it and for me it's a difficult thing. in the single user version I simply did: SELECT PA PA -> (DbSetOrder ...

... https://fivetechsoft.github.io/screenshots/ORM.png In a few words, ORM it is a set of classes to greatly simplify the use of SQL relational DataBases. An example is worth a thousand words: function Main()   local oUsers := Users():New( "www.fivetechsoft.com:3306",;  ...

... for any kind of ID if that is what you are doing. Recno()'s can change so you can't use them as an ID. ID's must never change. Again refer to the Relational Database Design article (link in my previous message) for more info about primary keys. Ok, it just came to me that you are saying when using ...

Silvio, I don't know how familiar you are with relational database design, but this is the number one rule: First Normal Form (1NF): A table is 1NF if every cell contains a single value, not a list of values. This property is known as atomic. 1NF ...

It's an interesting question, the dbf in my opinion are already obsolete. Migrating to a relational bbdd (SQL) is the minimum for these times since they allow us to be online permanently and from anywhere, as well as interacting with other applications (web or desktop). ...

... and expose entities abstracting their attributes and relations. OOP is a much wider concept, applied to everything. From Wikipedia: Object-relational mapping https://en.wikipedia.org/wiki/Object-relational_mapping Object-relational mapping (ORM, O/RM, and O/R mapping tool) in computer science ...

José Luis Sánchez wrote:As far as I know there is an ORM for Harbour at https://github.com/tfonrouge/oordb

No, it is not an ORM, it is a Object Oriented Relational Database. Its model is closer to an Active Record pattern than an ORM.

Regards

Hi Marcelo maybe we can see to far and think in ORM https://en.wikipedia.org/wiki/Object-relational_mapping ORM are a very elegant solution followed widely in almost every modern programming language. The most important concept behind is that it separates the persistency layer from the d...

Hola, maybe we can see to far and think in ORM https://en.wikipedia.org/wiki/Object-relational_mapping an idea only regards Marcelo Vía Hello Marcelo, I'm using your TRecord class and works fine for me. Do you have any other classes like a simple ORM and want to share them ? Regards,