Answer Questions

• EBN Help with adding a button to a grid column programmatically

  Help     I am working on a VFP 9.0 app that has a grid that shows 3 different sets of data depending on a radio button selection. This is why I need to do this programmatically. I need to add a command button to one of the columns. I can add the command button using the IDE and it works fine. But when I add it using the following code all I get is a grey background in the column. I thought it might be because the command butt ...Show All

• Coroebus How to play a Windows Media Audio format (WMA) in VFP?

  Hi all, I am now trying to create a small program to play media audio files. I'm now using the MultiMedia ActiveX control (mci.ocx) to play these files but this ocx seems can not play WMA files while this type of file is getting more and more popular to music-lovers. Could anyone tell me how to play WMA files in VFP. Note:I want to play them directly in VFP with MCI control or with some API function that VFP can handle,  ...Show All

• Jose Raul Treeview stops answering

  Hi, all. I'm needing some help with a rather strange problem: I have a form with aTreeview (ActiveX Control) in it. There's a routine that calls another form. Funny thing is: if I trace this routine and form (using the SET STEP ON command) it works perfect. On the other hand, if I run it normally, when I lose the second form, the Treeview stops responding to the mouse, I.E it doesn't scroll or allow the user to click a node. I have no ...Show All

• Wilka Grid objects problems/questions

  Hi everyone. I've just started using Grids in VFP9. I am trying to setup a grid which will collect info about an order. The record source of the grid changes depending on the user. I use the temporary table in the users 'home' folder in order not to conflict with other users. Here are my questions: - First, what is the best way to have a temporary file used in my form: Do I add the table to the dataenvironment at runtime Do I issue 'USE' comm ...Show All

• Eugene Zabokritski Multiple records update

  I am a novice at this and I am trying to update the contents of one table with those of another. This is a multiple record update. I am using a query similar to this: update Articles; set Articles.Path = (select Oldart.Path from Oldart where Oldart.id = Articles.id); where exists (select Oldart.Path from Oldart where Oldart.id = Articles.id) The goal is to update the "path" field in the new Articles table with the corresponding record in the old ...Show All

• erase_ego Update of Redistributable Package from VFP9 to VFP9 SP1

  Maybe I missed an knowledge base article. We have an app, already installed using VFP 9.0 out there. On our development machines, we've updated to VFP 9 SP1. What do we need to do to roll the SP out to the users Do I have to re-run the setup to create updated vfp9t.dll and vfp9r.dll files And then can I just have a script copy them out to the appropriate directory at the end user's workstation, and then run regsvr32 vfp9t.dll regs ...Show All

• tcoop Populating a grid - strategy.

  Hi all - another newbie question: I'm trying to have a grid populated by a sql statement. I am wondering if the proper strategy is to create the grid in the form designer by dropping the original table from the DE into the form, and then tweek the fields, record source etc, or do the whole thing in code Thanks, Aleniko I am looking to have the grid provide a drop down box to show all the countries when it ...Show All

• mark anthony panizales Updating to memo fields in Foxpro through ODBC using PHP

  Hi everyone, In advance I wanted to thank you for your time in replying to my post.  My company is trying to integrate their current foxpro databases with PHP.  I am using ADODB on the PHP server and connecting using an Visual Foxpro ODBC driver. We are running into an issue where foxpro doesn't allow us to update to memo fields over 255 characters.  I ran across a link , but since I am working in PHP I'm not sure if it applies ...Show All

• estoniaman creating tables programmatically-some questions

  I have decided to create some tables programmatically since they most likely will be used temporarily. I do have a number of questions pertainint to CREATE TABLE paramaters. I could not find any explanations so far to figure out what they meant. First I assumed that CODEPAGE should be 1252 (Windows ANSI). Is it the right choice I want to create tables FROM ARRAY arrName I understand that arrName is a 2-dimensional array with the same numb ...Show All

• guy87 column summation

  To all fellow foxpro enthusiats, If i have a table that looks like so, year enter exit net 1995 1 0 0 1996 2 1 1 1997 3 2 1 1998 4 2 2 1999 5 1 4 2000 10 3 7 how would i make a new row at the bottom, where i sum up the columns.. like --> year enter exit net 1995 1 0 0 1996 2 1 1 1997 3 2 1 1998 4 2 2 1999 5 1 4 2000 10 3 7 TOTAL ...Show All

• steve smith Help in VFP 6 Application...

  Hi, I've developed a application in VFP 6.0 in Windows 2000 Server Env. The problem is that if I start the application. the splash screen shows up... but with the Command window and the standard toolbars in background..... I tried with application.visible=.f. But it imposed several limitations in my applications.... So is there any way to get around this situation..... One more thing I wanted to ask is what is the be ...Show All

• Chris Nieboer Selection of multiple rows of a column in Grid

  Hi, I am a newbie and using FoxPro 8 in XP. I was wondering if we can select multiple rows of a grid column using the shift key. I have a combo box in one column of a grid. I want to fill several rows at a time with the selected combo item. How can I select multiple rows of a column It should be just like how we select multiple controls at a time in a form to change the font style or size etc. Can any body please give me a hint or source ...Show All

• first_ Return values from SQL Serv

  Please let me know: 1. Can I receive a return value from SQL Server (Ex: when I update some data to SQL Server by using a SQL's stored procedure, the return of the stored procedure is whether the primary key exits or not) 2. How can I do that Thanks a lots. Chinh Nguyen I've missed the 'EXEC' in the command. Thanks alot David. Chinh Nguyen Hi Dave M. ...Show All

• ralfkret MySQL and VFP9.0

  Hi. I don't know how to make a connection to MySQL. I used Connector/ODBC 3.51.12 to connect to MySql with no responce. When I clicked on OK after I set up parameters a massage was displayed like User Cancled. Don't know what to do... Can anybody help me Has anybody experience with connectivity with MySQL I have an idea. Can you make a sample project with a database connected to a MySql database. I was told via Connector/ODBC 3.51.12 it'll ...Show All

• Lues Foxpro in Visual Studio 2005

  Hi  . Why Microsoft dont develop Visual Foxpro . and why Microsoft dont create Visual Foxpro in .NET Freamwork ThankX. Skyline . Why do you ask your first question is something of a mystery. All you have to do is a little search online or just look at MS site and you will see that Microsoft has been updating/developing Visual FoxPro regularly every 18 months or so for more than 10 years! The current version is 9.0, released i ...Show All