Answer Questions

• Mrs. B An icon instead a 'Memo' in grids.

  Hi All; Is there a way to have a grid display an icon instead of memo or Memo for memo fields I'd like to put an icon if the memo field is not empty. Thanks, Aleniko Alex. Thanks for your reply. My main problem though is how to have the functionality of showing the memo content when you hover over the button or control. VFP9 has this feature when you use the usual 'Memo' format. Thx. ...Show All

• sieler VFP & Pocket PC

  Dear experts, I am working on a restaurant ordering system with VFP+MSDE and looking for the possibility to input order via a mobile device. Is there any tool like VFP for Pocket PC Or any suggestion to which language should I used at the mobile side for a shortest learning curve Someone show me with a terminal client installed on Pocket PC, connect to Small Business Server 2003 and run a VFP exe (re-write with large icon and less color ...Show All

• Vivekthangaswamy change language of typing

  Hi All, How can I change the language of typing from the program (which API function is called and how) instead of changing the language directly from taskbar with mouse Thx for your advise. Sandor Torok Hungary #define KLF_ACTIVATE         0x00000001 declare integer LoadKeyboardLayout in win32api string, integer nHKL = LoadKeyboardLayout("0000040e", KLF_ACTIVATE) && Hung ...Show All

• VShaneCurtis Problem with SUM() function?

  I have a table with colums for debit and credit, each column has 2 decimals. I enter in the command window: sum(debit) to x and sum(credit) to y, then x=y. Result: they are not equal. I ask output: x and y, they are equal. Then I type: SET DECIMALS TO 10 and do the same things. Now the output shows me that x is not the same as y. There are differences in the 5th decimal position of x and y. How is this possible My table has only 2 decimals! I ...Show All

• MicHerz Order a raport by a field from child table

  A have a two tables (parent table and child table). The report wizard allows order just, a raport by a field from parent table, but I need to create a raport, which is ordered by a field from a child table. I don't know how. Please someone tell me, thank you.  A second, why VFP9 don't allow to display a Query result in a Report destination   No it does work. It always worked. Just check you ...Show All

• cartoon Leading zeros

  I am trying to create a numeric field without decimals with leading zeros. This could also be a character field as long as the number is right justified. How do I do this Thank you This should also work: cFormattedWage = Transform(nWage*100,"@L 99999999999") nWage = 7533.31 cFormattedWage = Padl(Transform(nWage*100),11,"0") ...Show All

• danmga Which is best?

  Which is better I am thinking mainly in terms of maintainability and readability, perhaps even performance issues. This way  *-- Check overridding the bank account is even allowed If This.lBankAssigned     *-- Bank Account has already been assigned by TCustomer.NewReceipt()     If Empty(This.oCustomer.oProfile.cNominalBankAccount)         *-- Check sales p ...Show All

• Kiran Sattenapalli VFP linked server issue

  We're using SQL Server for the majority of our applications, but our accounting package is still in VFP 8.0.  I need to make some costing adjustements from our inventory program.  I have linked the VFP database to SQL Server just fine and, using OPENQUERY, I can SELECT data without a hitch.  Performing an UPDATE or INSERT, however, is a different story.  I get the following error: "Server: Msg 7301, Level 16, State 2, Line 1 ...Show All

• chubalot Foxpro is DBMS or RDBMS? and Why?

  I will be verymuch thankful if one can give me answer with example. Jagannath Thanx Sir. 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 ...Show All

• Rebecca Karma Vue File Format Structure Needed

  Can anyone help me on where I can find information on the structure and format for the VFP Vue files that are created with the command: Create View MyView.Vue Please thanks, Terry Here's a use case that I had to work up for Tamar Granor, she can't understand what I'm trying to do either.  Her statement that prompted this use case was why can you just not use the information at runtime.  Answer, Runtime doesn't apply wi ...Show All

• Dr. Zoop access to this.propery

  I've made a class 'adreslijst' and in it's init method I added a string property 'lijst' like this:    this.addproperty('lijst', "bla") in an other method ('export_lijst') that I added to the class adreslijst I want to print the contents of the property 'lijst' like this:     this.lijst when I execute the following code:    object1 = CREATEOBJECT('adreslijst')    object1.export_lijst() ...Show All

• Chrystian how to use the sql-left join ?

  this sql is ok SELECT NA.*, DV.YN_CODE, NA1.NA_COMPANY AS NA_1STNAME,NA.AW_LEVEL, SPACE(30) AS MIG_OFFICE,NT.NT_TYPE,AN.AN_TYPE,AN.AN_WRKRID FROM TmpCurs_AllDonors2  NA  LEFT OUTER JOIN TmpCurs_AllDonors3 DV ON DV.CM_ID = NA.CM_ID  LEFT OUTER JOIN NAME NA1 ON NA.NA_COID1ST = NA1.NA_ID LEFT OUTER JOIN NOTE NT ON NT.NT_ID = NA.CM_ID  LEFT OUTER JOIN ASSIGN AN ON AN.AN_ID = NA.CM_ID then how can i add the filter condition f ...Show All

• jeanlucve Found 3rd party software.

  When opening a table that exists in a project I got the following message- Repair the table using an appropriate third-party repair utility for Visual FoxPro tables before opening the table again. What does this mean & how do I find a third-party repair utility   Thanks!!! I found the software I needed.  If anyone else out there needs this info let me know by replying to this post.  ...Show All

• admeralthrawn Clearing a cursor

  I am working with a cursor that I use to import XML information to. When I am done with the XML information, I want to clear the cursor for other input from the same area; however, I am unsure as how to go about this. Any ideas Hi Dave Ahem....if I may be permitted to extend your note.... CREATE CURSOR ( ... ) cursors and those created by SQL PassThrough (SQLEXEC()) are read/write by default. Cursors created by a SQL-SELECT ...Show All

• Baolin Ren Container 'when' method?

  Hi; I don't see a when event for a container. I am using 'gotfocus' but if there is a command button in the container, and I want to prevent the user to click it (in some cases), gotfocus is too late bacause the button's click method already fires. Any ideas how would I conditionally prevent a user access to everything contained in a container Thanks, Aleniko Aleniko, I'd just weigh in with ...Show All