MySQL - MS-SQL

[TACTICA]

Hi,

I´ve created a table with a SQL QUERY that bring a lot of fields of my APP. It works fine with MS-SQL but not with MySQL. I´ve tested the query with the former control that I was using and it works fine.

The error message is : INVALID FIELD SIZE

Invalid Message error 2: List Index out of bounds.

Best Regards.

[AlexZencovich]

Hmm, as far I remeber MySQL (5?) has problem with work via ADO when type of field is char. I may suggest you to use cast it to type varchar (same size) it should solve error. Also, check if your query does not return empty dataset - it may als be problem in link MySQL + ADO

[TACTICA]

Hi Alex,

I´m working with MySQL 5.

The Fields are VARCHAR.

If i remove fields from the QUERY, it works. But it is a random behavior.

Again, it works fine with MS-SQL.

Thanks.

[AlexZencovich]

Then try to cast these varchar fields to char (fixed length) in your query. I suppose if field value like null it produce that error.

[TACTICA]

Can i send you the MySQL database and queries?

Thanks.

[AlexZencovich]

Sorry, I have no MySQL in testing now

[TACTICA]

Finally i´ve found a bug that should be fixed.

Working with MSSQL, does not matter if there´s an entire column without data, but there´s a bug in MySQL because if is there an entire column data empty it will crash the app.

Best Regards

[TACTICA]

Any news about it?

[AlexZencovich]

cast column to char (fixed width) instead of varchar in sql clause

[TACTICA]

It does not solve the problem, I have to hardcode the SQL query.

The solution that you gave in Mysql does not work neither.

Are going to fix the bug?

Thanks a lot.

Great Product I hope you can fix it.

[AlexZencovich]

I afraid there is bug in MySQL drivers not in the end product. PivotCube take field widths as is from driver. If it return 0 -we have no chance to know which actual width is.

[rocco]

instead to ADO try to use zeoslib at
http://sourceforge.net/projects/zeoslib/

[AlexZencovich]

It quite compelx for ActiveX, I think