Answer Questions

• EricN 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

• Art W VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All

• overture Unexpected disconnecting of remote connections under VFP 9 SP1

  I have problem with unexpected disconnecting of remote connections under VFP 9 SP1 runtimes (only under SP1 runtimes). For example, using _VFP object to access forms will cause this and I am analysing other situations. Using _SCREEN object does not cause this. Does anyone found this too and in what situations   Hi Is this the Public Beta of SP1 [What VFP build number are you using (output from VERSION() will tell us)] Meanwhile, ...Show All

• espenhjo combo box

  I am new to foxpro and have a few questions so i will post them seperatly. I have a form that is filled out and stored in a free table.  i have 4 fields on the form.  for the purpose of explaining clearly field one is a combo box, 2 is a combo box, 3 is a combo box, and 4 is a text box.  the first 2 combo boxes are getting info from one table with 3 fields.  Field one is park,  field 2 is tower and field 3 i ...Show All

• Goran _ Bug in VFP 9? Adding an object to an array with AddObject.

  We have this base class that basically implements a collection (I know there are collections in VFP, but we can't change this overnight). Part of the process is to add an object to an array. This code word flawlessly on VFP6 for years. this.ItemCount = this.ItemCount + 1 Dimension this.Item[this.ItemCount] Local cItemPlace cItemPlace = "Item[" + LTrim(Str(this.ItemCount)) + "]" this.AddObject(cItemPlace, this.ItemClassName, &tInitParame ...Show All

• TheBeard Form Feed Character

  Hello Experts: I am using FPUTS to write text to a file. At the end of each page I need to insert Form Feed Character. How can I do this Try adding CHR(12) as your FF character. Thanks Alex. Is there a reference somewhere for what different ANSI codes represent I normally work them from memory but any decent ASCII table would show it. ...Show All

• oren create window

  I am new to foxpro and have a few questions so i will post them seperatly.In my start up program i have added _SCREEN.VISIBLE=.F. I have also added a text file config.fpw with on line SCREEN=OFF That has taken care of not displaying the default window.  Now i want to create my own main window that every form and report will be displayed in.  I also want to have frames in the window.  One frame down the side or across t ...Show All

• Milque Visual Foxpro Book Recommendations?

  All, Can anyone recommend a good book for learning VFP 6.0 from scratch   I've looked at SPECIAL ADDITION USING VISUAL FOXPRO 6 but it's not really helping me so far.  All I am trying to do is create a simple .exe that will read amd update some records from a .dbf and insert those records into a MS SQL table.  All the books on Amazon have gotten terrible reviews and MSDN has little to no info on doing thi ...Show All

• Caroline_C# Need VFP 9.0 Report Help

  Hi I have a report that in the detail band I have the following info: QTY     Part Number      Description              Price           Extended Price   5       2222-009          5500 Watt 220V &nbs ...Show All

• tanishq1510 HOW TO ADD AUTOMATICALLY A LOT OF .dbf FILE INTO A DATABASE .dbc FILE ???

  Hi! In a folder I have a lot of .dbf file! I want to do the upsize to a MSDE, but I can't do it from a folder that contains the .dbf file....I need a .dbc file! So, when I create a new .dbc file from the project manager, fox can't allow me to add automatically all the .dbf file that are in my folder! I must add one by one...but this procedure is too much slow! Can you tell me how to add automatically a lot of .dbf file into a .dbc If exist ...Show All

• Tai Yee Remote views problem - urgent

  I upgraded to a new server (win2k->win2k3 enterp.,sql2000->sql2005,4GB->8GB,2.8GH dual->3.4GHz dual). Everything else is the same. The foxpro remote views take 10 times longer. (create sql view, requery() ). Struggling for the past 10 days. Foxpro table access and queries inside SQLServer seem fine. Thought it might be the /PAE switch in boot.ini for accessing the 8 GB mem but that won't come off. I am using VFP6SP5. ...Show All

• JohnMorales COM application using to much memory

  I have a fox pro program that records data from a website and stores the informatino in a ms sql server.  The com application is made from this program sometimes takes like 50,000 K - 100,000 K of memory.  How can i figure out if there is a memory leak What should I check   Is there a reason for the com to use so much memory.  The program uses sqlstrconnect to connect to the database.  It is only inserting data in the se ...Show All

• Christoc VFP6-Did anyone experience this problem (with ActiveX Ctrl)?

  hello guys, I post here my problem and hope that there will be certain VFP expert to help. The problem was that when i call the MouseDown event from an OleListView control (this ole is inserted in FORM1). This MouseDown event will show a shortcut menu (1st shortcut). A Command in the 1st shortcut will open a modal form named FORM2 and on form2 is also placed another activeX listview control. The MouseDown event of this olelistview will show a ...Show All

• Nibbla migrating VFP app to .net (architecture question)

  Hello everyone! I'm a fairly experieced database developer (SQL Server primarily, and Oracle quite a bit less). My experience with .net is primarily vb.net to built asp.net applications, using web services as my middle man. I just started at a new company which has a few legacy systems, one of which is a rather large FoxPro application. There are a host of problems associated with it, primarily data conflicts. Because the company has grown so mu ...Show All

• DeviousDevil Application Design

  Ok I'm new to VFP all together so I am looking for some reassurance in a design issue I have currently. So far- I have to pull info from an ODBC connection (SQL server) yet that doesn't contain all the info that my boss wants for a personnel database. Nor is it normalized in my opinion. Yet I can work with some of the info that is in it. So I created a table that contains the info that doesn't exist in the ODBC table & then joined the two ...Show All