FiveTech Software tech support forums

Descubriendo más misterios... Si se usa SR_UseDeleteds(.F.) ANTES de la apertura con USE ( cTable ) EXCLUSIVE VIA ( cRDD ), SQLRDD crea el campo sr_deleted, si no lo tiene, de forma automática Entiendo que SR_UseDeleteds(.F.) no conserva el valor globalmente, si no se define inmediatamente ...

... DBCopyStruct(<cDatabase>,[<aFieldList>])->Nil DBCreate(<cFile>,<aStruct>,<cRDD>,[<lKeepOpen>],[<cAlias>],[<cDelimArg>],[<cCodePage>],[<nConnection>])->Nil DBCreateIndex(<cIndexName>,<cKeyExpr>,<bKeyExpr>,[<lUnique>])->Nil ...

... But I have some public variable to explain the customer (coname), module (cmodule), userid (us_name), station id (Networks), path (cPath), rdd (cRdd), contactinfo (cContInfo), EXE Verion (cEXEVerion), data path (cPath). Did you put this code into your link files or changed FW source ? I never ...

... But I have some public variable to explain the customer (coname), module (cmodule), userid (us_name), station id (Networks), path (cPath), rdd (cRdd), contactinfo (cContInfo), EXE Verion (cEXEVerion), data path (cPath). Hey Dutch, I see that you have a other 'ERRORLOG' dialog that has the posibility ...

... makes it safe. 16. CloseIndex() Closes index 17. Commit() Performs COMMIT for the Alias 18. CopyTo( cFile, aFields, bFor, bWhile, nNext, nRec, cRdd, cCp ) Executes COPY TO command 19. CreateIndex( cFile, cTag, cKey, bKey, lUnique) ( ::nArea )->( OrdCreate( cFile, cTag, cKey, bKey, lUnique ...

ZAP errors out Workaround: 1. uncommanded local cRdd := (cAlias)->(RddName()) 2. and before reopening insert cFileName := UPPER(cPath+cFileName+cExtension) ACTIVATE DIALOG oDlg CENTER SELECT (cAlias) IF lShared USE cFileName := UPPER(cPath+cFileName+cExtension) ...

... con MySql y ACCESS única pero debe wok con todos los demás.  Nueva SET ADO TABLENAME CON EL CAMINO DE ON / OFF  Nueva hb_AdoUpload (cBaseDir, CRDD, DBEngine, lOverWrite)  Nueva HB_adorddFile (cFichero) Reemplaza archivos ()  Nueva hb_ADOrddCOPYFILE (cTableOrigin, cTableDestination) Reemplaza ...

... any keyword. Tested with MySql and ACCESS only but should wok with all others. New SET ADO TABLENAME WITH PATH ON /OFF New hb_AdoUpload( cBaseDir, cRDD, dbEngine, lOverWrite ) New HB_adorddFile( cFile) Replaces File() New hb_ADOrddCOPYFILE( cTableOrigin, cTableDestination ) Replaces CopyFile() ...

Biel, The Temporary File is created on the hard disk? or in memory? In memory. James Thanks James, what is confusing me is the 3st parameter cRDD. I never used but like mentioned Carles there are Memory RDD like ArrayRDD and HB_MEMIO, if not misunderstand hb_DbCreateTemp will use one of those ...

... itself is an Alias ( not a file name ) and this Alias is the workarea. Example: cAlias := cGetNewAlias() if HB_DbCreateTemp( cAlias, aStruct, cRDD ) // do work with cAlias // ? SELECT( cArea ) is the number of the work area. CLOSE cAlias endif The Temporary File is created on the hard disk? ...

The first parameter itself is an Alias ( not a file name ) and this Alias is the workarea.

Example:
cAlias := cGetNewAlias()
if HB_DbCreateTemp( cAlias, aStruct, cRDD )
// do work with cAlias
// ? SELECT( cArea ) is the number of the work area.
CLOSE cAlias
endif

nageswaragunupudi wrote:HB_DBCreateTemp( cAlias, aStruct, cRDD ) --> lSuccess
... use cAlias like any other alias
CLOSE cAlias at the end

Hi,
I am trying to substitute temporary database file with this, how can I associate an area to it?
Regards,
Antonino

HB_DBCreateTemp( cAlias, aStruct, cRDD ) --> lSuccess
... use cAlias like any other alias
CLOSE cAlias at the end

... of the tool ) You can define fixed values ( not using the INI ) cDBF := "C:\Test\customer.dbf" cCSV := "C:\Test\customer.csv" cRDD := "DBFCDX" cEOL := "\###" cDateFmt := "yy-mm-dd" cHeader := "Yes" cMemos := "Yes" cMemoline ...

... : '")+alltrim(oApp:cSqlHs1)+iif(wfcoi=="I","', Engine : ","', Motor : ")+oApp:cEngine+" Via : "+oApp:cRdd TRANSPARENT REDEFINE GET oUsua VAR cUsua ID 110 OF oDlg PICTURE "@!" VALID !empty(cUsua) REDEFINE GET oPass VAR cPass ID 120 OF oDlg ...