Answer Questions

• Dan Heidel Southwest Fox 2007

  Southwest Fox 2007 October 18-21, 2007 Arizona Golf Resort and Conference Center in Mesa, Arizona http://swfox.net It is our pleasure to announce the fourth annual Southwest Fox Conference, presenting the latest in Microsoft Visual FoxPro development techniques, new changes in VFP 9.0 SP2, Sedna Components, and interop with other technologies with sessions from some of the best and the brightest VFP speakers. This highly acclaimed and popular conference is the perfect venue for VFP developers interested in learning more about VFP, further refining their software development skills, learning how to better run a consulting firm or IT department, and being a better software craftsman. To this end, there wil ...Show All

• Tryin2Bgood Visual Foxpro report writer

  I have a dbf with following fields bill no, bill date, cust name,item name,qty,rate,amount and i have 553 records. i want a simple report on 132 column stationary. i dont want totals also. (so no page footer or summary). i used visual foxpro report writer. but the report does not print with proper ejection i.e. second page starts printing from bottom of first page and third page prints from bottom of second page and so on. printer is absolutely fine because documents from excel and word print with proper page breaks. can anybody help No, I am using visual foxpro'r Report Writer. i think i have to select the paper size 8.5"/12". i was selecting us std fan fold which is 8.5"/11". 132 column stati ...Show All

• fraser_foo Form behavour different if launched from menu or click event?

  I am having a strange problem where the behaviour of a form differs if a form is launched from a menu or from say the click event of a button. The form is top-level with a default data session. I have a few variables that are assigned as control sources to some textbox controls. I am using the destroy event to perform some updates using theses variables. This allows the update to happen regardless if the user clicks the exit button on the form or the title bar. The problem is that the form behaviour seems to vary depending on how the form is initially launched. From a menu the above works fine but from a the click event of a button the variables are not available in the destroy event Does anyone know why the behaviour is not consi ...Show All

• furmangg Underlining commands

  I just recently switched from VFP 8 to 9 SP1. When I type a command in the Command Window or in a program, the command is underlined as I type. Is there a way to turn this off I don't remember this happening in VFP 8. Thanks in advance! That was exactly what I was looking for! Thanks! This is the new "background compile" feature. It helps you see whether the line, as it stands, is valid. You can change the behavior or turn it off in the Options dialog. Tools | Options Editor tab Background Compile I'm using the Red Inversion setting and appreciate it. Tamar the red inversion is awsome :)... i hated the underlining. ...Show All

• abc_acb Arrange the "character string" numbers in order

  I use the character string for number input. What Syntax should I use to sort out the “character-string” numbers as below For example: To sort out according to the number 1 1 12A 3 3 4 4 5 443546 12A 5 443546 555AB 555AB Thank you. Lakshminarayana, I didn't make a comment on your code. If you reread my post I had already suspicions about sorting logic. If you want me to comment on your code then here we go: It doesn't make a sort as you think. Try expand ...Show All

• GeoffNin Foxpro7 crashing with "fatal error exception code=c0000005 ..."

  Hi I have a tricky issue in my VFP7 application. At least tricky for me.  The application is crashing with fatal error C0000005. Sometimes I see a message like this one in the eventlog: "Faulting application <appname>.exe, version 1.4.82.0, faulting module ntdll.dll, version 5.1.2600.2180, fault address 0x00010f29.". Sometimes the application just hangs. I also see the Windows error "The instruction at "0x...." referenced memory at "0x.....". The memory could not be "read"", and then the application is closed, of cource. The error does only appear in situations where I print, but it does not occur in an exact pattern, or when I pass a particular code line. I use a third party dll called foxpp.dll ( ...Show All

• Ultrawhack Excel to cursor SPT problems

  I am using a SPT solution to take information from a .xls file and importing it to a cursor with this solution: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=509710&SiteID=1 However, I am now receiving problems where before I had not. Now I am getting Error 1466: Connection handle is invalid. Any ideas guys I can't see what the problem is but it occurs at the sqlstringconnect( ) line. Thanks! No it wouldn't be guaranteed to have a sheet name as Sheet1. Even if it would you're not guaranteed to have a table on excel (to excel every sheet doesn't contain a valid table that it could export via SPT. There are rules for it to accept a region as a valid "data table"). End users behaviors are always different from ...Show All

