main logo
Subject: Re: Locate database when testing, why?
Author: Bhavbhuti Nathwani
Posted: 2002/03/15 03:02:44
 
View Entire Thread
New Search


1) Hope there are no typos on the form like v_ written as lv_
2) Reorder the BOs and send to back the BOs
3) Remove the BO from the screen and try adding it again
4) If you are up to it delete the BO and recreate them

Hope this helps

<i><font color="#663300">Just to clarify more the error message. It says: "Error instantiating cursor object. Cannot find lv_CustomerMaint in d:devcodebookgitterdatagitterviews.dbc". It appears to be looking for a table, not a view. I think that is the crux of the problem. Now, if I could just find the crux of the solution... ;)


>Hi Bhavbhuti

I opened the aDataEnv.prg and I found the code you quoted.

Let me see if I can copy the complete snippet:

DEFINE CLASS GitterEnvironment AS iDataEnvironment
cDefaultDatabaseName = "GITTER"
cDefaultViewDatabaseName = "GITTERViews"
cDefaultLocalLocation = SYS(5) + SYS(2003) + "DATA"
cDefaultRemoteLocation = SYS(5) + SYS(2003) + "DATAREMOTE"
ENDDEFINE

Yep, there it is. Now the message I get is that it cannot locate the "lv_CustomerMaint" view after which it allows me to locate it and thereafter the program continues to work well. I also checked the names "GITTER" and "GITTERViews" in the project, and they are correct... having the the real data and the real view contained within them. I also tested the SYS() functions while having the project open, and the results were what you would expect, i.e. they point to the correct drive and directory structure... Hummm...

Maybe what I need to do is to "recompile" by running the "STARTCB.PRG" without the .T. (since the Step by Step says that the .T. need not be invoked again unless I change the directory or drive wherein the project is located. Hummm. I also notice that the table: "dbpaths.dbf" is located in two different areas, first in the root of the Gitter folder, and then again in the DBPATHS folder which is also off the root of the Gitter foler. I also notice that the size of the dbpaths.dbf in the root of Gitter is 1093 and the other one is 456, that is to say there is a significant difference between the two.

For the above reasons, I wonder where the confusion may be, in me (which is more than likely), or in the CodeBook Framework release candidate (6.2) which is the one I am using...

BTW thanks for your response, I hadn't even thought of checking for other framework related files as I was (still am) looking to resolve the issue before continuing with the Step by Step... If you have any other ideas please do send them this way... ;) I won't be doing much more detective work tonight. Best regards to you and yours!



Hi Pablo

It seems that the aDataEnv.prg is missing out the line
cDefaultViewDatabaseName = "GitterViews" as in

DEFINE CLASS GitterEnvironment AS iDataEnvironment
cDefaultDatabaseName = "Gitter"
cDefaultViewDatabaseName = "GitterViews"

Recreating with the new newapp.app should solve the problem in the future.

When testing the Gitter program (First Step 4: Test it Out) and after following only the directions to that point (no improvisations or changes from the guide), the program does not automatically locate the gitterviews database. It asks for it and when I point to the view database, the program works well.

I tried to figure out the place where the program gets the direction to have the frmCustomerMaint automatically loads the view or "data environment" but could not.

I also looked at the bizobject for the DE there, but could not decipher sufficiently.

Can someone give me some advise please? TIA
</font></i>


Regards
Bhavbhuti
 
©2002 Bhavbhuti Nathwani
<-- Prior Message New Search Next Message -->