FW_EXCELTODBF with tdatabase

Post Reply
User avatar
Silvio.Falconi
Posts: 7169
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 3 times

FW_EXCELTODBF with tdatabase

Post 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 )
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
User avatar
Marc Venken
Posts: 1485
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: FW_EXCELTODBF with tdatabase

Post 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. )
Marc Venken
Using: FWH 23.08 with Harbour
User avatar
Silvio.Falconi
Posts: 7169
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 3 times

Re: FW_EXCELTODBF with tdatabase

Post by Silvio.Falconi »

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
User avatar
nageswaragunupudi
Posts: 10729
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 10 times
Contact:

Re: FW_EXCELTODBF with tdatabase

Post 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.
Regards

G. N. Rao.
Hyderabad, India
User avatar
Otto
Posts: 6414
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 30 times
Been thanked: 2 times
Contact:

Re: FW_EXCELTODBF with tdatabase

Post 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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
Post Reply