Hi,

For some mysterious reason, the query generator truncates certain columns names as if it does not like the column name.

For instance, if I write a query like this against my table:

SELECT DELTA_SYSIBMADM_SNAPDB.ROWS_DELETED
FROM DELTA_SYSIBMADM_SNAPDB

I can see the sample data as I am building the wpDataTable but when I try to actually create the table, I get an error message.  The query that gets submitted to mySQL is changed to 

SELECT DELTA_SYSIBMADM_SNAPDB.ROWS_D
FROM DELTA_SYSIBMADM_SNAPDB

The generator just chopped off a part of the column name.

But it doesn't do that with certain other column names like ROWS_READ.

Any idea why this is happening?

Many thanks.

Thank you Milan, as always very helpful, and makes sense.

I would be very grateful if you can send me a list of the dangerous keywords that I should stay away.  And you can close this ticket.

Thanks...Ali 

Just left a 5-star review and mentioned your name.

Cheers...Ali