Search results for query: *

Hi Experts! My goal is to convert a batch of TXT files (that were created by a Fox program)to PDF using the Fox application. I already have a program that takes each TXT file, sends to the Printer, converts to PDF. In fact, it has been working successfully for years, until a server crash and...

Hi Experts, It's been a while since my last post but have several coming your way... I have recently installed Fox 2.6 on a windows 10 32bit virtual machine. in my new environment, I seemed to have a lost a setting where an inactive FoxPro Run Command screen would close automatically. Now I...

Hello and Happy New Year. The display of msgbox() is appearing outside of the borders of the Foxpro shell (window) and I was wondering if there is a setting (possibly through config.fpw or similar) that I can control position of this box? Thanks, Joe

Hi Guys, me again, making trouble... I am trying to create a file (.txt) pulling data from various Fox 2.6 tables. I realize the help you give is only as good as the info I give so I will do my very best... Ultimately I want to to create a mini program with the proper SQL statements. For now...

Hi Experts, I have a table "CUSTOMER" that contains a bunch of data fields such as FIRST, LAST, EMAIL, and STATE. However I noticed that my STATE field has no data. I have another table "TEMP" that contains that STATE information and I would like to update the CUSTOMER table. The STATE table...

Hi All, Need help adding an update database to existing code. So as mentioned in other threads with pleads for help... I am a novice programmer, my dad had built all my programs, I am maintaining them. In this one program, we run a series of data validity checks before executing a larger...

Hi Fox Experts, Hope everyone is still doing well. Thanks for all the help. I am learning and saving time. Very appreciated. I have a workable replace statement as shown below. REPLACE ALL contract.pymt_ddate WITH GOMONTH(Contract.pymt_ddate,360) FOR BETWEEN(contract.pymt_ddate, {21/03/2020}...

Hi Experts, I successfully tested this SQL statement. (it works) SELECT * FROM Contract WHERE contract.pymt_ddate BETWEEN {21/03/2020} AND {31/12/2030} AND LEFT(Contract.acctno,3)="219" AND contract.bal_due > 0 AND RIGHT(contract.dqstatus,2) <> "LY" and now I want to convert it to a replace...

Hi Fox experts. I hope this thread finds you healthy from COVID-19! I need a REPLACE statement that changes the 4 digit year if certain conditions are TRUE. my table is "Contract" my date field "pymt_ddate" Essentially I am looking for the following condition across thousands of records...

Hi Fox Experts, I have a small Fox 2.6 application that consists of a single program and several screens that my father had coded for me. I am a little confused around working with screens... Things I think I know 1. I can edit an SPR file in notepad... changes are compiled as SPX 2. From...

I have been running a procedure that contains the below code weekly without error for months... until this morning. Since last week (the last successful run), I have added a few indexes to some of my tables. Wondering if that might be the cause? Here's the code: SELECT cert_code...

Hi, I could use some help with dates. I have set m.date to a date in this format mm/dd/yyyy Now I want to create 2 new variables stadate & enddate where stadate is the first day of the month and enddate is the last day of the month associated with m.date. Example m.date = 05/15/2019 I...

I am running foxprow on Windows 2008 server, the last of the 32 bit operating systems (I think) and since Microsoft has stopped providing security updates, it's getting harder to find ways to keep the system operating in 2019. I would imagine that there are lots of companies in this predicament...

We are running a Fox 2.6 application in Australia which is typically 14 hours ahead of East Coast, USA. We connect from USA via remote desktop and would like to adjust the date/time used by the application by subtracting 14 hours from the PC clock this working in our time zone versus Australia...

Hi Experts! We already have the ability to send outbound email from our Fox application using MS Outlook. I'd like to now take advantage of outbound texting using Twilio's API and was wondering if anyone had experience with this and can offer some guidance I can provide my dad (aka the...

We are running foxpro for windows 2.6 and looking to upgrade security of DBF files. I was advised by this forum to research Cryptor. I have done so, however, it appears that Xitech, a UK based company is defunct, though they have a somewhat functioning website. Their phones are disconnected and...

We are running foxpro for windows 2.6 and looking to upgrade security of DBF files. I was advised by this forum to research Cryptor. I have done so, however, it appears that Xitech, a UK based company is defunct, though they have a functioning website. Their phones are disconnected and they do...

Hello! It has been a while since i posted on this forum but it has always been very helpful! As many of you know, DBF files are not very secure. I am trying to figure out a way to keep the data within the DBFs protected. One idea I had was to add restrictions/permissions to the folder where the...