topic-41319

Posts: 7318

Joined: Thu Oct 18, 2012 07:17 PM

FW_EXCELTODBF with tdatabase
Posted: Wed Jan 19, 2022 12:43 PM

oImport:=TImport():New()

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

give me error wich is the right command ?

Error

Code (fw): Select all Collapse

 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 )

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 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

Marc Venken

Posts: 1487

Joined: Tue Jun 14, 2016 07:51 AM

Re: FW_EXCELTODBF with tdatabase
Posted: Wed Jan 19, 2022 04:38 PM

I think that you need to have a alias active for that file.

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

Marc Venken

Using: FWH 23.08 with Harbour

Silvio.Falconi

Posts: 7318

Joined: Thu Oct 18, 2012 07:17 PM

Re: FW_EXCELTODBF with tdatabase
Posted: Thu Jan 20, 2022 08:46 AM

Now I resolve with

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

But I not Know if it is correct!!

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 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

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: FW_EXCELTODBF with tdatabase
Posted: Sun Jan 30, 2022 05:41 PM

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.

Regards

G. N. Rao.

Hyderabad, India

Otto

Posts: 6984

Joined: Fri Oct 07, 2005 07:07 PM

Re: FW_EXCELTODBF with tdatabase
Posted: Tue Feb 01, 2022 05:01 PM

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

FiveTech Support Forums

Continue the discussion