Answer Questions

• saqib shahab baloo Report Variable : sub totals are multiplied by times the report is randered

  Hello there, This is my first post on this forum so i will be descriptive. I am using visual foxpro 9.0 sp1 with postgresql 8.1 for the db, i get the base of my report with sql result. The report that i do need sub-totals based on the customer changes. So i have a table of all records which is indexed based on the customer. When it changes i print the subtotals. This table has 5 - 8 child tables (details of customer, details of tariffs, ge ...Show All

• Shawn Ju report export to excel differs from print preview and print

  When using Visual Foxpro 8, I notice that my subtotals based on 2 report variables that calculate sums per group in the 4th data grouping are continuing to accumulate instead of resetting after each group when I export to excel but appear fine when I do a print or print preview.  I tried deleting and re-adding the grouping only to get the same result.  Strangely, I also notice some of my text labels have also shifted over to the r ...Show All

• CBrosto unsorted records in grid control

  I just noticed it yesterday after working with grids for about two months. Until yesterday, I realized, all tables or aliases I connected to grids were presorted meaning that their record NATUAL order was always alphabethical. It is a different situation for me now. It turns out when I SET ORDER TO TAG <tagname> before I connect a table to a grid's .recordSource, the records appear in a nuatual, unsorted order nonetheless. If I use this ...Show All

• TonyV Memo file is missing or invalid

  Hello, I have a DBF file an I need to open it. I have VFP9.0 and when I try to open it I get a message suc as: "Memo file C:\....\myfile.fpt is missing or is invalid." Is there a way to open this file I will deeply appreciate advices or ideas.. Thanks. Did he gave you the .FPT file also Hi Cindy, Apologize for my english. My question is: How if I don't know the exact name of the colu ...Show All

• Wolf Foxpro problem I think

  Hi, I have made an program in foxpro wich will archieve mail. what I do is I first export the mail body, sender, etc to text files with vba and than get them back with foxpro, but sometimes the layout changes when I put it back. Has this something to do with that I exprot them to text files or is it something different please help The font style and stuff like that so the layout of the e-mail i ...Show All

• Aruna Antony FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02

  Hi there. I just installed a Visual FoxPro 9.0 and started "playing" with it. Tried to create a table - it is straightforward and then a form. It seems to be a rich platform. Something puzzles me though. I do have extensive experience with Visual dBASE PLUS and previous versions in terms of OO language and form/table designer. Thus I am trying to compare. I am attempting to migrate to MS software/platforms wholesale since the dBASE is offering l ...Show All

• Whofungpoo editbox control snaps.

  It is a fairly mild problem but still an inconvenience. I have an editbox and a text is assigned to it in the following manner: THISFORM.Pageframe1.Page4.Edit1.ControlSource = "(ThisForm.cData)" All other operations are done programmatically. I may force it to count the number of lines and go to a specific line and highlight it. It does. But then after a while, perhaps in about 2 minutes, it snaps to the first line (beginning of ...Show All

• bin joy How to upsizing a database using command lines???

  Hello! I want to ask you, if is possible to do the upsizing of a database using command lines! I can do that with TOOLS --> WIZARDS --> UPSIZING but I want to obtain the same result by the code! THERE'S ANYBODY THAT CAN HELP ME Thank you Using wizard, instead of making the upsize (or with it) select 'Save generated SQL' in last step. Then check code in SQL_uw.ScriptSQL ...Show All

• Maysam MSComctlLib.TreeCtrl.2 BackColor ???

  MSComctlLib.TreeCtrl.2 does not have BackColor property. Is it possible to define one (it is of course possible) and actually make it functionable Thanks. And how did you know that this yellowish hue (255,255,192) is my favorite color for background in treeview contols! The problem, however, is that this color may be your end user's least favorite color and they absolutely HATE it. This is why there are settings in the Wind ...Show All

• KluchDev Win32 API function

  Hi, Can any one tell me what should be the shift and control key values in the below stated code. #DEFINE VK_lSHIFT 0x10 #DEFINE VK_lCONTROL 0x11 DECLARE INTEGER GetKeyState IN WIN32API INTEGER What should be the value of GetKeyState(VK_lSHIFT) and GetKeyState(VK_lCONTROL) I am getting different values(both +ve, -ve & 0) every time I press shift or control keys down. I want to use this in a controls click event to check for i ...Show All

• Pavel Kaufman weird IIF output. Help!

  I was using IIF to perform simple calculation: I have a data base field "case" if the case = 0, I want to display 1, otherwise, show the database data I use SELECT IIF(case > 0, case, 1) FROM table However, the result is very weird. If the case < 10 (1 digit), the result is correct If the case > 10 (2 or more digits), the result shows "**", When I try to display it with strings IIF(case > ...Show All

• Balashanmugam Foxpro is DBMS or RDBMS? and Why?

  I will be verymuch thankful if one can give me answer with example. Jagannath DBMS = "Database Management System" RDBMS = "Relational Database Management System" Visual Foxpro is both. It is a database management system, and it can handle and manage relational data. Excel is an example of a DBMS that is not relational Thanx Sir. Jagannath ...Show All

• Kegel editbox programmatic change

  I am looking for an easy way to determine if I've made interactive change in an editor box. The issue is that there are about 16 controls on a container, they are initialized from a table record thus their values at activate time generally are not trivial default. I have to save the changes with a SAVE button if I made any but I want this button's click method to quickly determine which control values have been changed. I do not want to do REPLA ...Show All

• Sundown Kid Microsoft treeview: Newbie Question

  I'm using VFP6 with Microsoft Treeview. I have a little newbie doubt: Can I programatically collapse and/or expand a tree node What command do I use in order to do it Thanks in advance.   Mark.OSVATH wrote: It's simple. For example: ThisForm.TV.Nodes.Clear ThisForm.TV.Nodes.Add(, 0, "ListRoot", "Lists") ThisForm.TV.Nodes.Add("ListRoot", 4, "Lists", "Printable lists") ThisForm.TV.Nodes.Add(" ...Show All

• Luke Barker Date problem in VFP 6.0

  Hello! Huh, I currently have field named 'fine' in my DB. It's used to store fines. There two other fields, 'rent-date' and 'no_of_days'. The first one stores the date on which the rent of a book starts and the second one stores the number of days the book is going to stay with the borrower. Well, I would like to know how can I calculate the fine. To calculate it, I must find by how many days the due date has been "excessed" and ...Show All