FoxPro

10K

Solutions

1

Articles & Videos

4K

Contributors

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi Experts

Could you point how to programatically force a grid to present the first row content?

After a grid line deletion it presents the last line content at the top of the grid, obligating to click in the cursor top advance arrow to get the first line in top position.

Thanks in advance.
0
Industry Leaders: We Want Your Opinion!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hi Experts

Does a VFP app correctly runs on a wifi network?

I'm not certain I read here that it's not a good choice, since errors arises. The only option is by cable.

Could you clear?

Thanks in advance.
0
Hi Experts

Could you point how to correctly use vfpencryption71.fll ?

The "in general"  strategy I planned is:
When an user logs the app with password and read a record it's automatically decrypted to be readed - just the record.
During the CRUD - the line remains decrypted.
After the register is encrypted and saved.

Is it a correct approach?

Reading the examples that came with the library, it's not very clear to me the encryption/ decryption operations:

Encryption:
1. Define a key (that could varies depending on the encryption method adopted)
2. Encrypt the value and save.

Decryption:
1. Give the user the decryption key when login the app.
2. Every  CRUD operation will use the key to decrypt what is needed.

Is it OK?

Could you give me an example on how to do this ?  (you could use whathever encryption/decryption method as you desires)

Sorry so basic doubts.

Thanks in advance.
0
Hi Experts


