Answer Questions

• Andreas Maurer Dynamic menus

  Is it possible, in Visual FoxPro, to implement a dynamic Windows menu whereby I could add my forms to the menu when they open and remove them when they close Yes, you can create, add and remove menu pads, bars, items programmatically. See: Menus and Menu Bars http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/273991b4-0bcb-426e-9052-ef7dda0507a4.asp frame=true   You could use a better menu generator: GenMenuX, a free tool to conditionally add/remove menu items : http://fox.wikis.com/wc.dll Wiki~GenMenuX Hi I build the menu dynamically from a table. The required tables will be created with some sample ...Show All

• RamyaP 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. SET DELETE ON cInput = SubStr(thisform.textbox.value,1,4) && assuming the length of re_depot i ...Show All

• rottengeek vfp online?

  ok well i found a potential client but he needs an online application...... what should i do about this i know vfp pretty well and the only thing i can do online is save/update records in a file using php and my sql..... is there anyway to incorporate vfp to an online application Try: www.foxweb.com Hi, What do you meant by online, is it web based (HTML) or distributed application You can check out webconnect from www.west-wind.com HTH That would be options (b) or (c) above. Look at the articles indicated above, for building distributed applications that access the web through HTTP. i need ...Show All

• Sean K. Campbell SCREEN RESOLUTION

  HELLO EVERYBODY, CAN WE SET RESOLUTION PROGRAMATICALLY IF YES, PLEASE TELL ME HOW HELLO EVERYBODY, CAN WE SET RESOLUTION PROGRAMATICALLY IS IT POSSIBLE IN VFP PLZ. ANSWER JUST YES OR NO. If you want to increase the size of your forms to fit a bigger screen (i.e. more resolution), you can have that functionality as part of your OOP framework. Look at anchors, hook to the the resize() event and method, letting the user drag the corner of the form to resize it, and use bindevents to trigger each control's resize. But you do not have to. If you do not have a framework aleready to do this, it's a lot of work to create it for the first time. Is it worth it ...Show All

• Zero_ using tow field index with codebase

  Hi, I'm using codebase to create table and index and i use VFP 9.0 to open the table and execute querys. when i'm creating an index for one feild : "CREATE INDEX ind ON person(age)" every thing works fine and there the index is working well. when i'm creating an index for two fields or more: "CREATE INDEX ind ON person(age,name)" VFP cant open the table. what seems to be the problem thanks ishay Can you tell the first byte value of table file Is 0x30 Beginning with vfp8 is something changed in table header(AutotIncrement) who can affect compability with codebase. the first byte value is : 0x30 Your not ge ...Show All

• brohans Cannot update table on VFP9 connected in peer-to-peer network

  hi guys...im having a problem when it comes to updating a table on VFP9 connected in a peer-to-peer network..i have already created a drive map (Z:\) and then i tried to open the application on both computers and it worked..but when i tried to perform changes like append and replace which updates the data,it says "cannot update cursor <tablename> because it is read only"..how will i be able to update and made some changes to the data please help me guys..thanks :) A table (cursor) is readonly when: The DBF is included inside the EXE (check 'exclude' in the Project Manager). The Windows file attribute is marked as R/O. The user does not have sufficient write access or perm ...Show All

• Jason Zhang Browsers Insert html in my code

  I'm useing foxpro to create content for my webpages, I insert html code into a memo field. then a web page will grab the data. I like to use ascii characters to keep my code tidy so I can read it when its a web page. My problem is that the browser reads the ascii text and inserts <BR> messing up my javascript. What can I do i.e. Javascript = "function AlertMe() { "; +chr(13)+chr(10)+" Alert(' Alert! ');"; +chr(13)+chr(10)+" } " after browsers: function AlertMe(){<BR> Alert(' Alert! ');<BR> }<BR> RESOLVED! chr(13) will place a <br> in the script. chr(10) is suffecient enough to move the code to the next line and help readability ...Show All

• Dotnet007 VFP and nonlinear regression

  Dear friends! I need to use same statistic methods, as nonlinear regression. Do you know same library or function witch I can use Can you help me Thank you. You may use Visual FoxPro to call an Excel worksheet through automation.(Example: Olexl.scx). You may call a Trend function to perform a regression analysis. You may also to build your statistic functions: http://statpages.org/nonlin.html ...Show All

