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?
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.