Re: Problems after converting from Access to MySQL

[Peter Brawley]

> Product names are being shown as a character zero "0" instead of the value stored in the database.

An expression like ...

po.ProductName + ' (' + pr.P_Size + ' ' + pr.P_Color + ')' as ProductName

will do that because in MySQl, the + operator is strictly arithmetic. Concatenate strings with the concat() function eg ...

concat( po.ProductName, ' (', pr.P_Size, ' ', pr.P_Color, ')' ) as ProductName

> Here is the SQL query:

No, that's Visual Basic code generating the query. If the above doesn't fix the query, post the actual query generated by the VB code, along with the result of AShow Create Table for each table in tehq uery.