I am porting all my vb.net apps to gambas and I am very happy with the results, particularly the gb.db component. However it does have some limitations: 1. I need to determine the type of database columns using irsData.Fields[intCounter].Type. This works fine for strings, floats, integers and dates but many MySql data types such as 'Decimal' are seen as db.String(9). 2. I thought I would test if it was really a string by using the ResultField.Length property which should return zero for non-strings but it returned 19 for a Decimal(18,0) field in my database.
I overcame the problem by changing all my MySql decimal fields to floats and it works fine. However there may be other MySql types which I have not tested and which may have a similar problem. Are there any plans to update gb.db to handle the many data types now available in most databases? Regards Mike ------------------------------------------------------------------------------ Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user