Answer Questions

• Tom McDonnell GRID JAM ON A NETWORK WITH VFP9

  We're facing this problem. We have a grid which is the detail of a header table. The two tables are linked with a relation in the data environment. We use the application on a network; two users enter the form, both insert some detail records linking a different header code (e.g. 5 lines each); one of the users is pointed in the middle of the grid and he DOESN'T SAVE the data; the other user after having inserted the header code and the detail lines saves the data; the user who doesn't save, goes through the grid with the arrows and his data are replaced "virtually" by the data the other user committed ! I created (and I can send it) a simple example with base VFP9 classes to reproduce this behaviour. This is a big problem for ...Show All

• ACCOUNTINGONLINE.US Searching for a particular record.

  How can I search for a particular record in a table that it's in a different datasession For example, If I had 2 Forms, Form1 displays the info about some product and FOrm2 is where I establish the parameters for the search (like the product code, the supplier, etc). Once you choose the parameters a grid displays the list of the matching products then the user selects one of the products in the list and the record pointer should move to that product in Form1. The problem is that Form2 uses a Private Datasession. Is there any example sourcecode I could download THANKS Set things up so you can pass the value you need back to Form1. The easiest way to do this is for Form2 to be modal, then yo ...Show All

• Hristo Cursoradapter Browse - Enter Key Doesn't Work

  Hi, In VFP8, I have a cursoradapter and do a browse. Users noticed that sometime when the edit a field it doesn't get saved. We narrowed down to discover that if you change a field value and press Enter and then Ctrl-W, the change is NOT saved. If, however, instead of pressing Enter, you mouse click on another row or cursor up/down to another row, then the change DOES get saved. Why doen't Enter (or Tab also has same behavior) followed by Ctrl-W work for saving changes Thanks, Rob Just to add to what Cetin said. There are only two ways to save buffered data. [1] Use an explicit TableUpdate() call. (works in all scenarios) [2] Move off the current row (applicable only when ROW buffered). Neither Enter, CTRL+W o ...Show All

• LRA Form Calling Report - Can Form Variables print on report?

  I have a form where users input a due date and comments into two fields. The users then click on a "Run Report" button that issues "REPORT FORM REPORTS/PD_LETTER TO PRINTER for next_due < THISFORM.p_date.value" command to print the report. Is there any way I can use the values the user entered in the form fields in the report that is generated. The form is a past due letter and I want to print Due Date and comment field from the form on it. On the report I created Variables that have the same names as the fields on the form, but this did not help. I suspect that I'm making this much more difficult then needed... Any ideas Derek Sure, there are 2 ways to do this. 1) For example, say you have a textbox on the form called txtCu ...Show All

• RMarmion Unknown Classes Loaded in Memory

  I just realized a problem that we have been having and now I finally found out why. Now I need a solution to address it. The gist of the problem is that we have a Public class based on another user defined class. When we compile the project, the class definition gets left in memory. As a result we cannot delete the files (clean the build folder) without closing out of the foxpro session. If I just compile the prg there is no problem, the problem is only when building from the project itself. I need a means to determine what classes are left loaded in memory (cached I guess) so that we can make our builder release them. RELEASE CLASS ALL does not work. You have to know the class name and the RELEASE CLASS <classname> Our only ...Show All

• Andrea N. CHM Help in VFP9

  Hi All, We have an application that we recently upgraded from VFP 8 to VFP 9. The transition was smooth except that the help file of the application is not working in VFP 9. I have made sure that FOXHHELP9.exe and FOXHHELPPS9.dll are included in the installer. After doing some research on the web, I read a comment on http://fox.wikis.com/wc.dll Wiki~VFP9RuntimeFiles which only says: foxhhelp9.exe /regserver When we type thi command at the cmd prompt, it fixes the problem. However, this is not the solution our users want to see. Can you please let me know the reason for having to type this command, and is there a way I can avoid going this route Thanx, Bini The installer for your EXE (in VFP9 generall ...Show All

• Mike Riley How to remove redundant phrase in field?

  Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown above or there could be 6. I suspect that the 'common denominator' is the semi-colon, but everything I've tried has failed. Any help is greatly appreciated! You may create a loop (do ...while) and read the field and compare strings, or if you have a limited number of phrases you may use in loop, function ...Show All

