-
- Memo Files
by RAlvarez579911
- 1 Replies
- Last post
by Naomi Nosonovsky
- A c# app my team mate is working on uses a VFP dll. Its not working though, so I have to recreate the dll from the components in the source code. First, the project memo file is invalid, so I had to create another project file to generate the dll. As I compiled the dll, errors, pop one after the other, most of which were solved by locating missing files. However, another error 41 popped up, this t
-
- Side effects of leaving SET STEP ON in code
by FoxCreek
- 13 Replies
- Last post
by Tamar E. Granor
- If we forget to remove a SUSPEND command before deploying a VFP program, the program will throw an error saying ˇ°Feature not available.ˇ±
However, if we forget to remove a ˇ°SET STEP ONˇ± command, the deployed program will not error, but will function as desired, acting as if the ˇ°SET STEP ONˇ± was not in the code.
Are there any known ˇ°side effectsˇ± of leaving a ˇ°SET STEP ONˇ± command i
-
- 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.
-
- how to escape from valid event
by RavindraPatil
- 6 Replies
- Last post
by Naomi Nosonovsky
- Hello,
Suppose an user is adding a record and he is on a field which needs validation. He tries for long time but can't enter valid data. So he wants to give up and exit from the form. But he cant click anywhere without entering valid data in that field.
In such case how to help the user to exit
pl. help
-
- Append problem
by dvidal
- 3 Replies
- Last post
by dni
- Hi,
I have a problem with append command. In a pc, I have to write the file name enclosed by quotation marks. For example:
append from "pepe".
I want to know how to change fox settings to write:
append from pepe
Thanks,
-
- Passing multiple variables from forms w/ VFP7SP1
by KDKephart
- 14 Replies
- Last post
by Naomi Nosonovsky
- I'm an old Clipper (S' 87) programmer that needs to figure out forms with VFP. The attached code generates a form containing a set of four optiongroups that set basic comm port parameters on the local host for serial communication with an instrument (usually an electronic balance). I'm trying to use the form to replace a series of cascading menus in the original program. My intent is for the form
-
- Visual FoxPro9 Report Designer BUG
by MariusR@R
- 10 Replies
- Last post
by VSCG
- This issue is somehow related to CTRL+V (Paste) action of an object in report designer and TAG Memo field in .frx file. This is actually terrible thing because you can loose all your code in INIT procedure in Report.
Steps to Reproduce:
Just try to do the following actions: 1. CREATE REPORT 2. Add a Field box with some text 3. Open INIT procedure in data environment 4. Add some text
-
- Search Company function: Type any letters to find a few similar company names
by MillBear
- 8 Replies
- Last post
by CetinBasoz
- Hi all
I create the form to search the company name. I have the long list of company codes & names inside the table (company.dbf).
Form Designer
Company Name : <Text1>
<Grid>
Code | Company Name
Search Command Exit Command
For
-
- The Fundamentals : Building Visual Studio Applications on a Visual FoxPro 6.0 Foundation
by mathmo
- 8 Replies
- Last post
by MarciaAkins
- Arrrghhh.... been trying to buy this book, but Amazon will not allow shipping to the ends of the earth (i.e. New Zealand). Try as I might, I can't find anywhere else that is selling this book. Certainly I know my local bookstores will be a waste of time, it is out of print. I believe this is the best book to get to learn Visual FoxPro, but because I can't get hold of this one what suggestions are
-
- dropdown list box
by Hans L
- 11 Replies
- Last post
by Hans L
- I read everywhere about the so called "dropdown list box", but, while I have searched long and hard, I cannot find any description of how to create such a beast. Kind of embarrasing, but ... Also, as a stopgap, I use a combo box to select indexes to list various sets of data in a grid, and I do not have anything in the ControlSource. I have 1 ¨C Value in RowSourceType and then six list it
-
- index problem
by bijansaba
- 5 Replies
- Last post
by hangover
- Hi
i am trying to index my table but i got this message what must i do
erro building key for index "d:\tt\dit.cdx" tag "enh"
-
- Retrieve Recno() of a newly inserted row into a table
by Steve-0
- 11 Replies
- Last post
by CetinBasoz
- You'll have to bear with me as I am not very well versed in databases in general, but even more so with Foxpro.
I am using the latest Foxpro OleDB driver and need to find a way to retrieve the recno for a newly inserted row into a table.
I have tried the following, assuming that the newly inserted row would be the last one in the table but this does not seem to work as I thought it w
-
- VFP: need help in getting the no. of weeks in a month (1st to 5th week)
by Eumir
- 3 Replies
- Last post
by Markish
- Hi Everyone, I am newbie here and trying to learn VisualFoxPro. I was hoping that you could help me out on this. "How do I get the number of weeks in a month as well as the dates inclusive in that week " Any help would be greatly appreciated. Thanks in advance! Regards, Eumir
-
- Why _pageTotal always shows 1 ???
by Lightening
- 9 Replies
- Last post
by Tamar E. Granor
- in VFP9, I tried to use
use my table
report form test noconsole preview "Page " + TRANS(_PAGENO) + " of " + TRANS( _PAGETOTAL) But the _pagetotal value is always 1 although the report contains 4 pages. What is that
-
- Hot key question
by xuyca
- 7 Replies
- Last post
by Tamar E. Granor
- I know that we can assign a hotkey 'S' for a button like : thisform.button1.caption="\<Start" The question is: how to assign a hot key "Page Up" or "F2" key for the button in a form
-
- cannot quit visual foxpro
by HowardW
- 14 Replies
- Last post
by dni
- Subject message appears altogether too often - during my development, user sessions, etc. Similar messages imply this could be caused by the task pane. I do not knowingly use the task pane and have the auto startup turned off. Sure enough it happened again - tried clear all; release all, clear events, sqldisconnect(0), etc. - all the things I could think of and tried before. No luck. Then I turned
-
- "Multiple-step operation generated errors. Check each status value."
by Steve-0
- 14 Replies
- Last post
by Steve-0
- I am getting the following error when trying to update an existing Foxpro database using the VFPOLEDB.1 provider and ADO: "Multiple-step operation generated errors. Check each status value."
I have tried about every combination of cursor types and locations but cannot get it to work. Here is my code:
Dim ADODBConnection As New ADODB.Connection()
ADODBConnection.Con
-
- Reporting Tools
by orderinc
- 7 Replies
- Last post
by Craig Berntson
- I need to write a bunch of new reports for a variety of reasons that:
- use data from multiple data sources (vfp, SQL, sybase's Advantage database, etc)
- output in multiple formats (pdf, xls, txt, doc)
I am somewhat proficient using vfp8 report writer. I am currently considering:
- VFP9 report writer
- eqeus' XFRX
- crystal reports
- .NET 2005 reporting options
Any
-
- ComboBox Control
by Ahsan Amin
- 14 Replies
- Last post
by Naomi Nosonovsky
- I have to to fill a combo box control with a table fiels with 'Please Select' at top.
-
- Grammer Check
by David Beckley
- 3 Replies
- Last post
by David Beckley
- Can anyone assist mw with installing grammer and spell check when writing email - I have windows xp home.
-
- FoxPro Ver 8 problem with Ver 7 form doc
by Old Foxpro Dood
- 14 Replies
- Last post
by AndyKr
- I work for government and unfortunately we are a little behind on versions, but I do have a problem which my dbase,sco foxbase, microsoftfox brain can't handle. A project was created in Ver 7 with no compilation or execution errors prevelant. When proj is opened in Ver 8 and a particular form is opened the error displayed says "SYNTAX ERROR 10" .... my old feeble brain has tried debugger
-
- "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:
-
- 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
-
- ''DECLARE'' in Visual Fox Pro
by SY Tee
- 10 Replies
- Last post
by CetinBasoz
- Hello,
Can I use "DECLARE" in a Visual Fox Pro open table
DECLARE @before int, @after int
UPDATE wdoctyp
SET @before = idoclastsn, @after = idoclastsn = idoclastsn + 1
WHERE docType='LEAVE'
Best regards,
Tee Song Yann
-
- TYPE
by dni
- 3 Replies
- Last post
by Docpro777
- I like to know what character will return function TYPE() from x, where x is:
x=STR ( YEAR ( DATE ()))
I think I have somthing wrong with my vfp 9 installation.