Hot Solutions

Need to create liked servers on a 2008 r2 SQL server. Running on a 2008 window server.
When I try and create a new linked server I am missing the Microsoft OLE DB provider for Visual Fox Pro Driver

I need to print QR Code on a system written in VFP. Is it possible?

Translate from portuguese:

"Eu preciso imprimir QR Code em um sistema escrito em VFP. É possível?"

Is there a way to include the deleted status in an SQL query.

I want all the records, but I also want to be able to test for deleted().

Michael

I need to learn Visual FoxPro because I need it for my job
I found 2 resources from the web
http://www.garfieldhudson.com/FreeVideos.aspx
http://www.hentzenwerke.com/buy/zbuy.htm#26

However, I am not sure if any better resources that I...

I'm trying to include the Microsoft datetimepicker control into a Visual FoxPro form.
I need to be able to include a checkbox into the control, for those occasions when there won't be a date.

I can get the ActiveX control onto the form.
...

I'm trying to set up a linked server within a sql server 2008 r2 express database.
The user for sql service it's not the default one, i'm using, sqlsrv (created within user domain group).
The linked server is created but every query returns...

A client of mine is using VFP 7.  They had a request from one of their clients to send an email with the invoice attached in PDF format.

This will have to be accomplished form with the existing FoxPro app.  For another purpose we already have...

I have a report using the FOR clause that occasionally has no qualifying records.  All I get is a blank page.

     I would like to print the Header and Summary bands to indicate that no records were found.

Michael

Hi Experts
I would like to use Atemp.dbf table that exist on LAN computer name LAPTOP drive c folder spp without maping that drive and append records to it.
i can use with following code

use  \\laptop\c\spp\Atemp.dbf

but it is read only....

I have a prospective client using Foxpro (VFP 7) that asked a seemingly simple question but it has been a very long time (7 - 8 years) since I used Foxpro.  When I looked at the app it was really FoxBase using the @Say to create output reports...

Experts,

In inhertied this add-in and am charged with getting it running on our new appplication.

this is a very short file (about 22 lines without the comments)

The previous applicaiton it ran on had FoxPro Tools and the new...

OS: Windows Server 2008 using a domain.  Workstations are Windows 7.

We have a drive call it “Testing” with many folders.  One of the folders under “Testing” is “Results.”  The files in testing are updated on daily basis. “Testing” is on a...

I have a client who would like to use the UNC naming convention, for example,\\servername\drivename\foldername\foldername and grant users permission on a Windows Server 2008 domain rather than the traditional mapping to the drive or folder.
...

Hello experts,
I need your help.
I created a multitable view. All seemed OK until I wanted to use the SKIP command with a VCR command buttons. When using the skip command the order in which the records are displayed is corresponding to index of...

I'm trying to keep my FORMs tidy by hiding unused objects and moving others up to fill these spaces.

The particular FORM that I'm having trouble with has a pageframe. Within that there's a series of pages. Within those there's a series of...

Hello we have a Visual Foxpro application we wrote in house years ago for managing inventory and customers, work tickets. It serves us well, but we have not done any maintenance for at least 5 years.
There are about 6 main table ranging in size...

After nearly a year, I'm getting back to a set of Visual FoxPro programs I need to complete.  There is a primary program that calls two or three other support progams.

I ran the set of programs yesterday and, the first couple of times, the...

I need to block for update  some lines of a data entry grid, but i do not know which ones because this depends on user's choice. How can I do this? Is there any way to creste a checkbox that when checked.blocos one line?
Regards
Lucilia Coelho

I would like someone to help me by writing a query in FoxPro
Please see attached spreadsheet where all is explained
Many thanks
R

ps........ filename (sales) should also be selected as part of the query

I need foxpro, permutaions combinations recursive for the corresponding c program as attatched below

Hi,

I am trying the following query. Could you please give me some direction or answer?
I have 2 tables. The first one is CLIENTS with with client_number as the key and city or location. The second one is BILLING with biil_number as the key,...

Hi:
A smallish question:
I have a table of planned production, one row for each date from today.
I want to extract (either as query or export) only the first 5 rows; being the next 5 working days.
Is there a facility to do this in vfp,...

I have a very simple VFP 6 program which I wish to operate as a runtime. The runtime VFP dlls are already installed on the workstation.
When I run this exe from Windows XP, I see the "Save AS" as a minimized app on the Windows toolbar but I see...

In my business i potentially have instances of my program open on various networked computers.  I would like to have the instances "Time out" if there was no keyboard or mouse activity after a certain period of time, say 15 or 30 minutes and...

experts,

i have a dead server that was hosting a visual foxpro 3 database. I have the files, but need to bring the database back online ASAP. Unfortunately I know nothing about foxpro other than the last 5 minutes of googling I've just done. ...

In our application, written in VFP9, we would like to include a routine for store, in MySql tables, incoming and / or sent emails ( and then another routine to open these emails ).

Is that possible?

