Answer Questions

• korsakow table manipulation

  Two tables exist, call them tableA and tableB. They share some data. which was easy to get select a.work_id, a.sp_id, b.work_id, b.sp_id; from tableA a inner join table b on (a.work_id = b.work_id); order by work_id; into cursor hold1 there is still a matter of getting all the data from tableA and tableB that they don't share. i tried doing a left outer join, but i still get duplicates. Any ideas MP After further look at my data, i seem ...Show All

• PatrickRyu Grid Columns settings disappear

  I have a grid with about 20 columns and the following properties are defined at design time carefully: backColor, foreColor, fontSize, fontBold for the columns as well as corresponding properties for the headers. Then I have a table and I want to use a part of the table as a recordSource let say to display transaction for year 2005. I get a beautiful display. Then I have a combobox with some years like 2004, 2005, 2006, etc. It controls th ...Show All

• patspam VFP free tables in compressed folders

  Will Visual FoxPro free tables work fine on compressed drives or in compressed folders I am talking about the NTFS compression found under advanced attributes. I have several folders with hundreds of .dbf files used in out VFP app. I would like to compress these folders to save disk space. Dave M. wrote: Have you ever tested the performance I wanted to re-word my answer to this to give you a better feel. With mi ...Show All

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

• pwilliams82 Very nice!

  Good work (and about time)! =) I don't think this will compete too heavily with the others. Just one more place for folks to go for help... I'm on the UT regularly, and plan to continue. <g> We still promote many of the great third-party sites dedicated to Visual FoxPro development such as the ones listed at  http://msdn.microsoft.com/vfoxpro/community/related/default.aspx . Often some of ...Show All

• lugo How to use the tables of a Form

  I am having problem using the tables listed in its data environment, I would like to zap the records, append some data and replace some records but when I used the zap command it says that the table should be used in exclusive mode, what should I do If am going to open the tables again as exclusive wouldn't it create possible conflicts Once the form is actived and initiated it automatically opens the tables, am I right And once, the focus ...Show All

• KCanterucci class called

  dear all, i have a class to detect table open exclusive or not in my project. when i put my code at load event it prompt me unknown my class. but when i put it at init event it run normally. thanks in advance. So what is the question really In load objects are not inited yet. In init it's there (form.init runs after all others are inited). Why do you need such a class BTW VFP has Isexclusive() function. ...Show All

• pwqiang Design menu and manager users from DBF table.

  Hi all; I want create table DBF to design menu and manager users: EX: menu.dbf (items C(150), command C(100), skip L, picture C(100),...) How when run app will active menu Thank! DEFINE POPUP popGrid RELATIVE FROM MROW (), MCOL () SHORTCUT FONT "Arial",9 i = 0 cPrompt = "" SELECT menudata SCAN i = i +1 DEFINE BAR i OF popGrid PROMPT ...Show All

• xiaoyifang Questions regarding connecting to an ADP server

  I would like to use VFP as a frontend to reach in and pull data from our company's ADP server. I know the addressing ( IP and port ) used by the ADP client software and have administrative access on the User level ( I'm the sys admin), but am unsure where to begin. I do see a Reflection for Unix and Digital OLE control listed... is this related  The goal is to be able to automate the execution of ADP english statement scripts to extract dat ...Show All

• Hans Preuer Closing Cursors

  Hi Everyone, I was just wondering if anyone knows how to close an open cursor without closing another. For example, I have two cursors open and I only want to close one. If I use the USE command, this will close both of them. Any Ideas Thanks in advance. Todd Peasley. Thankyou, that worked a treat. Use closes one not all. From any workarea to close cursor with alias myAlias: U ...Show All

• Tianyu Li SELECT - SQL executed partically

  I have 11,000 directories in my machine on one partition only (C:). In order to expedite search for file I need (I found MS search engine too slow) I scan all directories once in 10 days and create a table with directory shorthands and a field where extensions of the files located there are stored. Some directories have too many various types of files and I use a memo field to store extensions for them. Thus the primary field has 80 char length ...Show All

• Anonymous . Is it possible 2 generate windows report from FoxPro 2.6??

  Hi all, Is it possible to generate windows reports using FoxPro 2.6 I want 2 generate a report from FoxPro 2.6, which should look like windows reoprt (with font size changed, bold, italized one) Wheather it is possible to generate report using visual foxpro by using same DOS based DBF (FoxPro 2.6) Thanks in advance STN What I have done is to have my dos application print to a file with a random name but fixed extension. Then I have ...Show All

• Ricardo Oneda Pereira de Toledo WinSock

  I just tried Microsoft WinSock OLE Control 6.0 (SP4). It binds to a port and it goes into a LISTEN state but I cannot figure out how to unbind the connection. Close() method does not work, SendComplete() does not work either I do not know why Other methods do not seem to be relevant. Does anyone have any experience with WinSock Thanks. I don't have any experience with Winsock as I don't use it, but maybe these Wiki entries may be o ...Show All

• Daniele Bortoluz MSComctlLib.TreeCtrl.2 Problem

  Working with the treeView Control I ran into an unexpected problem. It appears to be impossible to collapse a node branch programmatically. Collapse is an event, not a method and when I tried to use it as a method I could not get anywhere. I also tried to employ DblClick with the same negative result--the tree does not budge. Aside from Collapse I will need Expand as a method not event, although I am using it as even already. The expansion ...Show All

• Kamel Problems with W2003 Terminal services

  We have migrated from a NT 4.0/Citrix application server to W2003 Terminal Services. The storage has not changed, this is still the same file server in the network. The application is written in VFP 9.0 makes use of VFP databases/tables. This turns out to be a nightmare. We see lots of corrupted files, and often there is a lag between writing data and the moment that the data is seen when we read it back. This lag can take full minutes! ...Show All