-
- Using a JOIN when communicating with SQL from VFP6
by mrfitness
- 4 Replies
- Last post
by Alex Feldstein
- I created two programs in which both connect to SQL database to execute a SELECT query. The first one is a straight forward one with one table and works fine when I display info SQLEXEC(m.lnConn, 'SELECT * FROM Cluster_info', 'cinfo') scan cinfo.cluster_name The second one is trying to JOIN a table and a view. I first went into SQL and used the query view to select and join my table/view to automa
-
- Open table exclusively?
by rroot01
- 14 Replies
- Last post
by AndyKr
- Forgive my ignorance - I've recently reinstalled XP and subsequently Foxpro 7.0. Now when i double click on a foxpro dbf file it opens the table and another datasession labeled 'B' (i'm supposing it's a datasession). Previously, when i opened a table i was in exclusive mode and didn't have this duplicate table open also. I normally work in exclusive mode because my data is not in a shared environm
-
- How to create a calendar in report?
by Lightening
- 9 Replies
- Last post
by Naomi Nosonovsky
- Trying to create an event calendar in VFP6 report
Have a table with 2 columns, cText, dDate
Created a group based on Week(dDate) -- group by every week.
Add 7 fields for dDate value across a row, with each like
iif( dow(dDate)=1, " "+SUBS(DTOC(DDATE),4,2) +" Sunday","")
iif( dow(dDate)=2, " "+SUBS(DTOC(DDATE),4,2) +" Mon
-
- Problem with Vista Windows mail
by JackChiou
- 14 Replies
- Last post
by Naomi Nosonovsky
- Hi everyone,
We have this foxpro 8 program that getting email from Outlook 2000, 2003, 2007 with MAPI32. It works fine until we try it on Vista's Windows mail. Everytime it runs "fetch" and get the meesage, the program will just break and pop up an error message saying
"An error occurred communicating with your MAPI message system. If you are using Microsoft Outlook try ch
-
- Returning Arrays And Cursors to .NET from VFP???
by AlexBB
- 14 Replies
- Last post
by CetinBasoz
- It is all about the business of Stored Procedures which I am trying to perfect. The SPs are called by my .NET C# app. A lot of the stuff I've had difficulaties initialy appears to be working now. Still there are numerous limitations and one has to get used to them. It is a new style of programming. Very austere. If you want to DELETE a record in a table and you have 15 of them and want to determin
-
- Combobox too short, no show of element
by Hans L
- 6 Replies
- Last post
by Hans L
- I had a combobox that was shorter than some elements in the list. The longest of them did not show in the box at all. I had to lengthen the combobox in order to show this longest element. Is this a know glitch Hans L
-
- 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
-
- How to control the scanner with VFP?
by hoabinh
- 5 Replies
- Last post
by AndyKr
- Hi everyone,
Could I build a program in VFP to control my scanner as: connect, scan, and save file....
Where could I find out the TWAIN OCX support for it
Thanks a lot.
-
- vfp desktop app redesign/rebuild as aweb application
by maryg
- 3 Replies
- Last post
by Claude Fox
- I need some help with figuring out how to port a desktop application to a web application given these constraints: 1. Desire to maintain a base of common code between desktop and web applications 2. Desktop code is mostly procedural, not object-oriented (originally written in FoxPro 2.6), and does not separate interface from business logic. 3. Preference to make as few changes to desktop code as p
-
- "Cannot find the menu-generation program."
by AlexBB
- 14 Replies
- Last post
by AlexBB
- Hi there,
I actually posted on this subject twice before and once got a satisfactory answer, the other time I simply figured out how to get this file myself.
Now it seems to be different. When I make and attempt to build a project I get this message. So, I click Add, go to Program Files\Microsoft Visual FoxPro 9\ and find a file: genmenu.prg .
Click on it and I get another error message:
-
- NOT A TABLE
by NGUYEN XUAN KHANH
- 4 Replies
- Last post
by Vladimir Zografski
- RECENTLY I HAVE A TERRIBLE PROBLEM ABOUT DATABASE IN VISUAL FOXPRO 8. THERE ARE 400 DBF FILE IN MY DBC. 2 DAYS AGO, AFTER INPUTED DATA, I EXITED THE APPLICATION. THE NEXT MORNING I RAN THE APPLICATION, IT MESSAGE TO ME THAT "NOT A TABLE". I CHECKED AND FOUND THAT 300 DBF FILES GOT ERROR "NOT A TABLE". ALTHOUGHT MOST OF THEM WEREN'T INPUTED DATA AND POWER AND HARDWARE WERE IN GO
-
- Qick Sql question
by Brad McCormick
- 4 Replies
- Last post
by CetinBasoz
- Good Morning Everyone, Quick question, how can i use a variable with a like statement as in select * from table where col1 like var
-
- How to copy one column to another
by gdtrfb
- 4 Replies
- Last post
by CetinBasoz
- Hi all,
I would like to copy a column that has prices (fprice) for parts in it to another column within the same table. Then I am going to do a replace on the original column (fprice) to increase the price by a fixed amount (I know how to do that). The table has a column that is not used for anything (by us) within the application. It is a User Character 3 field (fcu
-
- Open Source VFP?
by Claude Fox
- 12 Replies
- Last post
by Tamar E. Granor
- Ok, this article looks fairly balanced and states that MS is seriously considering an Open Source VFP!: http://arstechnica.com/journals/microsoft.ars/2007/04/03/developers-petition-for-the-return-of-visual-foxpro
-
- C++ to VFP Translation?
by Cody King
- 14 Replies
- Last post
by CChalom
- First, I'll have to admit that my coding skills have been unused for several years now, but this is one thing I believe that VFP should handle no problem. Here is the setup:
This program gets data from an A to D board and it utilizes DLPORTIO.DLL to address the parallel port and go thru 8 channels. (I know.... old school...but that's why I got it!)
I've done the Declare statements t
-
- VFP6: Problem saving data
by MillBear
- 6 Replies
- Last post
by AndyKr
- Hi all
The VFP database system is running in the server so that all the workstations can share it.
The user complained that she could not save the data after amending. I tested to see whether I was able to save it on my side. It works successfully. I went back to the user¡¯s workstation to verify it but still the same problem. I tried other workstations and found no problem so far.
-
- How can I make a Singleton (i.e. can create only a Single Instance at a time) application in VFP 6.0 ?
by nrpanda
- 7 Replies
- Last post
by nrpanda
- Hi,
How can I make a Singleton application in VFP 6.0. A Singleton application means only one instance can be created at a time of an .exe from its source folder.
I have tried to make it through checking the flag value stored in dbf field. If True, then exe is running, else not. It is working fine. But when I am running the myapp.exe file second time, it is flashing its background scr
-
- program line numbers...
by ibbm
- 3 Replies
- Last post
by ibbm
- how do you display the code line numbers when you are trying to locate the errors when building an app. It used to be in the debugger but I don't seem to be having much luck!
-
- Historical FoxPro
by Dumarest
- 5 Replies
- Last post
by Dan Freeman
- This is really historical, back when FoxPro was independent. I just had a full system crash, and now want to get my one database with FoxPro back up. It will not run. Calls for a dll which is in fact on the system, but indicates that reinstalling the .exe file is desired. But ...... That is years ago, and any source material is on 5 1/4 inch diskettes if I still have them [generally these have lon
-
- Update multiple records in remote view opened with NOREQUERY causes error: File is in use by another user (Error 108)
by WallyN
- 2 Replies
- Last post
by WallyN
- I am in the process of converting to SQL using remote views. The application opens up many tables, in many data sessions so to keep from downloading the same data over and over again I have used the NOREQUERY option of the USE command. This works great if I am in the same data session; however, if I open the same remote view in a different data session and then try to update multiple records it ca
-
- FOXFIX5.DLL and Windows 2003 Server
by Stuman99
- 9 Replies
- Last post
by Stuman99
- I seem to be having a problem using foxfix.dll on a windows 2003 server. The error message generated is cannot load 32-bit dll c:\foxfix\foxfix5.dll. Any ideas... seems to work ok when run from my windows xp workstation.
Stuart
-
- How to disable Foxpro screen?
by Joe Au
- 14 Replies
- Last post
by AndyKr
- I have a project with one screen form only. When I run the execute, the screen form is within the foxpro's screen. How do I make the screen form as the only window form shown on screen
Thanks.
Joe.
-
- Report Designer
by MillBear
- 3 Replies
- Last post
by MarciaAkins
- Hi all
Is there date sorting on the field in the report designer
Thank you.
-
- Corrupted Table after attempting inserts.
by Kadrin
- 8 Replies
- Last post
by Naomi Nosonovsky
- Hey everyone, You may have read my post the other day about inserting records into a table, well I did get that sorted out. However, once I finished the insert statements I put them into a DO WHILE loop and had it working yesterday before leaving the office. Today, I am having difficulties, there was an error when I ran the INSERT s , it said "End of File Encountered". The expression o
-
- Little Doubts with ListView....
by Paramu
- 5 Replies
- Last post
by Markish
- Hi There,
Well. & Thanks in advance.
Actually I added a table data's to Listview...But I want to locate my cursor in Listview ...according to my Textbox...value...
for that any Command same like Locate for....
My Codings...For Data's added in ListView..
---------------------------------------------------------------------------------------------------------------