• ggsubscribe Connect to Outlook Express and Microsoft Outlook

  Dear Expert, Can I know how to connect to the Outlook Express and Microsoft Outlook using FoxPro Like the data in a memo feild how I connect or send out using the Outlook Express and Microsoft Outlook Or Can I generete email using FoxPro Thank you.     CetinBasoz wrote: PS: I had the luxury to meet both of them in person and they are very nice people (nicer than you can think of - as many others in VFP community. Greetings to all of them with this opportunity:) Hi Cetin. Aw, shucks! Hopefully we will have the chance to meet again f2f in the future I have configured the Outlook Express perfactly. & able to send/r ...Show All

• JoshMartin Cannot update table on VFP9 connected in peer-to-peer network

  hi guys...im having a problem when it comes to updating a table on VFP9 connected in a peer-to-peer network..i have already created a drive map (Z:\) and then i tried to open the application on both computers and it worked..but when i tried to perform changes like append and replace which updates the data,it says "cannot update cursor <tablename> because it is read only"..how will i be able to update and made some changes to the data please help me guys..thanks :) MarciaAkins wrote: I am sure that you meant to say READWRITE clause, didn't you Funny! Alex Feldstein wrote: A cursor was created by a SQL command without the READ ...Show All

• Ice Age VPF 6: Problem sending the item from the combo to report designer

  Hi all, I have a problem sending the data to the report designer after selecting the data from the pull-down combo. There is a field namely lbl_attname in the report designer. In Click procedure of the command button, if not(empty(thisform.Combo1.value)) lbl_attname = alltrim(thisform.Combo1.value) else lbl_attname = 'To whom it concerns”. endif I tried this code as above but it cannot work. Pls enlighten me. Thank you. I think that I have to explain fully instead of partial so that you will roughly understand what I’m trying to achieve. I set the RowSource Type: 1 –Value of the Combo1 property. I’m not sure whether ...Show All

• svxtc Lost Ability to play wav file

  My racing software has always allowed the user to play a wav file on startup. This can be anything but normally it is a race car going down the track. All of a sudden I cannot get the sound to work Unless I SET STEP ON in the code, or run the form in design mode. It has worked for 8 years just fine, what setting did I change that I don't remember This code works from the command window, a prg, or the design mode.  It will even work with set step on, but the chr(7) is completely ignored during normal execution. SET BELL ON * SET STEP on IF ! USED("SETUP") USE SETUP ELSE SELECT SETUP ENDIF * look under setup, if playmusic is true then * play the dragshrt.wav file SELECT SETUP LOCAL PlaySound PlaySound = playmusic IF PlaySoun ...Show All

• R Raghu Newbie forms/list box/tables question

  We are currently using Visual Foxpro 6.0 (yes, I know it is outdated). We have a simple form which displays a free table as a listbox and has two custom buttons (run/quit). Basically the user highlights a record and selects run, which starts a report form on another free table. This works great when I run the form directly, no issues whatsoever. However, when I try to call the form from a program (do form imenu) the list box shows up as just a big blank box (the table is not displayed). I have tried adding and removing the table displayed in the box from the Data Environment, in combination with adding and removing "use" statments to the program to open the table before calling the form. In either of these cases the table does no ...Show All

• Tryin2Bgood my SQL passthrough problem

  Good day to all, could i ask where i got wrong with this code , because when i run the .prg for this code, at first try it won't work, then the second time around it works, as if no error. Like when you open VFP, then at the command window you execute the do command, it won't work, but at the second or 3rd try it works. Please help...thanks in advance LOCAL lcConnect STORE 0 TO lcConnect STORE SQLCONNECT ('My SQL Server Connection','' ) TO lcConnect && to determine if u r connected to the proper server. IF lcConnect <= 0 && if you can't connect to the specified server then exit. = MESSAGEBOX ('Cannot make a connection to the server!', 16, 'SQL Connection Error') RELEASE lcConnec ...Show All

• steve1976 How to selectonentry an edit box in a grid.

  Hi; I have a grid with 2 columns: a txtbox and an edtbox. For some reason the edtbox won't SelectOnEntry no matter what I do. I've tried to set selectonentry for the column and the control itself. I've set the format to "K" I've set DynamicInputMask to "K" highlight is .T. Nothing works. Any ideas >> No. All I'm trying to do is to selectonentry the memo field which the user tabs into. But in the process, I don't want all the other rows to show 'memo' as their content, but rather show the text of the memo field. Ah, I see! LEt mne look at this, I am sure there is a way No. All I'm trying to do is to selectonentry the memo field which the use ...Show All