On Mon, 2010-03-01 at 23:36 +0100, Charlie Reinl wrote: > Am Montag, den 01.03.2010, 16:22 -0500 schrieb Keith Clark: > > I am trying to access some data using the documentation "A Beginner's > > Guide to Gambas" and I've gotten this far: > > > > PUBLIC SUB SearchButton_Click() > > > > DIM $Query AS String > > DIM $Result AS Result > > DIM iIndex AS Integer > > DIM hField AS ResultField > > > > DatabaseConnection.Connect() > > > > $Query = "select products.products_model as ISBN, > > products_description.products_name AS Title, > > manufacturers.manufacturers_name AS Author, > > categories_description.categories_name AS Genre, > > products.products_quantity AS Quantity FROM products Left join > > products_description on products.products_id = > > products_description.products_id Left join manufacturers on > > products.manufacturers_id = manufacturers.manufacturers_id Left join > > products_to_categories on products.products_id = > > products_to_categories.products_id Left join categories_description on > > products_to_categories.categories_id = > > categories_description.categories_id where > > products_description.products_name LIKE '%blue%'" > > $Result = DatabaseConnection.$Con.Exec($Query) > > TitleSearchTableView.Rows.count = 0 > > TitleSearchTableView.Columns.Count = $Result.Fields.Count > > FOR EACH hField IN $Result.Fields > > WITH hField > > TitleSearchTableView.Columns[iIndex].Text = .Name > > TitleSearchTableView.Columns[iIndex].Width = > > WidthFromType(TitleSearchTableView, .Type, .Length, .Name) > > END WITH > > INC iIndex > > NEXT > > > > But I get an error: > > > > Unknown identifier: WidthFromType > > > > Not sure what I'm doing wrong here. Maybe just not understanding it > > well enough yet. > > > > Keith > > Salut Keith, > > you have to look for the function "WidthFromType" which returns the > width for the field. Should be in the example. > If you can't find it, a workaround could be this: > replace : TitleSearchTableView.Columns[iIndex].Width = > WidthFromType(TitleSearchTableView, .Type, .Length, .Name) > by > TitleSearchTableView.Columns[iIndex].Width = 50 > > Or/and look if you don't have a typo !? > Charlie,
Thanks! Got it. Still other issues with it but I'm afraid I'm burned out with learning for today! Keith ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
