Page 1 of 1

FW_EXCELTODBF with tdatabase

Posted: Wed Jan 19, 2022 12:43 pm
by Silvio.Falconi
oImport:=TImport():New()

IF FW_ExcelToDBF( oRange, nil, .t. )
lreturn :=.t.
ENDIF


give me error wich is the right command ?

Error

Code: Select all | Expand

Error occurred at: 19-01-2022, 13:39:00
   Error description: Error DBCMD/2001  Workarea non in use: DBINFO

Stack Calls
===========
   Called from:  => DBINFO( 0 )
   Called from: .\source\function\DBFFUNC2.PRG => FW_EXCELTODBF( 261 )
   Called from: Source\test.prg => CONVERTI_ORARIO( 117 )
   Called from: Source\test.prg => MAIN( 29 )

Re: FW_EXCELTODBF with tdatabase

Posted: Wed Jan 19, 2022 4:38 pm
by Marc Venken
I think that you need to have a alias active for that file.

select DBINFO // target for the exeltodbf
FW_ExcelToDBF( oRange, nil, .t. )

Re: FW_EXCELTODBF with tdatabase

Posted: Thu Jan 20, 2022 8:46 am
by Silvio.Falconi
Now I resolve with

IF oImport:ExcelToDBF( oRange, nil, .t. )
lreturn :=.t.
ENDIF

But I not Know if it is correct!!

Re: FW_EXCELTODBF with tdatabase

Posted: Sun Jan 30, 2022 5:41 pm
by nageswaragunupudi
Silvio.Falconi wrote:Now I resolve with

IF oImport:ExcelToDBF( oRange, nil, .t. )
lreturn :=.t.
ENDIF

But I not Know if it is correct!!


Correct.

Re: FW_EXCELTODBF with tdatabase

Posted: Tue Feb 01, 2022 5:01 pm
by Otto
Dear Mr. Rao,
Is there a standalone example.
If yes, are these functions working with mod harbour.
I think a mod harbour sample which uses EXCEL as a "small database" would be great.
Best regards,
Otto