Search results for query: *

Thanks Mike Thanks Olaf The problem is wording in the string, which should be UI instead of User. I found out this after checking the dsn file. Olaf, I tried to catch the error with AERROR() but it did not throw anything. MSiddeek.

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...

Olaf Yes these pdf test results are belongs one of my client, to whom I am developing a new sql back end database application, he needs his old data to be incorporated into this new application. The main problem is that my client has access to the pdf files and not for the cloud database. The...

Mike / Olaf As Mike mentioned in his last post, my main problem is copying the content from PDF. Actually I am in the process of dumping of about 102,000 records from online pdf result files saved in a web site, each PDF is one record, therefore I need to open all those files and copy them...

Hi Griff, I tried your code still I am getting the error for www.google.lk it works but for www.yahoo.com it throws and error message member BODY does not... for online pdf files it says unreadable. Is there any way I can read online pdf file contents (my main object is reading a list of...

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.)...

something like this https://hostname.example.com:2087/cpsess##########/json-api/cpanel?cpanel_jsonapi_user=user&cpanel_jsonapi_apiversion=2&cpanel_jsonapi_module=Module&cpanel_jsonapi_func=function&parameter="value

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.

Thanks Olaf, I will follow as you advice, once again thank you very much for your feed back. Regards MSiddeek

Thank you Olaf for your valuable thoughts, I did SET NULLDISPLAY TO '', it is working fine my only concern is will it have an impact on numeric or date field?? I mean will it change a numeric field into char field, I checked on the resulting cursor but it has not changed the numeric field or...

because the rest of the five columns are filled by another user.

Thanks Olaf, Griff For your valuable comments and advice. Olaf I got your point it's SQL who is the culprit. Is there any way when I recall the SQL records (ie SELECT * FROM table) these NULL words can be eliminated, so the result cursor will not have these NULL words on it?. Thanks 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...

Olaf, Thank you for the answer, tips and advice, I set the variable into form property, this time I got the error saying supplier not found. Further I copied ftemp into final work, because I treat supplier as cursor rather than a table. MSiddeek

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...