FiveTech Software tech support forums

This is supported by C compilers, but I guess it is a quite unknown feature: A single #name stringify the name A double ## joins two names function Main()   MsgInfo( Test() )return nil #pragma BEGINDUMP#include <hbapi.h>#include <stdio.h>#define MEMBER(TYPE,NAME,MORE) ...

... los campos con la abreviatura de la tabla, sucede que los campos que quedan editables son los de la tabla del select, pero todas las tablas de los joins, sus campos no se pueden editar. Si pongo el nombre de la tabla punto el nombre del campo entre comillas, el campo no se muestra pero permite ...

... (sum, i) {         return sum + i        }, 0)  Other: how it joins to show: Total: 25 function firstFormatter() {            return 'Total:'  data.length    ...

Mr. Rao,

This is great approach.. I did it with JOINS too.. I thought of On-The-Fly oChild when parent root expanded.. But maybe not a good idea?

I always referenced your sample relative to xBrowse.. Absolutely very helpful.

... rowsets. Open a single rowset with an sql statement joining all the tables. This is a simple example. In real situation, you can nest the joins to the desired level. function TestTree2()   local oCn   local cSql, oRs, oDlg, oFont, oBrw   oCn   ...

... is only one library, i.e., FWH MariaDB library that supports all operations Append, Modify and Delete of data in the main table of a query with joins also very smoothly. These operations work just like they work with a single table query. We can modify the joining field and we see a refreshed ...

... positioned on the previous record with the same primary key. - Method ReSync() Fix: Resync() was failing on some rare cases, where table contained joins, fields with the same name exist in more than one table and the alias used for base table is the same as the name of the table. Now fixed. * Enhancement: ...

... do not need to do anything. Do I have to look for info in the FW docs, or in the SQL docs ? SQL docs. But you can find plenty of examples using JOINs in fwh\samples and also many postings on this forum

... failed in achieving his objective. He thought he was smart but the RowSet object is smarter. This UI program knows all about the table, structure, joins, primary keys, unique keys and everything, which he did not want to reveal. So what should the DB programmer do? Continued ........

... well: http://www.w3schools.com/sql/sql_join.asp http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins Hope I am helping, Regards, Antonino Perricone

... to manage SQL.. and creating separate recordsets based on the primary key and the foreign key or a single recordset based on inner and outer joins.. not necessarily like we used to with .Dbf. I am watching this thread with interest. Rick Lipkin Rick, Could you share code for creating separate ...

... to manage SQL.. and creating separate recordsets based on the primary key and the foreign key or a single recordset based on inner and outer joins.. not necessarily like we used to with .Dbf. I am watching this thread with interest. Rick Lipkin

... have problems with the queries. Which problems ? IMHO Its seems what same field for all tables is a more clear solution. (hbrecno) Problem with joins. In a join you can't have field with same name from different tables so you have to use AS clause. EMG

Con respecto al tema los joins es lo que más aprovechamos del servidor, yo tengo tablas de mas de 1000000 de registros con consultas complejas y funciona extremadamente rapido, tener campos repetidos es util para los reportes.


Slds