Search found 34 matches: dbrecordinfo

Return to advanced search

Re: Can FW also read a intire online webshop ?

cFilter will look like this --->> 'DASSY' $ UPPER( DBRECORDINFO( 9 ) ) .AND. 'BARI' $ UPPER( DBRECORDINFO( 9 ) ) What is DBRECORDINFO(9) doing ? Looking into all field :?: :?: This is the full record as a string. You are in the right direction. ...
by nageswaragunupudi
Thu Mar 18, 2021 11:52 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Can FW also read a intire online webshop ?
Replies: 14
Views: 1686

Re: Can FW also read a intire online webshop ?

... below and see that this is the string that is build up when typing words in Xbrowse cFilter will look like this --->> 'DASSY' $ UPPER( DBRECORDINFO( 9 ) ) .AND. 'BARI' $ UPPER( DBRECORDINFO( 9 ) ) What is DBRECORDINFO(9) doing ? Looking into all field :?: :?: What I finaly would like ...
by Marc Venken
Thu Mar 18, 2021 9:53 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Can FW also read a intire online webshop ?
Replies: 14
Views: 1686

Re: urgent bugs lastest FWH and SQLRDD

Hello, Thanks for your quick reply. DbInfo( DBI_ISFLOCK ) does work in SQLRDD. But not DbRecordInfo( DBRI_LOCKED, RECNO() ) ) This was working savedbf() method in FW 14.14, that worked great: METHOD SaveDBF() CLASS TDataRow   local n, nCols   ...
by MOISES
Tue Dec 31, 2019 8:10 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: urgent bugs lastest FWH and SQLRDD
Replies: 12
Views: 2972

Re: urgent bugs lastest FWH and SQLRDD

- In datarow.prg, method savedbf(), at line 1332: Code: if !( DbInfo( DBI_ISFLOCK ) .or. DbRecordInfo( DBRI_LOCKED, RECNO() ) ) It is not supported by SQLRDD. Then, how to know if the record or file is already locked? - In xbrowse, vertical scroll bar does not work. ...
by nageswaragunupudi
Tue Dec 31, 2019 2:32 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: urgent bugs lastest FWH and SQLRDD
Replies: 12
Views: 2972

Re: funciones de FWH y Harbour en un archivo .txt

... DBPack()->Nil DBRecall()->Nil DBRecordInfo(<nDefine>,[<nRecord>],[<xNewSetting>])->xOldSetting DBReindex()->Nil DBRelation(<nRelation>)->cLinkExp ...
by carlos vargas
Sat Oct 21, 2017 8:44 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: funciones de FWH y Harbour en un archivo .txt
Replies: 7
Views: 5627

Re: funciones de FWH y Harbour en un archivo .txt

... DBEval DBExists DBF DBFieldInfo DBFileGet DBFilePut DBFilter DBFSize DBGoBottom DBGoTo DBGoTop DBInfo DBJoin DBList DBOrderInfo DBPack DBRecall DBRecordInfo DBReindex DBRelation dbRename DBRLock DBRLockList DBRSelect DBRUnlock DBSeek DBSelectArea DBSetDriver DBSetFilter DBSetIndex DBSetOrder ...
by carlos vargas
Sat Oct 21, 2017 8:43 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: funciones de FWH y Harbour en un archivo .txt
Replies: 7
Views: 5627

Re: Harbour-32.dll

EXPORTS HB_FUN_AADD @1 HB_FUN_ABS @2 HB_FUN_ACCELERATO @3 HB_FUN_ACCELERATOR @4 HB_FUN_ACHOICE @5 HB_FUN_ACLONE @6 HB_FUN_ACOPY @7 HB_FUN_ADEL @8 HB_FUN_ADIR @9 HB_FUN_AEVAL @10 HB_FUN_AFIELDS @11 HB_FUN_AFILL @12 HB_FUN_AINS @13 HB_FUN_ALERT @14 HB_FUN_ALIAS @15 HB_FUN_ALLTRIM @16 HB_FUN_ALTD @17 H...
by pgfdz
Fri May 29, 2015 8:06 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Harbour-32.dll
Replies: 5
Views: 2340

