FiveTech Software tech support forums

... parts. Here’s an updated version of the `Deposits()` function to show the `INVNUM` field:

```xbase
static function Deposits()
local oBrw, oChild, cClrBack, cCol
local oBar, oMsgBar, oMsgDeleted

if oWndClients == nil
Clients()
endif

if oWndItems == nil
Items()
endif

if oWndDeposits ...

... deposits.

Below is the adapted Deposits function based on the Invoices function:

xbase
Code kopieren
static function Deposits()

local oBrw, oChild, cClrBack, cCol
local oBar, oMsgBar, oMsgDeleted

if oWndClients == nil
Clients()
endif

if oWndItems == nil
Items()
endif

if oWndDeposits ...

Hola.
esto ya me esta funcionando, nada mas que no se como hago para acceder al ese campo para poder hacer esto:
WITH OBJECT :aCols[ 3 ] :cHeader := "Forma de pago" :bStrData := { || aCobros[ ::oQry:oChild:FieldGet("c4") ] } END WITH

gracias.

El problema pasaba el uso de la tabla hija, utilizando oMant:oChild:campo, funcionó perfecto.

... IF oXmlDoc:nStatus != HBXML_STATUS_OK
RETURN cRet
ENDIF

oNode := oXmlDoc:findfirst(cNodo)

If oNode != Nil
If lNodo
xmlNode := oXmlDoc:oRoot:oChild

WHILE xmlNode != NIL
cPath := xmlNode:Path()
If xmlNode:nType=5
cRet :=xmlNode:cData
Exit
EndIf
xmlNode := xmlNode:NextInTree()
ENDDO ...

Because oChild is a LOCAL variable. It is destroyed after the end of the function where it is defined.

EMG

Hello Karinha,
no mistake, I wonder why the 'oChild' variable is still defined after it's closed
thank

Hi all,
try this minimal example, why after end of MDICHILD oChild the window is already
active ?

#include "fivewin.ch"function Main()   local oWnd, oFont   local aData := { 1, 2, 3, 'Something' }   local nVar := 99, cVar := 'Hello'   local ...

... 41;, { "idfund = oRs:id" } )oRs:AddChild( oConnection:RowSet('pettycash'), { "idfund = oRs:id AND idempl = oRs:oChild:idempl" } )... 

to update:
...oRs:oChild:ReQuery({ "idfund = "+cValToChar(aValue[1]) + " AND idempl ...

I understood your point.
Let me check. I will get back to you.

Hi Masters,

I have oRs:oChild and oRs:oChild:oChild ..

but oRecA := oRs:oChild:Record(,.F.) and oRacB := oRs:oChild:oChild:Record(,.T.) was saved by oRecA:save() and oRecB:save(), the database confirms the update/appended but even with
oRs:SyncChild() or oRs:oChild:SyncChild(), or oRs:oChild:ReSync ...

fraxzi wrote:Hi Mr. Rao,

if I do oParent:Save() ... will it save oParent:oChild and oParent:oChild:oChild as well??

No.

Hi Mr. Rao,

if I do oParent:Save() ... will it save oParent:oChild and oParent:oChild:oChild as well??

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.

Hi Rao,

Strangely, I put the oRs := oCn:RowSet( cSql, {'param'} ) on my init variable function (as once-only declaration) and put oRs:Append() | oRs:SyncChild() | oBrw:Refresh()...
This way it SOLVED my issues refreshing oRs:oChild datasource of xBrowse ...

Moving forward to another task...