First time tDataBase user

[DonDrew]

Attempting for the first time to use database objects.

Applying the example in dbf01.prg I inserted the following 2 lines of code in my program:

USE Customer

DATABASE oDbf

It compiles cleanly but invariably returns the following error at runtime:

Error description: Error BASE/44 Assigned value is wrong class: TDATABASE:CALIAS
Args:
[ 1] = C CUSTOMER

What am I missing?

Don

[Antonio Linares]

Don,

Please run this:

USE Customer

MsgInfo( Alias() )
MsgInfo( ValType( Alias() ) )

DATABASE oDbf

What FWH version are you using ? Are you using modified FiveWin classes of your own ?

[DonDrew]

Antonio,

Msginfo(Alias()), response CUSTOMER
Msginfo(Alias()), response C

FWH v 6.12
No, I haven't modified any part of FW. With my limited skills, I'd only create serious problems.

Thanks, Don

[James Bott]

Can you compile and run dbf01.prg?

Did you possibly have the customer.dbf file already open in another program?

Also, instead of this line:

DATABASE oDBF

Try this:

oDbf := TDataBase():New()

Regards,
James

[DonDrew]

No, I haven't compiled dbf01.

oDBF := tDataBase():New() produces the same error,

Error BASE/44 Assigned value is wrong class: TDATABASE:CALIAS
Args:
[ 1] = C CUSTOMER

The only header I'm using is FiveWin.ch. Am I missing something? Should I be linking with a special LIB?

[Antonio Linares]

Don,

Please try this change in database.prg:

DATA cAlias, cFile // AS String INIT ""

and recompile database.prg, create database.obj and replace it in your fiveh.lib this way:

c:/bcc55/bin/tlib fiveh.lib -+ database.obj

[James Bott]

Don,

No, I haven't compiled dbf01.

Please try this. If it works OK, then the problem is in your code. If not, then the problem is elsewhere (compiler, linker, ch files, your code, fwh).

James

[DonDrew]

Antonio,
Changed DataBase.prg as instructed but cannot add it to FiveH.lib because my MS and Pelles librarians are reporting problems with the LIB.

I hadn't been linking FiveH.lib to my application before now so I added it to my link script. The MS linker is reporting that it's corrupt. I reinstalled FiveH.lib from my original FiveWin distribution and both librarians and the MS linker are reporting problems with it.

[Antonio Linares]

Don,

What C compiler and version are you using ?

Please post here the errors that you get, thanks

[DonDrew]

My compiler is Microsoft so I made the changes suggested by Antonio to FiveHM.lib. I then compiled a copy of dbf01.prg. Running the program with the modified FiveHM.lib the program crashed with the error:

Error description: Error BASE/44 Assigned value is wrong class: TDATABASE:BBOF
Args:
[ 1] = B {|| ... }

Stack Calls
===========
Called from: => TDATABASE:_BBOF(0)
Called from: dbf01.prg => TDATABASE:NEW(161)
Called from: dbf01.prg => CLIENTSBROWSE(182)
Called from: dbf01.prg => (b)BUILDMENU(42)
Called from: => TMENU:COMMAND(0)
Called from: => TWINDOW:COMMAND(0)
Called from: => TWINDOW:HANDLEEVENT(0)
Called from: .\source\classes\WINDOW.PRG => _FWH(0)
Called from: => WINRUN(0)
Called from: => TWINDOW:ACTIVATE(0)
Called from: dbf01.prg => MAIN(25)


I the relinked with the original version of Fivehm.lib which of course returned my original error:
Error description: Error BASE/44 Assigned value is wrong class: TDATABASE:CALIAS
Args:
[ 1] = C CUSTOMER

Stack Calls
===========
Called from: => TDATABASE:_CALIAS(0)
Called from: dbf01.prg => TDATABASE:NEW(0)
Called from: dbf01.prg => CLIENTSREC(64)
Called from: dbf01.prg => (b)BUILDMENU(39)
Called from: => TMENU:COMMAND(0)
Called from: => TWINDOW:COMMAND(0)
Called from: => TWINDOW:HANDLEEVENT(0)
Called from: .\source\classes\WINDOW.PRG => _FWH(0)
Called from: => WINRUN(0)
Called from: => TWINDOW:ACTIVATE(0)
Called from: dbf01.prg => MAIN(25)

What am I missing?

[Antonio Linares]

Don,

I already built it for you. Please download it from here:

http://code.google.com/p/harbour-and-xharbour-builds/downloads/detail?name=fivehm.lib&can=2&q=

[DonDrew]

Antonio,
Thank for for the new version of Fivehm.lib.

I linked it into dbf01.exe and my own application. Both applications simply end abruptly without any error message.

I modified dbf01.prg:

msginfo("ready to try") <-- this line works.

USE Customer

msginfo(Alias()) <-- this line works.

DATABASE oDbf // We create a DBF Object based on the current Alias
// Now we can change WorkArea and the DBF Object
// automatically access its area !

msginfo("that line worked!") <-- the program ends abruptly before executing this line.

[Antonio Linares]

Don,

Please check if there is a *.log file in the same folder where the exe is

[DonDrew]

I have the usual Make and Link logs, nothing more.

[DonDrew]

Antonio,
Could you possibly send me a copy of the modified DataBase.prg you used to create the special version of Fivehm.lib you sent me the other day?

I'd like to experiment with it on my own to see what I can learn about the tDataBase class and perhaps find the reason it's not working on my system.

Don