Search results for query: *

Oops, I didn't notice that we wanted ALL commas gone, here is the updated code: s="HELLO,,,WORLD,FROM,,,,,,,,,TEK-TIPS" DO WHILE AT(",,",s)>0 s=STRTRAN(s,",,",",") ENDDO s=STRTRAN(s,","," ") ? s

How about this ... s="HELLO,,,WORLD,FROM,,,,,,,,,TEK-TIPS" DO WHILE AT(",,",s)>0 s=STRTRAN(s,",,",",") ENDDO ? s

Steve, I am doing as you suggest currently. I have a process that runs in the idle time between invoices to update data from the main office, etc. I have added a call to the sql server during this process. It generally runs at least once every 10 minutes and this call keeps the connection...

Mike, thanks for that code. That is basically what I am already doing. I check for a good connection before each transaction involving the remote MySQL server and reconnect if necessary. But, what I really want to do is to negate the need for doing it in the first place! I'm trying to figure...

Steve, that is basically what I am doing ... prior to any call to the sql server, I check the connection and reconnect if necessary. That is working fine. But, when it does disconnect because of a timeout, the connection still shows in the Client Connection list on the MySQL server. Using up a...

Mike, thanks for your input. I have already looked at both the ConnectTimeOut and IdleTimeOut settings and they are already set to 0 by default, I double-checked using SQLGETPROP(). Yet I am still experiencing the issue. John

Background: I have a VFP Point of Sale system in a multi-location store system. Each store’s software runs independently from the others. We gather and re-distribute relevant information on a nightly basis. I have written a system to store the generated invoices and inventory changes in a...

Re: Synology servers and VFP We have 15 locations running POS systems. Plus all back-office functions at our main office and distribution center. All running on in-house developed VFP based software and on Synology servers. Everything from FPD2.6 dos legacy stuff up thru VFP 9 current...

VFP doesn't seem to care about the header count, but it DOES update it ... so, this is what I do and it works great: in VFP, USE the file APPEND a record DELETE the appended record Header count fixed! I have written a program in VFP that allows selection of a file, and then "fixes" it by the...

I assume you are using @...SAY's? If you specify a coordinate in the @...SAY that is lower than the location specified in the most previous @...SAY, then Foxpro will issue a page eject automatically. I usually use ?/?? for printing, so I am not sure how to reset the internal line counter, but...

Try this APPEND DELIMITED WITH ; FROM filename the delimiter is not character data, so no quotes,etc. and if you put it at the end of the command, Foxpro thinks that it is a line continuation command John

Any ideas?

I do the same thing in a Point of Sale application. Check out the SCROLL command in Foxpro. You will have to keep track of where your current screen position is; test for and act on PgUp,PgDn,UpArrow, and DnArrow; and redraw the first/last line after the scroll. Hope this helps John

Does anyone know of a way to TIMEOUT of a POPUP? I am using the DEFINE POPUP ... DEFINE BAR ... ACTIVATE POPUP construct and would like to TIMEOUT after no user input like you can with BROWSE. Foxprox DOS 2.6 on DOS, WIN98, and WINXP Thanks, John