Barnett, Declare your connection as Public in Form1 (or in a module) and then refer to it from any other form as Form1.MyConnection. In your Project/Properties/Options you may need to ensure that "Module Symbols" and "Form Controls" are set to public. Regards Mike
On 23/11/10 14:47, Barnett Winton wrote: > Hi all, > > Could someone outline the steps required when calling a form with > Datasource ( table specified) from a parent form. > > I am using Gambas 2.20 and sqlite3. OS is PCLinuxOS 2010. > > Form 1 provides for table selection and then calls a table specific Form > ( Form 2) > > As there is no specific DB Connection info in Form 2, when Form 2 is > called ( FModesEntry.Showmodal ) I get a DB error message from Form 1 > saying "unknown table :" for the selected table. > > The example DB app passes the DB connection and the Result object ( > which contains the table records ) to a second form which is a Viewing Form. > > I want to set up the DB connection so I can access the table in a second > form. > > I am guessing that the DB connection needs to be set up in Form 1, but > How ??????. > > Regards, > Barnett Winton > > ------------------------------------------------------------------------------ > Increase Visibility of Your 3D Game App& Earn a Chance To Win $500! > Tap into the largest installed PC base& get more eyes on your game by > optimizing for Intel(R) Graphics Technology. Get started today with the > Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. > http://p.sf.net/sfu/intelisp-dev2dev > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > ------------------------------------------------------------------------------ Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! Tap into the largest installed PC base & get more eyes on your game by optimizing for Intel(R) Graphics Technology. Get started today with the Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. http://p.sf.net/sfu/intelisp-dev2dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user