• Anwar Hussain Report help?

  Hi there I was wondering if any ones can help. What will be the report builder expression in vfp to access a single FieldList (text2) from table (mms) where the condision equals to (field="02") I tried using: SELECT text2 FROM mms WHERE fileid="02" in the command runner in vfp and it gave me the correct result. But when i copied n pasted it in report builder as an expression it gave a syntax error. Any ideas Thanx for your time. Bobby thanx for the info ;o) Bobby, Typically in VFP reporting is done by using a SQL select to get your data all together into a reporting cursor and run the report with that cursor as the input. SELE ...Show All

• Bill_Henning Fonts, ? and set alternate

  Hi; I have lots of older code that uses commands and set alternate to create a text file and then it uses modify command to view the file. I have noticed that on my development PC, this created a file with Fixedsys font. On the installation pcs the font is "Courier". Is there a way to determine what font will be used when issuing commands to a set alte file I know that I can use the font clause in the command itself but I was wondering what determines the default font used. Thank you all for puting up with my "oldie" questions. Andy; Thank you so much for all your help. I feel like Mcflie senior from "back to the future" going "This is good stuff". ...Show All

• Ather. using INPUTBOX()

  hi guys...is there a way wherein i can make the text in the input box to be hidden like in password i need it asap..thanks for me i will call another form pop-up then user input password. in tis case inputbox not suitable. HTH I think he meant show what the user types in the textbox as asterisks just like a password entry. I don't think that's possible with the INPUTBOX() function, you could create your own form to simulate this though. Either put nothing as default value or just put a series of asterixes. ...Show All

• chrisc12345 Copy classes or subclass from a classlib

  I am obviously still learning and making changes in my original classes in my first application. I have a second application which I am developing now. The second application will need to use classes similar to the first application, but some classes will require  minor and others major changes. I'm not sure if I should copy the classlib and modify it for the second application, or sub-class from the first class lib. Also, is there an easy way to copy individual classes from one classlib to another Please keep in mind that the first classlib will be modified heavily in the future. Any ideas for a strategy would be greatly apreciated. If these are un-connected ap ...Show All

• Orchid2006 uniqueness of index <insert index name> is violated.

  Hi, i'm making batch changes to several of our foxpro databases using C# and ado.net. Basically i am consolidating many lookups into the same key across multiple databases. After moving them to the proper id and deleting unused id's, i go and find out from all of the databases what lookups they have, compile them into a uniquelist and then make sure that every database has that row. My problem is that once my consolidation happens and it deletes unused rows, i'm trying to add rows that use to be there back in because they're part of my 'master list' and i need them even though they aren't being used... i then get this error even though the record has been deleted already. example id 9060 was not being used, i first go t ...Show All

• Learning VB about vfp9 sp2

  does vfp9 sp2 have bugs a month ago,I installed sp2,but when I closed the cursor (got by SQLexec() from SQL Server),the IDE opened a dialogbox containing mistakes,then the vfp9 IDE closed right away, thank you very much! SP2 is in beta yet. SP2 is still in Beta stage. By definition it is not ready and it may have bugs. That is why Beta testers install the software to report on problems they may find. Never install a Beta version in a production system and do not install a Beta unless you are prepared to test the heck out of it. For the latest bug info in VFP SP2 see: http://download.microsoft.com/download/a/b/3/ab3fd0de-74e9-4b0e-9510-82e9bd3a49e4/VFP9SP2_OctCTP_FixList.htm   ...Show All

• Vladimir Chtepa Web Service

  Hello eveybody, i need help with web service, i stay consuming a web service in visual fox pro 9, i need to update the dollar value in CR automatly in my database, my database is dbc fox native. Who can help me. You need to be more explicit in what you ask. I was wondering what does Crystal Reports (what is understood in software development when you use the abbreviation "CR"), with what you were asking. After receiving your personal email I understood you are looking for a way to use a web service that gets you dollar quotations in Costa Rica. As I already replied to you, you should always post questions in public forums so everybody benefits and your question gets exposure to potentially many answers. Private problem solving i ...Show All

• saulotmalo Printing Rich Text

  Hi, all Can anyone tell me if I cam print th content of a Rich Text Box In case I can't, is there any way to print formated text (i mean, with justification, italics, bolds, etc..) Thanks a lot oRTFForm = Createobject('myRTFPrinter') oRTFForm.Show(1) Define Class myRTFPrinter As Form Height = 600 Width = 800 DoCreate = .T. Add Object RTF As OleControl With ; Left=10,Top=10,Width=780,Height=550,; OleClass="RichText.RichTextCtrl.1" Add Object ComDlg As OleControl With ; Oleclass = "MSComDlg.CommonDialog.1" Add Object cmdLoad As CommandButton With ; Top = 570, Height = 25, Left= 10, Width = 100, Caption = 'Load' Add Object cmdPrint As CommandButton With ; ...Show All