FW_EXCELTODBF with tdatabase

FW_EXCELTODBF with tdatabase

Postby Silvio.Falconi » 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: Select all  Expand view  RUN
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 November 2023 - January 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
Silvio.Falconi
 
Posts: 7072
Joined: Thu Oct 18, 2012 7:17 pm

Re: FW_EXCELTODBF with tdatabase

Postby Marc Venken » Wed Jan 19, 2022 4: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.04 with Harbour
User avatar
Marc Venken
 
Posts: 1442
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: FW_EXCELTODBF with tdatabase

Postby Silvio.Falconi » Thu Jan 20, 2022 8: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 November 2023 - January 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
Silvio.Falconi
 
Posts: 7072
Joined: Thu Oct 18, 2012 7:17 pm

Re: FW_EXCELTODBF with tdatabase

Postby nageswaragunupudi » Sun Jan 30, 2022 5: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
User avatar
nageswaragunupudi
 
Posts: 10646
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: FW_EXCELTODBF with tdatabase

Postby Otto » Tue Feb 01, 2022 5: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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6342
Joined: Fri Oct 07, 2005 7:07 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 52 guests