Translate from portuguese:

"Em nosso...

I need to find  ‘BROWSE FOR asst_group='RO&&75 '  the problem is that the system error on the && characters, how do I run the search with this characters.

Hi,
I have a textbox on a form I would like uppercased as its being typed. I tried 2 solutions, the first one being obvious - put This.Value=upper(This.Value) inside the interactiveChange event of the textbox. This didn't work because it...

Hello  everyone,
I have a malfunctioning property puzzling me.
I use ole control Calendar objects, normally to enable  users date seleccions easier.
I have one of them, and I cant't tell why, that doesn't pops up the Calendar.
Can any one...

I have a weird behaviour in a report that I would like to know if someone can help me, here it goes:
If i write a report with more than one detail band after the lastima detail band is printed there's an empty page that the printers throw out....

Hi

we have a field call descript and in there we have

clamp,general
nut,hex

we would like it to be

general
hex

I have to creat a text file with register legth with 900 characters. How can i do that in VFP?
thanks

I've got a form that has a pageframe object with two pages.

I'd like to be able to detect when the user has moved from one page to the other.

I'd rather assumed that this could be done using a GOTFOCUS() event associated with each page -...

I have a VFP form that has the sct file corrupt. how can i solv this problem?
thanks

I have a customer with a very old Foxpro for Windows application. I was asked to modify some reports and everything was fine until suddenly it started selecting Black as the fill colour for all the text fields.

I've seen this problem before...

Hi All:
I have a VFP-9 App. that has been in use for many years. About six months ago, they began seeing "Record Not Available" in the status-bar and their workstation(s) would "hang" at the current record for any length of time before...

Hello Experts,

I have a table with field Quantity, need a format while doing select Query:

Quantity  
--------------
000160 -- I need like this 16.0
000111    I need 11.1
100105    I need 10010.5

Please suggest , how can I get just...

Hi, can anyone help me do a simple search and replace?
I need to replace field2 with "$10.00" where field1 is between $5.01 and $9.99

Thanks.

Hello Gurus,

Here is the situation.
I have 1 file that has a list of items with qties and values
Items.dbf File structure :
********************
code C(10)
Qty N(2)
Value N(8,2)

The Qty is always 1


Customers.dbf File Structure...

I have a foxpro program that I'm trying to do.  I want a user to be able to create a string at the top in Batches and pull that data only.  It seems like my conditional statments are messing me up.   I want to to pull where batches in multiples. ...

Is there a way to change the paper source on the fly within a report?  I have an application that involves printing a single report stream onto 2 different paper types, one a pre-printed form, and the other blank.  I have tried stringing reports...

I'm working on a Visual FoxPro project that I had to split using ReFox. I'm trying to find the program that runs at startup. In the tastrade.pjx sample project, there is a program named main.prg which I ran in debug mode to see that it is the...

Hi,

I guess the title says it all.

I have a VFP "database" and I currently run a scheduled DTS Task (from SQL Server)  to routinely import the VFP data. This is now causing issues as the process is taking longer and longer as data volume...

I need to create an array in a form that is scoped PUBLIC to the ENTIRE form, but not PUBLIC outside the form.  The reason is I need to have multiple instances of the form running, but with client selection they will different data in each of the...

This is driving me crazy!  In development mode in VFP9 I run this code:

#DEFINE HKEY_CURRENT_USER           -2147483647  && BITSET(0,31)+1

DECLARE Integer RegOpenKey IN Win32API ;
      Integer nHKey, String @cSubKey, Integer @nResult
...

Hello,

We have Report Writer and need to convert a .BDF file to .CDX file (index file) so we can reference the file to. Is there such a utility or anyway around it?

Best Regards,

We currently use the mscomm32.ocx controller to receive data through various com ports, we are starting to pickup some problems when we install on windows 7 machines. I am wanting to know if in VFP is there any way that I can control the com port...

I have a form that last some 200 tables opened that we buffer and require a TABLEUPDATE() for record additions and edits.   We have a routine called UpdateAll() that make an array of all table object  then runs through a check to TABLEUPDATE()...

We have small Foxpro 3.0 app running on a very old Windows 98 computer. We are concerned about the reliability of this old PC.
We would like to "migrate" Foxpro to a Windows XP computer. We unfortunately lost the Foxpro installation media.
...

Hi
I would like in my audit trail of one of my tables to attach emails as well. Here is what i would like to do:
- drag and drop an email from outlook 2010 into vfp
- upon dropping, i would like to save the dropped email into a file (.eml i...

I'm trying to use an MS Access 2007 mdb to link to a Visual FoxPro dbf file. I downloaded the ODBC driver, vfpoledb.dll into the folder C:\Program Files (x86)\Common Files\System\Ole DB\ from the web link...

One of my programmers wrote a PHP program to automatically connect and update a web based SQL from our Visual Foxpro DBF files.  It works neat, except unless we close the PHP program down it wil not allow us to use the VFP tables exclusively for...