• ti_m How to preview the data from formset to report designer?

  Hi I have problem setting the exact information from formset to report designer. For example There is re_depot field in the tnrepair.DBF. In tnrepair table, there are inputs such as CHEM, CPDG, SHOC, PTGS, etc… I key-in CHEM in the textbox on the formset and then CHEM is preview on the report designer. The coding is “ report from report designer for re_depot = thisform.textbox.value while not (deleted()) preview “ As for this coding, it cannot get to preview when after I click the command button. Why cannot it work well Thank you.   MillBear wrote: I have 2 textbox for dates input to select the dates while preview the list of r ...Show All

• abcdefgqwerty2 ? FoxBase Report Form .frm Conversion

  Does anyone know of a foxbase report form conversion software I have a customer in need. The file extension is .frm and I can't find anything on it. Thanks to everyone!! Foxbase .frm files have been pretty well abandoned. I think the last version of Foxpro that could read them was 2.0 (but I could be wrong there). You may just have to re-create it. Fortunately, with the modern report writer that should be a snap. >> The file extension is .frm and I can't find anything on it. That is not a standard VFP extension - it is a dBASE report and there should be at least one other file: dBase Report Extensions are: .FRM, .FRG, .FRO I honestly don't know whether VFP wil ...Show All

• milann how can i get local ip from vfp?

  how can i get local ip from vfp I know "ipconfig" way, is there another way thanks If you can use the MSWinsoc ActiveX control: oSock = CREATEOBJECT ( "MSWinsock.Winsock.1" ) oSock.LocalIP   Take a look at " What's my IP Address " by Paul Mrozowski. (PDF) Ok ,thanks, is there another way (in ideea that i don't want to use MSWinsock, i am not so familiar with that) . ...Show All

• Vayse_Dev cryptography failure

  I use _cryptapi class of the _CRYPT class library to encrypt limited amount of information: ids and passwords. They are in a table and the table feeds treeview items on demand. Before appearing in treeview the field values are automatically decrypted. Everything has been working fine until I noticed a problem yesterday. I have done most of development on C: drive but recently began moving the whole project to a G: drive since I set a new OS up on that partition. It is a bootable partition. If the encryption done on C: partition it can only be decrypted on that same partition. On partition G: everything is garbled. If I encrypted an item on G: partition I can decrypt it only here, it will be garbled if I run the application on C: I ch ...Show All

• V1ad Genral question about FoxPro

  Hi, I'm using VFP 6.01 ODBC driver to connent perform querys, etc. When I'm using VFP 9.0 i'm and creating a query with the "query wizard" the query take less time then it's taking me (i'm using SQLExecDirect). what can I do to get better resualt can work with FoxPro driver directly Or maybe OLE DB is more efficient I have someother question can i get the number of records returning from the query Now i'm using A Count query to get the number or recods. Thanks Ishay What are you connecting from If you're writing VFP code and talking to VFP data, there's no need to go through either ODBC or OLE DB. Tamar Both ODBC and OLEDB drivers are f ...Show All

• praveench2k install shield Express & FoxPro 9

  I am having a wierd problem creating my install with install shield Express. I seem to be creating the setup file okay and it is even installing good and running the app good, with 2 exceptions. the shortcuts that are created on the desktop and the start menu are only available for the user profile of the person who installed the app. The program seems to execute only when the installing person not anyone else. Even if the other person is an administrator. Please help I am new to this Install shield, before I used VFP 6 with its own installer. Thank You in advance. You may check if the users have enought rights to install software. Hi, You got to select "Customer Information ...Show All

• Blue-Fire File is in use by another.

  When getting an error "File is in use by another" - Is there a way to trap what file is this I am using the sys(2018) but I don't get any info in there. Thx. Aleniko wrote: When getting an error "File is in use by another" - Is there a way to trap what file is this I am using the sys(2018) but I don't get any info in there. In what context are you seeing this error >u can use the following command >if file("filename.dbf") No.This function only checks for the existense of the file on disk, not if somebody is using it. You probably  where thinking of IF USED() but that only works within the same program instance.   If a ...Show All

• DrJoness Why my VFP exe file cannot be launched?

  I complied my program under VFP6 into an exe file in the program folder. But it cannot be launched. I believe there is nothing wrong with the code, because I just made a minor change. The funny thing is that if I copied the file to other folders on the same drive, it works! And even more wear is that some old version VFP exe files could not be launched from within that program folder, either. I have to copy them out to test. It only happens to VFP exe files. Other exe files are OK. It did the same with VFP9. Any idea what could be the problem VFP .EXE files require the appropriate VFP runtime. It sounds like you don't have these in your Windows PATH. Note: If you compile ...Show All