FiveTech Software tech support forums

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,

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

... stated, you should be using a one-to-many database for this--not adding fields to the existing database. Adding fields is a violation of the relational database design principles for the very reason that you are experiencing. Your way uses up a lot of disk space and memory because you can ...

... declarar más cosas como campos virtuales. Tengo especial predilección por esta alternativa, porque es lo que más se parece a los ORMs (objet relational mappers) que se usan en otros lenguajes. La alternativa de Quim requiere que explícitamente declares los campos, con lo que el ahorro de ...

... Nose si esto responder algo a la curiosidad, saludos... :shock: https://mariadb.com/products MariaDB is reinventing the relational database to support today’s enterprise needs from OLTP to analytics from a single SQL compliant interface. MariaDB products include the widely ...

... is the number of the child work area. <cAlias> is the alias of the child work area. <bKey> is a code block that expresses the relational expression in executable form. <cKey> is an optional string value that expresses the relational expression in textual form. If <cKey> ...

Carlos Thank you for your good suggestion .. unfortunitly I have inherited a system that has multiple relational tables and it goes something like this Bitem Table         (pk) Project_number   '27'Brevision Table     (fk) BINumber   '27.01', '27.02','27.03' ...

... the use of indexes. Ms Access has a very simple query builder where you can pick and chose your fields from tables and create a join to make a relational recordset. http://i58.tinypic.com/2uolaae.jpg http://i61.tinypic.com/51ri41.jpg Here is a simple join on ...

... use of indexes .. see bold text below. Using Sql indexes is MUCH different than in .dbf .. and I would ONLY recommend you use indexes for the relational fields. Please do not confuse 'Primary Key' with an index .. a Primary key is a unique row identifier as Carlos mentions and (generally speaking) ...

... (la unica clase que se instancia directamente en la aplicacion) -->TQuery -- Resultado no editable de las consultas -->TModel -- ORM (Object Relational Mapper) , crea instancias editables. Hace instrospección de los datos para crear los objetos con sus variables. --->TRecord Las filas ...

... Ive found this article: One of the biggest differences between traditional ADO and ADO.NET is that the rowsets stored within ADO.NET can be truly relational. For example, a DataSet can store one DataTable containing customers and another DataTable containing the customers' orders. These DataTable ...

... because the present software is 25 year old. It is also possible to avail MSSQL features like calculated columns, triggers, stored procedures, relational constraints, etc. to include most of the business logic.

... the ODBC way and start thinking the ADO way, same way as we should stop thinking the DBF way and start thinking the RDBMS way when we move to Relational Database systems.

... OData standard defines a protocol and a language structure for issuing queries and updates to remote data sources, including (but not limited to) relational databases , file systems, content management systems, and traditional web sites. It builds upon existing Web technologies, like HTTP and ...

... over the past several years. OData is being used to expose and access information from a variety of sources including, but not limited to, relational databases, file systems, content management systems and traditional Web sites. In the past, we have only weakly embraced protocals for sharing ...