FW Lookup function (where to find)

FW Lookup function (where to find)

Postby Marc Venken » Sat May 02, 2020 2:42 pm

There is a FW lookup function introduced, but can't find it anymore ? Seen it ?

Now I try this (works for returning 1 field : Code )

XBROWSER "acties" TITLE "Selecteer de campagne" SETUP ( oBrw:cHeaders := { "Code", "Lijst","Titel" } ) SELECT cData := oBrw:code:Value

But I want more field as data to return (Code, Lijst, Titel)

XBROWSER "acties" TITLE "Selecteer de campagne" SETUP ( oBrw:cHeaders := { "Code", "Lijst","Titel" } ) SELECT aResult := oBrw

This is giving me all data, but inside is a lot of data from Xbrowse and have to figer out where the data is.
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1439
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: FW Lookup function (where to find)

Postby Silvio.Falconi » Sat May 02, 2020 5:07 pm

perhaps on yunus.prg
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Silvio.Falconi
 
Posts: 7070
Joined: Thu Oct 18, 2012 7:17 pm

Re: FW Lookup function (where to find)

Postby Marc Venken » Sat May 02, 2020 6:13 pm

It is

FW_DBFLOOKUP()
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1439
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: FW Lookup function (where to find)

Postby Marc Venken » Sat May 02, 2020 6:41 pm

With this code, not working because multi dim. arrays are not easy for me, I want to find all values of the selected record

Result shoud be the values of the folowing fields...

aData[1,1] = Code .or. aData[1] = code
aData[1,2] = Naam
..... rest of all the fieldnames = Value

Code: Select all  Expand view  RUN

function Testobj()
   local cText,oXmlDoc,oXmlIter,oTagActual
   local nDepth, nDone:=0, cData:=""
   local cVeld:="", aData:={}, aResult:={}


   use acties

  XBROWSER "acties" TITLE "Selecteer de campagne" SETUP ( oBrw:cHeaders := { "Code", "Lijst","Titel" } ) SELECT aResult := oBrw
  xbrowse(aResult)

  aNew := ArrTranspose( aResult )


  //aData := aNew[ 4 ]   Acols is on pos 4 in the object that I see (AResult)

// trying to look for the data
  for i = 1 to len(aNew)
     xbrowse(aNew[1,I])
  next

  close all
return

 
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1439
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: FW Lookup function (where to find)

Postby nageswaragunupudi » Sun May 03, 2020 7:33 am

SELECT aResult := { oBrw:Code:Value, oBrw:Lijst:Value, oBrw:Titel:Value }
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10646
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: FW Lookup function (where to find)

Postby Marc Venken » Sun May 03, 2020 12:09 pm

It can be so simple .... Thanks
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1439
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 44 guests