Search results for query: *

Thanks, that will certainly get me in the right direction!

Im searching for a procedure to keep a MySQL table up to date with changes made to my local vfp database. I need something that checks for changes in existing records, updates them, then adds any new records. This seems difficult without indexing. Any suggestions?

Ah... Solved my problem using .pages(nIndex) property. Im still learning ;)

Im trying to set control sources of grid columns to the active page in a page frame. I know I can put the individual code for each page into a case statement but I was looking for something a little more dynamic. Here's what I tried that obviously doesnt work but shows what Im trying to achieve...

Thanks ramani that worked great! Mike, the reason I couldn't use my existing code was because my view has an order set to it which differs from recno()'s order. Thanks for the help.

I have a view displayed on a grid which pulls records from 6 tables using UNION. Because union changes the order of my records I reset the order of the view. Im using recno to determine row color for most of my grids but it obviously wont work here. Are there any other ways to accomplish...

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

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.

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?

Im interfacing part of my VFP8 application with MySQL. For the most part everything works correctly except when I try to use an empty MySQL table. In this case only empty rows are added reguardless of the data sent. To add to this I noticed My cursoradapter only allows me to use fields as...

Is there anyway to modify the Data Environment of a form during runtime?