FiveTech Software tech support forums

Servicomver:

A ver si este código te da más luz, puedes tener tanos JOINs como necesites


oRsCxp := FW_OpenRecordSet(oApp:oCon,"SELECT " +;
"*," +;
"PRO_NOM," +;
"PRO_DES " +;
"FROM " +;
"CarCxp " +;
"LEFT JOIN " +;
"Proveedores " +;
"ON " +;
"CAR_PRV = Proveedores.PRO_NUM " +;
"LEFT ...

Estimado Leandro:

Si en el SELECT tienes JOINs revisa que los campos del JOIN existan y tengan valor

Saludos

... procedures and triggers that allow automation of many database operations.
Advanced Query Features: SQL offers advanced features such as complex joins, subqueries, CTEs (Common Table Expressions), and aggregation functions.
6. Compatibility
Interoperability: SQL databases are widely supported and ...

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) TYPE NAME MORE ...