Cursor doesnt have correct field size for MySQL views 1

[bluesw3]

Ive tried Cursor Adapters and SQL Pass-Throughs but whenever I access an empty MySQL table my cursors field size becomes 0 not allowing me to pass any data in the standard fasion. Is this a limitaion between VFP and MySQL?

 

[rgbean]

Have you looked at Mark McCasland's free CA Builder at

http://www.mctweedle.com

in the FoxTool's area? Don't forget to get the sample code.

I believe Mark has worked with MySQL, but you'd have to check with him on the UT -

http://www.universalthread.com/.

Rick

 

[badukist]

Check the ODBC driver options for the connection.
Options you can change and see if works are :
1.Don't optimize column width
2.Pad CHAR to full length

If you use string connections, there is OPTION keyword but I don't know how to send option values.

 

[bluesw3]

Thanks.
I wasn't aware of those driver options. Im thinking it must be the 'Don't Optimize Column Width' option as that is checked in the DSN config. The DSN connection doesnt have the same problem so I'll see if I can send those options in the string connect.

 

[bluesw3]

Here's a link to further information on MySQL connect options should anyone else need it.

http://forums.devshed.com/archive/4/2003/05/4/63711

http://www.dwam.net/mysql/asp_myodbc.asp

 

[nocarrier]

I use option= 131609 and it works fine and has for over 2 years... full sized fields etc..
Bob Lee

http://groups.yahoo.com/group/VFPMySql/