FiveTech Software tech support forums

... " +; "*," +; "RUB_DES," +; "CON_DES " +; "FROM " +; cTabNam + " " +; "LEFT JOIN " +; "Rubros " +; "ON " +; "WRK_RUB = Rubros.RUB_NUM " +; "LEFT JOIN " +; "Conceptos " +; ...

... PruebaArmando()Local oSql, cSqlTEXT INTO cSqlSELECT      H.*,     P.cliente,     P.direccion  FROM      HdrOdc H   LEFT JOIN      proveedores P   ON      H.HDR_PRV = P.id_codigo WHERE      YEAR(H.HDR_FDE) = '2024'   ORDER BY      H.HDR_ODCENDTEXToSql := TsTable("HdrOdc")oSql:Open(cSql)? ...

Dear Jimmy, I have reviewed the topic at https://hmgforum.com/viewtopic.php?t=7505 I have requested to join the forums so maybe we can solve it together. I have been trying to use the events and it seems as something is missing: function main()    local ...

Dear Jimmy, I have reviewed the topic at https://hmgforum.com/viewtopic.php?t=7505 I have requested to join the forums so maybe we can solve it together. I have been trying to use the events and it seems as something is missing: function main()    local oVoice ...

... := "SELECT c.*,g.detalle AS ngrupo,g.tipo,g.etapa,f.detalle AS netapa " cMsg += "FROM labores_maquina c " cMsg += "INNER JOIN labores_gruop g ON g.idgrupo=c.idgrupo " cMsg += "LEFT JOIN familia2 f ON f.idfamilia2=g.etapa " cMsg += "ORDER BY ngrupo,detalle" ...

... set table1.data1=oSvr.table1.data1 where condition I saw a sample on a mysql forum, but I can't make it work UPDATE database_a.clients A INNER JOIN database_b.clients B ON A.id = B.id SET B.email = A.email Any help will be appreciated From Chile. Adolfo

... appreciate if you can review it and check if they are fine for you: https://github.com/FiveTechSoft/forums/blob/master/posts_dbf.zip join these parts using Total Commander so you get a posts_fpt.zip https://github.com/FiveTechSoft/forums/blob/master/posts_fpt.001 https://github.com/FiveTechSoft/forums/blob/master/posts_fpt.002 ...

Hola gente, tengo una consulta con join y dbfs cSQLa := "SELECT PlanAudit.Cliente, PlanAudit.Nro_Audit, PlanAudit.Numero, Usuarios.Nombre, Usuarios.Iniciales " + ; "FROM PlanAudit INNER JOIN " + ; " Usuarios ON PlanAudit.Numero ...

... 13 a las 18.00 (hora España) session skype, en la que hablaremos con Javier de su proyecto y el recorrido que ha tenido. Canal Skype -> https://join.skype.com/cnzQg3Kr1dnk Nos vemos allá. C. Charly, gracias por el apoyo y con gusto participaré en la charla para compartir la experiencia que he ...

Hola,

Confirmado, el proximo viernes 13 a las 18.00 (hora España) session skype, en la que hablaremos con Javier de su proyecto y el recorrido que ha tenido.

Canal Skype -> https://join.skype.com/cnzQg3Kr1dnk

Nos vemos allá.

C.

José,
Colegas
Si deseas puedo apoyarles y/o capacitarles en el uso de MYSQL. Mi tel +5841430000518 jnadaptapro@gmail.com
Podemos ver:
1. Integridad referencial
2. Disparadores.
3. Vistas.
4. Sub consultas.
5. Optimización WHERE, JOIN

Lo que está creando el conflicto es el INNER JOIN: cSQL := "SELECT s.id, s.Codigo, s.Codbarra, s.Descri, s.Precio_vta, s.Cantid, s.Cantid1, s.Cantid2, s.Cantid3, s.Cantid4, s.Rubro, s.Descri1, s.Marca, s.Costo, s.Minimo, s.Lote, s.Porc_iva, ...

... Space(60) Local cSeek:="" Local oCampo, cCampo :=space(50) cTab_Art:=xServer:Query("SELECT a.*, b.*, c.* FROM tab_art AS a LEFT JOIN tab_fam AS b ON a.fam_art = b.cod_fam LEFT JOIN tab_mar AS c ON a.mar_art = c.cod_mar ORDER BY nom_art ") Define Font oFont2 Name "Tahoma" ...

... Space(60) Local cSeek:="" Local oCampo, cCampo :=space(50) cTab_Art:=xServer:Query("SELECT a.*, b.*, c.* FROM tab_art AS a LEFT JOIN tab_fam AS b ON a.fam_art = b.cod_fam LEFT JOIN tab_mar AS c ON a.mar_art = c.cod_mar ORDER BY nom_art ") Define Font oFont2 Name "Tahoma" ...

... s.Descu4, s.Ult_prov, s.moneda, s.Disconti, m.Cotiza, dbo.Proveed.Nombre, dbo.Marcas.Nombre AS nommarca " + ; "FROM dbo.Stock AS s INNER JOIN " + ; " dbo.Monedas AS m ON s.moneda = m.Descri INNER JOIN " + ; " dbo.Proveed ON s.Ult_prov = dbo.Proveed.Numero INNER JOIN ...