Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to make CA work my way
Message
From
10/07/2003 18:48:46
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
How to make CA work my way
Miscellaneous
Thread ID:
00809059
Message ID:
00809059
Views:
77
I dont find a solution for a problem when using CursorAdapters that happens when I want to use a DataSource in a CA Base class.

Steps to reproduce the problem.
1) RUN Mark E. McCasland CABuilder to generate a CA Class
2) Edit the base class (_CABASE) and change the DataSource propertie to a valid handler (nID)
3) Save and close the Base CA Class
*----
4) Create a new Form and open the DataEnvironment (DE)
5) Right click and select Builder
6) In the DataEnvironment Builder Form Select the Second page from the pageframe and click on Add...
7) In the open window, select the CA class that was generated with CA Builder
8) Select any class you wish to add to the DE and click OK
9) When the CursorAdapter Builder form opens only check "Use Connection settings in builder only" and click OK
10) In the DataEnvironment Builder Form click OK
11) Drag and Drop the fields to the form and save it. ("Test_CA_x")
12) Run the code to connect to the Server and get an handle, then call the form that was saved.
* (Sample to run the form)
SET DEFAULT TO C:\test\CA1\Classes
PUBLIC nID
cStringConnect =("DRIVER={SQL Server};SERVER=BOSS700;UID=sa;PWD=sa;DATABASE=Atuante;Network=DBMSSOCN")
nID = SQLStringConnect(cStringConnect)
?nID

Do form Test_CA_x
It allways it returns this error message (the handle is > 0):
Error loading file - record number 5.  grdCrsseg1 <or one of its members>.  
ControlSource : Alias 'CRSSEG1' is not found
If I define an DSN or a connection string in the CA Builder form at the DE, it works.
But I dont want to hardcode this information in the BeforeOpenTables of the DE.
I just want to use the DataSource defined in the main CA base class.

Does someone has as Way to make it work ? I simply dont see a way to make it the way I want.

Thanks in Advance

Peter
Next
Reply
Map
View

Click here to load this message in the networking platform