Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How will I ever get my app ported to SQL Server?
Message
 
 
To
21/08/2008 10:54:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01338696
Message ID:
01340776
Views:
17
>I started some basic testing, and need a little help to make sure I am off to the right start here...
>
>(P.S.. I've already played with creating a DE class and separate CA classes (with Mark McCasland's CA Builder9 tool), and I plan to use that method for production, but for now, I am just experimenting in IDE mode to make sure I get the vision of this stuff, and get the basic mechanics working)
>
>
>So...
>
>I created a new form in the IDE using my base form, and I went to View->Data Environement of the form, and did right-click on the DE window area and picked Builder, then added the ODBC connection data on the Data Source tab, and then clicked on the Cursors tab, then clicked New to create a CA in the right in the forms DE. I set the "Use DataEnvironment data source" flag, and chose a table and fields from the SQL Server connection. I also gave it a Name and an Alias.
>
>So now I have a CA in the form's DE.... Next I ran the (mostly empty) form, but I got no cursor opened up in the Data Session dialog box. It is not opening the CA that I added to the DE!
>
>The only way I found to make it work is to add code in the DataEnvironment.init() method, like this: "this.Jobs.cursorfill()".
>
>So, is that the right way to open up and populate the CAs, by adding code in the init() of the DE?
>
>I guess I kindof expected it to open them since they were there.

My memory is a bit rustic, but I think there is a property like AutoOpen in CA.

I personally use slighlty different approach, I create CAs using Mark's builder, then add them in Form's Load via code and call CursorFill when I'm ready.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform