Answer Questions
xelax report labels
hi all,im making new reports during run time according to users actions.for example he selectes some fields from comboboxes then he puts in a text box a value that is for the "where like.."and i save the results in a temporary table.from that table i create report and the i report form to print the new report..the problem is that the new report has as labels the names of the fields..for example if the field name is costomer_id it shows costomer_ ...Show All
NG from NEMMCO Need solution for complex query
Hello, I am having trouble in getting the expected results. I have two tables as below. I need Idno,transdt,cd,cycdt,amt from joining two tables. The criteria is that if the transdt greater than same month of cycdt then we need get the next month cycdt and corresponding amount for that, if it is less than or equal to same months cycdt then get the same months cycdt and amt. Cd is dummy field which can be anything. I am using foxpro 6.0 id ...Show All
Bijesh Limit edit box
I have a issue with an fox app where I need to limit a editbox to no more then 3 lines of 40 characters. three text box controls will not provide the word-wrap support I am looking for.. Is there away to do this chris krelle Actually the MaxLength property deals with the TOTAL number of characters so 3*40 will be 120 characters total. That could be 120 characters on 1 line or 1 character on 120 lines. Unless all of the Carrage Ret ...Show All
Palace Changing Report Label Text At runtime using ReportListeners
Hi, I want to change the Text of the Labels in the Report using Report Listener. My exact scenario is like this. The application which i am working is a international product and used in various languages, i want to change the report Text, Label and Static Text to the Corresponding Language selected in the application. Is there any way using ReportListener we can dynamically change the static content in the Report especially Labels and ...Show All
Jonathan Bower Visual Foxpro tables locked by aspnet_wp.exe process
Hi! I'm currently using Visual Foxpro 9.0, .NET Framework 1.1, Visual Studio 2003 (VB) for web development. Everything's fine except this little 'quirk'. When i'm doing some testing, and try to open a table with VFP, i have the following message :File access is denied .... with the path of the table. The first solution i found (not very practical in a running environment) is to run a cmd-line and type iisreset to release any ...Show All
Kutijevac Set Skip To Problem
I use two methods to allow the user to browse through my database - custom form with standard top, prev, next, and bottom buttons - browse windows My database has 11 child tables each with a 1-to-many relationship. In order to be able to use the LOCATE command properly with the child data I would have to set up all the relationships with a SET SKIP TO command. The downside of SET SKIP TO is given here (from MSDN): When you skip through the pare ...Show All
acal675177 a child form needs 2 clicks to close
I have a form calling a secondary form. In order to close the latter I have to click twice the button that has the following statements in the CLICK method: ACTIVATE SCREEN "CLICK fired " THISFORM . Deactivate () THISFORM . Destroy () THISFORM . Hide () THISFORM . Release () 4 statements are there out of desperation. I tried them separately and in many combinations. I see on the SCREEN that the event fir ...Show All
Negyoshi Change my languaje menu
no hablo ingles, quiero cambiar el idioma del menu principal de Fox pro 7.0, pues aparece en ingles. i dont speak english, i want a change the language fo my foxpro 7.0, because is in English and i want in spanish you cant help me please quiero cambiar el idioma del menu principal de Fox pro 7.0 Sabe usted que hay un foro espanol en http:// www.portalfox.com Pienso que hay una version espanola d ...Show All
Jeremy Vianna Spell checking?
Well, as sort of a follow up, I am using the ActiveX RTF for one of my forms. What I'd like to know if there is a way to do sort of a spell check for what a doctor would type into it. Any one know I want your sample code too. It is a neat idea. Will this method highlight the misspelled words in RTF There is also another option: APSC - All Purpose Spell Checker which is also downloadable: you can find it on the web. It will have to be ...Show All
Joannes Vermorel - MSP Help with a form
I have a form that has 9 text and combo boxes on it. I want to send the info from all 9 boxes into a tabel called call_log. Pretty easy. I will list my boxes in order they are filled out in red. Date (textbox) User ID (combobox) Windpark (combobox) tower (combobox) code (combobox) desc (textbox) tech called (option group (yes and No)) tech ID (combobox) comment (memo) here is my database and tables Database= windvane Table= call_lo ...Show All
-Matt- Cursor Adapter
Good afternoon gentlemen. First, it forgives me the weak inlges. I speak of Brazil. It would like to know, if it goes to exist updates in the one in the Adapter Cursor. A SP(n) for example. I felt lack of the possibility of being able to make relationships between the cursors to adapter. Thanks, Itamar Bom dia senhores. Gostaria de saber, se ja existe, ou vai existir, algum update para o Cursor Adapte ...Show All
CGSReddy How to upgrade a menu from FoxPro for DOS
I'm a very old, retired, CCOBOL and ASSEMBLY programmer with some experience with dBase and FoxPro from the command window. A charity has asked me to get an old FoxPro for DOS program working on a donated used computer which contains VFP6.0. I have gone over the data files and they seem to be OK. The indexes have been converted to CDX type and that works. The old DOS program worked by relying on append and browse commands which all work. The nee ...Show All
Zarryn Enhancement Request: Ability to pass cursors as parameters
The ability to pass a cursor to a method of an object belonging to another data session would be a great addition for a future versions of VFP. Today, we have to resort to arrays, which is kind of a kludge, or CursorToXML/XMLToCursor, which is way too slow for large data sets. If cursor could be passed between data sessions, n-tier apps would benefit greatly. Any thoughts Eyvind. Eyvind, Since VFP5 what I do ...Show All
GlennF How to select data from one table which is NOT in the other table?
To say I have 2 tables, one is order list (A), and the other is deleted order list (B). I want to display non-deleted order information, which is (A - B). How can I do this in one statement The A and B has different table structure. Thanks, Scott Thank you very much. This is what I need. It's not clear what you're asking. A sampling would be better. Is this ...Show All
AVPimble Unexpected disconnecting of remote connections under VFP 9 SP1
I have problem with unexpected disconnecting of remote connections under VFP 9 SP1 runtimes (only under SP1 runtimes). For example, using _VFP object to access forms will cause this and I am analysing other situations. Using _SCREEN object does not cause this. Does anyone found this too and in what situations Using SP1 was however enforced by huge list of serious bugs in production version of VFP 9... Because this pr ...Show All
