Re: [Gambas-user] Help with converting text in field to number

2009-02-02 Thread richard terry
On Tue, 3 Feb 2009 06:45:14 am werner 007 wrote: > Hello Richard > > For me it looks you want use "Group By" instead Unions in SQL to get the > Resultset like > > > xaxes-text|count|display_order > > --- > > 5-6 5 1 > > 6-7

Re: [Gambas-user] Help with converting text in field to number

2009-02-02 Thread werner 007
Hello Richard For me it looks you want use "Group By" instead Unions in SQL to get the Resultset like > xaxes-text|count|display_order > --- > 5-6 5 1 > 6-7 1002 > over 7 10 3 > And t

Re: [Gambas-user] Help with converting text in field to number

2009-01-26 Thread Doriano Blengino
Benoit Minisini ha scritto: > On lundi 26 janvier 2009, richard terry wrote: > >> As a prefix to this post all contuctive criticism of my flaws/poor logic >> etc here welcomed (with open arms!). I hope this is not too confusing, >> which it is likely to be as I don't really know what I'm doing,

Re: [Gambas-user] Help with converting text in field to number

2009-01-26 Thread Benoit Minisini
On lundi 26 janvier 2009, richard terry wrote: > As a prefix to this post all contuctive criticism of my flaws/poor logic > etc here welcomed (with open arms!). I hope this is not too confusing, > which it is likely to be as I don't really know what I'm doing, so its hard > to explain, but in essen

[Gambas-user] Help with converting text in field to number

2009-01-26 Thread richard terry
As a prefix to this post all contuctive criticism of my flaws/poor logic etc here welcomed (with open arms!). I hope this is not too confusing, which it is likely to be as I don't really know what I'm doing, so its hard to explain, but in essence: I've a table containing my lab results which is