Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: prasanna kunder
  Where is prasanna kunder?
 prasanna kunder
 To: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Stefan Wuebbe
Subject: RE: mysql(7)
Thread ID: 373378 Message ID: 373504 # Views: 27 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 5:36:11 PM         

> >
> > ok, sir
> > if i have 3 table with in one form
> > then i need 3 CA instances
> I believe I had understood that part already, and the previous description attempt is what I thought might help.
> So I'm a little helpless now because I do not know whether
> the previous description was not well written so that it's not understandable,
> or the approach is somehow different from something you have in mind and did no tell yet,
> or whether certain details are not clear and if so what details,
> or something else?
> As a reworded attempt:
> if you are used to use DBF table aliases, perhaps being visually added to a Form.DataEnvironment,
> then you would add one alias or DE.Cursor object per table to the DataEnvironment.
> And each alias would have its own properties, like alias name, linked DBF table (CursorSource) and so on.
> Whereas what you would not do is using only one alias for all tables.
> Same with your CursorAdapters: you would use one CA per table, so that each one would represent the table, be the "CustomersTable" or "InfoTable" object so to say.
> Hence each CA instance would have the appropriate properties content being set, like caCustomers.SelectCmd for instance.
> Any problems so far?
> Now where do those "CustomerCursorAdpater" or "InfoCursorAdpater" come from?
> They would probably be in a "Class Library" (VCX) that you created yourself in the Project Manager's "Classes" tab.
> The library, or libraries, would contain the classes that you created as described previously or using a "builder" approach as described by Marc and Bernard.
> Where do you drop them?
> You can drop them on any "container" object, like a Form, Container.
> What I usually do is using custom "myDataEnvironment" classes that provide some reusable "parent" functionality, like connection handle(s), Update() and Revert() methods that would cascade each members.Update() (within a Transaction) or Revert() or whatever() methods, stuff like that
> hth
> -Stefan

Realy Helpful

sir, previously i always play with Databases or individual table
for next project i am trying to use back-end mysql + vfp

my mind is set for dbf, so i have lot of question

sir , if you have a time for me
please explain more, it's very appreciate

thanks in advance


mysql(7) Posted by prasanna kunder @ 3/21/2013 7:58:37 PM
RE: mysql(7) Posted by Stefan Wuebbe @ 3/21/2013 11:51:03 PM
RE: mysql(7) Posted by prasanna kunder @ 3/22/2013 6:43:14 AM
RE: mysql(7) Posted by prasanna kunder @ 3/22/2013 6:50:40 AM
RE: mysql(7) Posted by Stefan Wuebbe @ 3/22/2013 7:26:13 AM
RE: mysql(7) Posted by prasanna kunder @ 3/22/2013 3:03:29 PM
RE: mysql(7) Posted by Stefan Wuebbe @ 3/22/2013 4:00:32 PM
RE: mysql(7) Posted by prasanna kunder @ 3/22/2013 5:36:11 PM
RE: mysql(7) Posted by Om Rajan @ 3/22/2013 7:50:28 PM