Re: duda ADS equivalente hb_WildMatch( '"+cWild+"', DbRecordInfo

Sí, claro que lo miré, pero no lo entendí bien, sobre todo con el uso de un Diccionario para usar las Dbfs via AIS. Todavía tengo el problema con los índices. Con AIS, INDEX ON NUMERO TO PRESUA FOR PASADO = "S" .AND. !Deleted() no me genera un .IDX sino un . CDX . No lo entiendo. En modo l...
by lucasdebeltran
Tue Mar 20, 2012 5:08 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: duda ADS equivalente hb_WildMatch( '"+cWild+"', DbRecordInfo
Replies: 10
Views: 2628

Re: duda ADS equivalente hb_WildMatch( '"+cWild+"', DbRecordInfo

Los indices FTS no son de Harbour, son de Advantage.

Revisa la ayuda del Arc de Advantage, como te dice Ruben Fernandez.
by fgondi
Tue Mar 20, 2012 3:41 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: duda ADS equivalente hb_WildMatch( '"+cWild+"', DbRecordInfo
Replies: 10
Views: 2628

Re: duda ADS equivalente hb_WildMatch( '"+cWild+"', DbRecordInfo

Lucas: en el Help del Arc de Advantage habla de los indices FTS, quizas te pueda ayudar.

Saludos
Ruben Fernandez
by RuFerSo
Tue Mar 20, 2012 1:58 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: duda ADS equivalente hb_WildMatch( '"+cWild+"', DbRecordInfo
Replies: 10
Views: 2628

Re: ADS not supports hb_WildMatch( '"+cWild+"', DbRecordInfo

Lucas, depending on the ADS version, the search in all fields by using the asterisk * is combined with the AND operator, so the chance to find suitable data sets might be very low! For example, I'm using constructs like this contains( dbtrn->Name1, "cPattern" ) OR contains( ...
by frose
Tue Mar 20, 2012 9:37 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADS not supports hb_WildMatch( '"+cWild+"', DbRecordInfo
Replies: 5
Views: 1188

Re: duda ADS equivalente hb_WildMatch( '"+cWild+"', DbRecordInfo

Hola Fernando: Muchas gracias por responder. Lo del * para todos los campos ya lo descubrí en la ayuda, pero no se cómo crear un índice FTS para todos los campos. ¿Por favor, tienes un ejemplo?. Y los índices FTS ¿son temproales o son como los .cdx?. No he conseguido encontrar información sobre índi...
by lucasdebeltran
Sun Mar 18, 2012 10:32 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: duda ADS equivalente hb_WildMatch( '"+cWild+"', DbRecordInfo
Replies: 10
Views: 2628

Re: duda ADS equivalente hb_WildMatch( '"+cWild+"', DbRecordInfo

Para usar la instrucción containsnNecesitas crear indices FTS sobre la tabla que quieras buscar.
Code: Select all  Expand view
cExpr1 := 'contains( *, "*'+UPPER( alltrim(cName) )+'*" ) '


Revisa la ayuda de ADS sobre los indices FTS. Son una maravilla.
by fgondi
Sat Mar 17, 2012 9:18 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: duda ADS equivalente hb_WildMatch( '"+cWild+"', DbRecordInfo
Replies: 10
Views: 2628

Re: ADS not supports hb_WildMatch( '"+cWild+"', DbRecordInfo

Reinaldo, Thank you very much for helping me. Yes, I at news.advantage they told be the function Contains. In a single field works very good. But not for all fields. They told me to use * AdsSetAof( "contains( *, 'text' )" ) But does not filter anything. How do you create a FTS index for a...
by lucasdebeltran
Fri Mar 16, 2012 8:35 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADS not supports hb_WildMatch( '"+cWild+"', DbRecordInfo
Replies: 5
Views: 1188
Next

Return to advanced search