Could you point a way (if it's possible) on how to install an automation component (.OCX) during a NULLSOFT instalation?

For the system correctly work this operation is needed:

REGSVR32  C:\Windows\System32\comdlg32.ocx

Is it possible to make it automatic?

Thanks in advance.
0
Hi Experts

Could you point what's needed to run a vfpcompression.fll under Windows 8?

I downloaded a fresh new vfpcompression.fll

Tryed to register it like it is a .dll (no success)

It used to run perfectly under Win7.
img001
A similar issue is occuring with vfpencryption71.fll too...

Any workaround ?
Thanks in advance
0
Hi Experts

Could you point the better way to encrypt/ decrypt a text file content "on the fly" by using VFP?

Thanks in advance.
0
Hi Experts

Could you point the better way to mantain long texts vinculated to a VFP line register?

Using a word file with OLE ? or a traditional FPT - is it possible to have a small text editor called inside the app?

Then the text must to be used in a report.

Thanks in advance.
0
Hi Experts

Could you point a VFP code to quit an Excel instance that could be trapped in PC before to start an Excel automation process to generate a sheet?

During an Excel automation sometimes a variety of errors occurs  I guess due an Excel instance to be oppened  even it's not visible- only with "task manager". If it's manually closed, things go easier. The worst, sometimes a sheet file couldn't be eliminated because it's trapped by Excel and an Excel instance doesn't even appear at "Task Manager"...

Very cahotic things occur also... a date column from nothing changes the mask from dd/mm/yyyy  to mm/dd/yyyy  in a  column from a line to the subsequent (?!)

I'm really reconsidering the use of Excel automation from VFP. It seens errors dificult to deal appears.

Thanks in advance.
0
Hi Experts

How to configure an Excel object column in VFP to present  a  value in this format:

-1.234,56  (decimal point is comma)

*-- Example that doesn't fit what I need.
oSheet.Columns("C").NumberFormatLocal = "$0.00_ " &&add decimal place 0.00

Open in new window


Thanks in advance!
0
I have built a program to insert data into a number of Word documents.  The insertion points are identified with bookmarks.  Most of the bookmarks are related to Word text fields or empty areas in the document.  The data values are inserted as text with statements like this:

                        oDocument.Bookmarks.Item(cBookmarkName).Range.Text = "TextValue"

However, on one form some of the entry fields are defined as Word checkboxes.  The statement above doesn't work because Word checkboxes apparently won't accept text strings.  I've also tried inserting 0 and 1, as well as variations of "true", such as .t., <true>.  Is there some other value and/or property that can be used to mark a Word checkbox as true from a VFP program?
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

I've got a grid object in which some of the columns can be edited and others can't. I'd like to be able to mark which columns are which by means of colour, greying the BackColor where a column is Read-only.

I can do this quite happily for the columns, but when I come to tackle the Header objects, it appears that nothing that I do by way of assigning .BackColor= makes any difference.

I can only assume that this property is locked in some way.

Any suggestions as to what I'm doing wrong?
0
FoxPro  FoxPro 2.6
I have a customer Master with Code & Name Fields. While entering data through Input screen I will type customer name and the program will go on filtering the name of the customer from the Master Data File and when I press Enter Key it will select the exact record from the master with Code. If there is any program in foxpro 2.6 kindly mail me at felixdaniel1575@gmail.com
0
Hi Experts


Accordingly with

Truncated:
img004
Correctly previewed:
img006
Thanks in advance
0
Hi Experts


A VFP report that is perfectly presented in a PC is truncated at right side when in a laptop, accordingly to:
img001
What could be done to make it correctly run in laptops?

Thanks in advance.
0
Hi Experts

Do you know how VFP runs under Windows 8?

I ran an executable, amazingly a feature related to oleTreeView simply didn't worked out.

Thanks in advance.
0
I have a foxpro DBF file that I need to modify. I need to run a modify statement where any records in "CLASS"  that equal "shop", cost is set to 0.000. I am running visual foxpro 9. Any advice wil be appreciated.
Capture.PNG
0
Hi Experts


Could you point how to programatically configurate the columns of an Excel spreadsheet  - dimensions and cells format
before it is generated by VFP?

Thanks in advance.
0
Hi Experts

I'm planning to use MS OneDrive as the directory to .DBF files, configuring the local VFP .exe to access it for CRUD.

Have you tested it, would it work out?

Thanks in advance.
0
fatal error : Exception code= C0000005 @
error log
     file: Z:\\VFP9Rerr.log
                Called from - pos.loadline.line 0 ( )
                Called from - pis. grid1. colpart_part_no.keypress line 0 ( )
                Called from - rman line 0 (z:\rman.exe)



please how can we fix this
currently running a retail store pos software and that error occurs when trying to scan an item  for sales
0
Monthly Recap
Monthly Recap

May was a big month for new releases from Linux Academy! Take a look at what our team built recently in our blog. You can access the newest releases from our blog.

I need a way to export data to excel but to be able to create multiple tables (tabs) in the excel file.  How can this be done?
0
I've tried everything I can find on the internet on how to get data from VFXP 9 on a Windows 8 machine to MS SQL Express 2016 on a Windows 2012 R2 server.  Two weeks I've been trying.
I've tried setting up a linked server, but the instructions on that assumes more knowledge than I have - I can't get it working and that may be because they were written for different machines than I'm using.
I need some help on database drivers and ODBC set up - I think I may have that, but not sure since I can't get linked servers working.
If I understand the concept of linked servers correctly, I could then write a PHP program to move the data from one to the other and set up a nightly run on the Task Scheduler.
I'd need a connection string to a DBF database container or the individual tables on a different machine to do that.
Worse case, I get the VFXP data into a CSV file and write a program to import that, but if linked server will work, that would be much better.
Anyone knowledgeable on this?
0
Lets say I have a process.exe.

Lets say I have any where from 4 to 6 processes running with the proc name.

I need to close and restart each process.

My issue is if the process is in use...I need the script to close this process cleanly..

How would I do that.

I have dont this before...but not sure about makign it close clean.

I dont want to just kill it.
0
What is count command in fox pro?
0
Coding as following,


SET DEVICE TO FILE ccclist.TXT

 SET PRINTER FONT "FoxPrint",24
 
 @1,6 say  "THIS IS A TEST"
 
 
 SET PRINTER FONT "FoxPrint",12
 
 @4,10 say "NORMAL"
 
 SET DEVICE TO SCREEN
 
 RUN /N1 write.exe  D:\PROGRAM\ccclist.TXT
or
RUN /N1 wordpad D:\PROGRAM\ccclist.TXT


if i print directly to print the effect of large char. display but i open in wordpad no effect. so which command i see text file.it is not mondatory wordpad. any foxpro vf6
0
SET DEVICE TO FILE ccclist.TXT

 SET PRINTER FONT "FoxPrint",24
 
 @1,6 say  "THIS IS A TEST"
 
 
 SET PRINTER FONT "FoxPrint",12
 
 @4,10 say "NORMAL"
 
 SET DEVICE TO SCREEN
 
 RUN /N1 write.exe  D:\PROGRAM\ccclist.TXT
or
RUN /N1 wordpad D:\PROGRAM\ccclist.TXT

sir i want to print text file with large font how ?. Above code i write vfp6 . when i print director large fonts effect display but i want to disp effect in text file. which command i open  text file with large font . pl. guide me.
Thanks
0

FoxPro

10K

Solutions

1

Articles & Videos

4K

Contributors

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.

Top Experts In
FoxPro
<
Monthly
>