I am using Visual Foxpro to connect to Linux MySQL. When I try to connect to through MyODBC, everything is fine. However if I issue SQLCONNECT and the connection fails for some reasons, the driver prompts a Window to report error. This window is quite troublesome and may cause my client panic...
Ali Koumaiha,
As update is needed only when PO comes, your method will be feasible. Actually you are setting up a supplementary database so that update can be made from the warehouse to the outlet with limited data flow. That's a good idea if the update is not frequent (frequent=once per minute)...
Ali Koumaiha,
That is exactly the things I am working for one of my client. At last I choose to use a MySQL server to handle the data (i.e. A is MySQL, B is VFP). These are some of my considerations.
1) Application B does not know the time data arrives. Therefore it must scan the hard disk again...
Rick,
Thank you again. I have tried adding a NODEFAULT and moving the object_new.SetFocus to object_old.LostFocus(). The problem is fixed.
Just for curiosity: I have read the Language Reference of DEFINE CLASS and found NODEFAULT. Its function should be to avoid VFP to do its default event or...
Rick,
Thank you for your reply. Yes I am using 3.0b.
The confusion happens almost everywhere (e.g., CLICK(), VALID()). I can't trace any pattern as it occurs sometimes but does not occur sometimes. It depends on what is done inside the CLICK() and VALID().
I don't get your meaning of NODEFAULT...
If the xbase is finally obsolete, I'll bet VFP is the final one to out. There is not much choice nowaday as many similar products (like Clipper & DBASE) have stopped development.
As Linux and MySQL is very mature nowaday, it is a good idea to have a look on them. This combination is very cheap...
I am using VFP 3.0. There is a long time trouble for me. When I want to shift the focus to something like a ComboBox, I find the focus frequently jumps to the object following the target I intend to set. For examples, the sequence of object in TAB is A>B>C>D>E. If I issue B.SetFocus, sometimes...
I also have some bad experiences in migration of FPD to VFP. Depending on the code you write, it may not be possible (or more correctly, "usually fails"). Some lines with commands like SAVE SCREEN, ?, ?? may be fine in FP and not working properly in VFP. My final decision was to...
I have recently met a very strange case. I have written a lucky draw program for a client. It is running during the office hour. One day the program went crazy. When I check the log, I found that the array which held the stock went back to what it supposed to be three hours ago! It just likes a...
Question 1. Is VFP a programming language/ environment that MicroSoft is going to support long term.
My opinion: Certainly.
Question 2. Simple things like ODBC DSN does not seem to supported by the programming command language. Is it?
My opinion: Actually it supports some critical ODBC DSN...
Yes, ; doesn't work like what is expected. MySQL accept ; as a terminator of a sentance. Certainly VFP (may be the fault of MyODBC driver, not VFP) will not operate in perfectly the same way. I suggest you not to use ; in ANY sql passthrough statement.
Actually I also find some problems in GRANT...
Assume you have some experience of XBASE programming.
Then you need to study a little bite about SQL command first.
VFP has an excellent support of SQL (MS SQL and Linux MySQL) connection. Don't worry. With VFP you can do almost anything in SQL. What you need is:
1) An ODBC driver. MS SQL driver...
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.