Search results for query: *

Hi Chriss, My application has a lot of SQLEXEC command, and only the SQLEXEC in line 32 is causing error so far.. thanks

Hi all, Yesterday, after looking into the line 32 which was triggering error, and found only simple "SQLEXEC", I tried to reinstall the mysql odbc driver, and it solved the problem. Same suggestion from Chriss, and mJindrova.. Thank you all for your inputs.

Hi Chriss, Mike thank you for your inputs. The text I firstly posted is from the vfp9Rerr.log, and after look into the source code: 1. The error message: frmlapdepr.pgf1.page2.cmdok.click line 32 is actually this statement msql="select...

Hi all, I have Foxpro app, and one of the module is to generate report on one PC, there is persistent error like this Fatal error: Exception code=C0000005 @ 02-07-2024 01:40:30 PM. Error log file: E:\MCM\VFP9Rerr.log Called from - frmlapdepr.pgf1.page2.cmdok.click line 32...

Hi all, Thank you all for your suggestion.

Hi Chris, Sorry for late response Yes, I have use mysql and VFP for develop desktop in LAN Environment. And I am trying to connect to remote database (which I am not administrating this database) I am looking for the other ways to connect to remote database from VFP besides use...

Hi Mike, Chriss Thank you for your explanation. Sorry for my lack of knowledge about accessing remote database on internet. I am very new on this. Could we use Sqlstringconnect to access the remote database? and use SQLEXEC to insert, update, or delete? As far as i know, mostly the database...

Hi Expert I have developed foxpro application for recording sales/ purchase transactions using mysql database. The company has also a website with mysql database hosted on the internet. I want to add a feature to my foxpro application, to send data from desktop database to the database hosted...

Hi All, I've use Google Chrome Remote Desktop for a few months, and it running well I have 3 remote PC to access. Yesterday, the two of my remote PC cannot be accessed remotely. The error message said that the computer administrator of the remote PC is not allowing connection from outside...

HI Chriss, Thank you for sharing your point of view.

Hi all, Thank you so much for your expert opinion. Like @Chriss and @gerrit discussion, Actually, I do have similar idea that mysqldump from my VFP Application will run on the server. At the beginning, I just want to make easier solution for my client, since they do not have personnel to task...

Hi Experts, I need to construct the feature of automatic backup of Mysql Database from my VFP Application. This feature will periodically backup the database (in example: for every 5 hours or other period of time) My Idea is to create a form with timer Event to execute mysqldump command using...

Hi Chriss, Thank you for your sample coding. In other cases, I've also experienced the behavior the 'blanking' grid when we make (requery) the cursor, and the cursor is already used on the property of controlsource of the grid when the form was designed. To prevent this I put the statement...

Hi All, Thank you all for your explanation and suggestion. I've double/triple checked the name of grid and column is still the same actually, and I have no code to alter grid in run-time But, I will have to check again then. Since we put aside the possible corrupt of .scx file, probably as...

Hi Experts, I have one form with grid name "grd", and in the "init" procedure/method, i have this code WITH thisform.grd .column1.enabled=.f. .column2.enabled=.f. .column3.enabled=.f. endwith The form is functioning properly. There was one time, I edited the form, to...

Hi Chriss, Thanks a lot for your time and explanation. I appreciate it.. Many thanks

Hi Chriss all data kddivisi column, in all tables are R actually. and datatype is Char(2) Is MySQL store 'R' and 'R ' differently? because I cannot tell the difference in the Mysql Browser thanks

Hi Chris, But why in experiment 1: there's no difference between 'R' and 'R ' ?

Hi Chriss, Yes, I am sorry, my explanation is not clear enough The difference between the statement results from VFP (from _CLIPTEXT using atlopes suggested command) and the statement I wrote manually is only in the clause ( ... where kddivisi='R '). The result of _CLIPTEXT, the parameter value...

Hi all Thanks altopes's. I have run your suggested command (I paste here from _CLIPTEXT) select a.no_aktiva,' ' no_seri, a.nama,LEFT(a.lokasi,50) lokasi,a.umur, convert(a.harga,decimal(15)) harga, a.tgl_beli,convert(a.metode,decimal(1)) metode,d.expense, d.jual, p.kd_pos,p.pos, ifnull(s.no,0)...