Answer Questions

• Shane_R Translate visual foxpro suorce code in php language

  I see a nice application vfp 9.0, but how i can translate the source code in php language mdinu, That would wholly depend on the VFP application's source code and whether there are equivalents for everything in PHP. If you are looking for some kind of automated converter for VFP -> PHP, I'm afraid there isn't one. However, if there is something specific that the VFP application is doing and you are of the mind to post some of the ...Show All

• circusfire UPDATE vs REPLACE record locking

  The VFP 9.0 Help file shows the following: UPDATE - SQL Command ,Remarks, Tip: "When updating multiple records in a table opened for shared access, SQL UPDATE uses record locking, unlike the REPLACE command." Locking Data, REPLACE: Current record and all records from aliased fields UPDATE - SQL: Entire table These statements seem to conflict. The first leads one to believe that the UPDATE - SQL command would lock records and i ...Show All

• MarkBU remote data

  I want to create a system with 1 database and many users that can access it a solution is the server client model ok lets say we have a database in a remote server(vfp database) i go to each client and make a datasource and a connection to that database 1)the tables of that database will ONLY be viewed by clients through remote views 2)if yes ,i will put the views in the data enviroment 3)if yes,i can insert,delete,update,buffer...etc the views ...Show All

• BBuff Day Time Picker little trouble.

  Back in Visual dBase days we used regular spinners for dates but here in Fox the spinners do not seem to like dealing with anything but numeric values. I placed three day/time picker controls on two different containers that are supposed to become visible or invisible depending on some buttons being pressed. I am certain the pickers' parents are the containers however when I make the containers invisible (setting .visible to .F.) the pickers sta ...Show All

• Aleydis VFP8.0 Chaining Reports

  I have an app that used to run correctly. A few weeks ago I got hijacked and haven't been able to configure the reports correctly again. Here's the scenario: I have an HP LJ 9000 which has the ability to stack and staple and has four paper sources. The app gathers data and then prints a series of summary and detail reports. The summary report is printed on colored paper and the detail reports on letterhead, obviously from two different pape ...Show All

• Dave_W Two questions (about database structure & controls)

  Hello. Today I've stumbled upon two problems I couldn't solve myself. 1. How can I get the structure of a dbf file (in order to make a query for creating the same table in MS SQL) 2. How can I address objects in a form by a cycle. For example    for i=1 to 10       thisform.command(i).caption = str(i)    endif Thanks a lot in advance To get the struct ...Show All

• Eric66 Getting fox pro 6 data into an SQL 2000 database

  Hi, I'm not sure if this is the right forum or not I have a database that was developed in Fox Pro 6 or 7 which is in use on a daily basis.  I want to get some of the tables into a SQL 2000 database and use ASP.net as my front-end. What would be the best way to do this.  Is there a replication agent I can run to populate my SQL DB or is there another way to do this If this is not the right forum please let me know which one to put th ...Show All

• aguyngueran How to set automatically start project folder?

  Hi! I add a picture, in my project, but, when I change my project directory, or when I rename my folder, fox, asked me if I want to change the home directory of my project! I choose yes, and my project run correctly, but, it can't find my picture! I must write getdir( ) at the beginning, to set my start folder, if I want that the project run correctly with my picture! I try the curdir( ) or the home( ) but, this don't recognize correctly my p ...Show All

• Lorenzo Colautti 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 C ...Show All

• Rugby Joe a child form needs 2 clicks to close

  I have a form calling a secondary form. In order to close the latter I have to click twice the button that has the following statements in the CLICK method: ACTIVATE SCREEN "CLICK fired " THISFORM . Deactivate () THISFORM . Destroy () THISFORM . Hide () THISFORM . Release () 4 statements are there out of desperation. I tried them separately and in many combinations. I see on the SCREEN that the event fir ...Show All

• WilliamDGJones cumulative column calculation

  Hello, have question about calculations in visual FoxPro. Have a table ID Sk 1 4 2 8 3 9 4 3 and so on… need to calculate cumulative sum in next column like ID Sk Cum 1 4 4 2 8 12 3 9 21 4 3 24 Do you know how to calculate this column The easiest way is to write some code ...Show All

• Peter Ritchie 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   If you would do that with base tables (I do not r ...Show All

• SFdesign FoxPro character fields in .Net showing as blank strings.

  Not sure if this should be in the FoxPro forum, or the C# forum. I have a dBase database, with a table (table1). table1 contains a field (myField) which is a fixed length, 4-character field. With each record this field contains 4 ASCII characters (which were created by converting decimal values into ASCII). Now ... I think that the first 2 or 3 characters are ASCII value 0 (null). Also, some of them contain Extended ASCII codes. My problem ...Show All

• krysa Primary key + delete....

  General Design Question…. Suppose I have a table (Table1) with a primary key (PKId), if a user deletes a record then wants to add a record with the same PKId value there is a Primary key violation because the table has not yet Been packed. What is the best solution to this I have Considers the Following… 1) Indexing on PKId+!deleted() , but this would only solve the problem if he delete the record once, what happens if h ...Show All

• methjy newbie here...

  hi to all... i have a form named customers and i have txtboxes to input all information i needed. i have a grid that shows all the records in the table customer. works fine on loading. now, i have 2 buttons previous and next respectively. my codes are as follows: Previous Button: USE customer if not BOF() skip -1 thisform.refresh() if BOF() go top endif endif Next Button: USE customer if not EOF() skip thisform.refr ...Show All