-
- Foxpro Power!
by sanaltsk
- 9 Replies
- Last post
by Docpro777
- Hai Everybody, I jus wanted to have some sort of opinion poll from u people. IS FOXPRO ONE OF THE POWERFUL TOOL AVAILABLE NOW In my opinion its really powerful and very much useful even now i am very much found of it....
-
- Forum Usage
by Naomi Nosonovsky
- 14 Replies
- Last post
by AndyKr
- Since this thread has gone off-topic, may I please ask few questions about this forum usage.
1) How can I see replies in the chronological order E.g. I only want to see the latest replies but I can not figure out how to do it.
2) Can I turn off Alerts for good I often forget to uncheck them when posting a message.
3) Why most of the messages appear in a very small unreadable f
-
- Placing a program on the systray
by CFutino
- 2 Replies
- Last post
by CFutino
- Hi, all. I need to create a program that stays resident on memory (minimized on the systray) and checks for updates on a SQL Server database on regular intervals. Checking the DB is easy, but how do I make a VFP8 program that stays resident and minimized on the systray Thanks for any help
-
- GETDIR() in Windows Vista only displays Local Drives
by JDM0759
- 4 Replies
- Last post
by PB_UK
- Hi all,
I've created a small application (EXE) using VFP9, SP1 and copied it to Windows Vista Business edition and a Windows Vista Ultimate edition machine. This application has a few command buttons to have the user select a mapped network drive path. I have tried GETDIR(), GETFILE(), and even stepped out of the normal VFP function realm and used BrowseForFolder method of the oShell object. No
-
- Having problem to run VFP application.....
by demo
- 2 Replies
- Last post
by demo
- Dear all,
I developed an application with VFP8 and built it into exe. I deployed it to another computer for implemetion along with VFP8r.dll and VFP8enu.dll. When tried to run the application,an error flagged "Visual foxpro cannot start: could not load resources.." What can I do to avert this prolem,at least to let my application run on another computer without Visual foxpro 8 bei
-
- Microsoft Word Integration and French Accents translated incorrectly
by Stuman99
- 5 Replies
- Last post
by dni
- I am wondering if anyone has run into the problem with french accents being converted incorrectly when performing a microsoft word mail merge The data in the visual foxpro table views correctly but when the mail merge macro runs in the word document the accent is converted.
For instance Andreychuck, Charles becomes Andr¦¨ychuck, Charles.
thanks in advance,
Stuart
-
- Copying a numeric value with decimals from a cursor into excel without rounding up
by mrfitness
- 14 Replies
- Last post
by Naomi Nosonovsky
- I am having trouble with copying numeric values with decimal places into excel. I have a select statement (some being sums of numeric fields with 2 decimal places) with a group by function and I place these results in cursor c1. When it tries to enter this value into excel, it rounds all values up. (eg 309.66 becomes 310) I tried changing the format of the excel file to numeric with 2 decimal plac
-
- MSCHART AND VISUAL FOXPRO 9
by Mervyn-w
- 14 Replies
- Last post
by CetinBasoz
- I am trying to use MSCHART with VFP9 and have some success until I want to set or change Legions, Titles, Colors etc. or to enter data into the second Y axis. Using any of the property / constant names only produces the message "Name Unknown". Any suggestions.
-
- SELECT-SQL vs. SET RELATION
by Ed W
- 5 Replies
- Last post
by Naomi Nosonovsky
- This thread refers to the Speed with CALCULATE thread which was started on July 26th. I started a new thread because the original title is pretty far off base from what I've now determined the remaining problem to be. I'm working with VFP 6.0.
Thanks to all for the ideas yesterday.
I didn't realize that SELECT didn't always open the tables. I hate to think of how long it would have
-
- My exe does not running other PC
by mezofi
- 14 Replies
- Last post
by mezofi
- Hi! I built a project and I have a big problem. It is run only my PC, and if I put it on a pendrive (exe). But if I put it on an other PC , this program show only main page. Then when I click someone button, the program show an error message: Command contains unrecognized phrase/keyword (Error 36) It is very strange, because if it is on my pendrive the program good have not got any error. Mez fi f
-
- Cursors Help
by Anomaly
- 8 Replies
- Last post
by Anomaly
- Hello, I need to create a cursor to store information of two tables. This I can do, but how do I take the information I pulled into the cursor and apply it to a report I am having difficulties coming up with a solution. Thank you in advance, Anomaly
-
- How to calculate the data connection time?
by Lightening
- 10 Replies
- Last post
by Lightening
- I tried to add 2 fields, time_on, datetime, time_off, datetime
to calculate user's log on time in the Users.dbf.
How do I calculate the total time between the 2 value
Any better way to capture users' activity
-
- Any way to introduce spelling check into VFP?
by Lightening
- 14 Replies
- Last post
by Naomi Nosonovsky
- User wish to have this function. Is this possible Thanks.
-
- filter breaks in vfp?
by jmom
- 6 Replies
- Last post
by dni
- Hi, I have a form that used a freetable that is filtered in the load event.
select <alias>
set filter to <custnumber field> = <certain number>
I also have
on error set filter to <custnumber field> = <certain number>
throughout different parts of update events of my textbuttons
Somehow a user got to see an unfiltered table. I have not been able to
-
- Grid Column
by honey1016
- 5 Replies
- Last post
by dni
- It is possible in grid column if I will add a new record it will focus to the top row not in bottom row because the record is ascending for example work experience from present to former company. If you have a new job then add a new record and it will go to the top row not in bottom row Thanks
-
- build exe application
by lowellnelson
- 8 Replies
- Last post
by lowellnelson
- I am a neophyte FoxPro programmer, AND I am new to forums such as this, so please bear with me. I have been using a simple program utilizing a few free tables and some report forms, which I have been running within FoxPro. Now I want to generate an exe version for distribution to other computers in my area without installation of FoxPro at those locations. I have used the build command from the pr
-
- Olecontrol with MS-Word
by MM ROy
- 2 Replies
- Last post
by Naomi Nosonovsky
- Sir,
I am using Visual Foxpro 6.0. How to open a ms-word file using with olecontrol. Also, can I edit the file and save it. Please give me all codes.....
Roy MM
-
- Instance java classes from visual foxpro
by Inflrc
- 1 Replies
- Last post
by Markish
- Hi,
I have a java class that I want to instance from visual foxpro.
There is a method inside my java class that receives a String and returns another String.
I need to call this method from fox. How do I do this
Thanks a lot.
-
- Errors running FoxPro Stored procedures in .NET windows app
by TechMate
- 10 Replies
- Last post
by TechMate
- Hi
I want to run a stored procedure in user selected database which basically creates two new tables to be persisted in the same database. I am able to call this stored procedure but I keep getting the same error "One or more errors occurred during processing of command." There are no details of what the error is specifically about. I am able to run the same stored procedure using Mic
-
- Locking VFP rows from C#
by 5p1d3r
- 11 Replies
- Last post
by Naomi Nosonovsky
- We are wanting to create new records in a FoxPro database from c#.
The database in question does not have autoinc, but has a 'sequence' table instead.
The 'sequence' table has two columns 'file' and 'next_val'.
To get the next primary key for the CUST table, simply:
SELECT next_val FROM sequence WHERE file = 'CUST';
UPDATE sequence SET next_val = next_val + 1 WHERE file =
-
- FoxPro Views over VFP Oledb with VB?
by Kanaida
- 9 Replies
- Last post
by Kanaida
- Has anyone gotten this to work
I wanted to make a view that pivots a table like this:
From columns
Size 1, Size 2, Size 3
12 12 24
To Rows:
Size1 12
Size2 12
Size3 24
That way I can do matching from another table from row to row instead of using a complex program
I did this in SQL very quickly but can't seem to do it in oledb for foxpro.
-
- WORDWRAP
by honey1016
- 1 Replies
- Last post
by AndyKr
- How can i do to word wrap the header of the grid In Visual Foxpro version 7.0 it is possible but how about in Version 6.0 THanks
-
- Application reinstall using install shield.
by Aleniko
- 9 Replies
- Last post
by Rick Borup
- Hi; I have created a setup program with the install shield supplied with VFP9. Install went OK, but then I realized I need to have some additional files like the runtime libraries etc. On the second try, Installshield wants me to remove the old installation using ADD/REMOVE from control panel. The problem is that I cant find the installed program anywhere in the add/remove programs. I am also not
-
- Change Control Source of each detail line in a report
by Bob Gatto
- 2 Replies
- Last post
by dni
- Hello all,
I have a report that has a Picture/OLE object in the detail band. The control source for each record could be different, so I have to some how change the control source of the Picture object for each record.
The way I'm trying it now is I have a report variable setup like this:
Variable Name: nCnt
Value To Store: (nCnt + 1)
Initial value: 1
Reset value based on
-
- sql problem
by dvidal
- 3 Replies
- Last post
by dni
- Hi,
I used an sql clause in foxpro 7. I deleted some records with delete but I don't know how to commit these changes. If I write pack, it deletes all records. What can I do