Hi,
when I tried to connect local / remote MySQL database from VFP using following string connection it returns -1
lnHandle=SQLSTRINGCONNECT("Driver={MySQL OBDC 8.0 Unicode Driver};Server=127.0.0.1;Database=w27;User=root;Password=")
but I can connect to both of these database using...
Hi experts,
I used the below code in a form command button to display a web page content then copy the content into an edit box, when the url is www.google.lk this does work. But for some other web sites it says member BODY does not evaluate to an object (specially when the url is a pdf file.)...
Dear Experts,
Is there any methods(API) which pass/push/update a cpanel MySQL table a record from FoxPro
ie; when updating FoxPro form it is to send the record to a specific website's cpanel MySQL table.
Regards
MSiddeek.
Hi,
my sql table has 10 columns the first five being updated when with following function
SQLEXEC(lnHandle,"INSERT INTO table (column1, column2,..., column5) VALUES (?val1, ?val2...?val5)")
when FoxPro execute the above function the rest of the columns (column6 to column10) getting NULL...
I have created a temporary cursor from existing sql table on form load event of Purchase form, as follows. Just in case if the supplier not available, there is a command button on the purchase form to create supplier, it calls the supplier creation form, where I have written the same code to...
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.