Answer Questions

• Ken huang Assigning Data to a variable in a query

  I have a table that I want to query based on a Selected Record in a gridView.  I have the Record Number in GridView.SelectedValue but  I have no ide how to set up a query in here much less run it.  I need to know OldLine and oldItem from a table called items I mean I know "Select OldItem, OldLine from ITems where RecordNumber = " + GridValue.SelectedValue"   Sure hoped that worked but no...  As you can probably ...Show All

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

• Shona Arora VFP9 printing issue with multiple detail bands and group subtotals and/or summary totals

  I have a report with one group and a summary total. Adding a new detail band, a big new feature added by VFP9, lead to incorrect totals/subtotals. I am using VFP9 SP1, behavior80, but is the same with behavior90. Steps to duplicate: 1) Run this code create table PRINCIPALE ;   (AGENTE     C(2), ;    N_DOCUMENT C(5), ;    D_DOCUMENT D, ;    TOTALE     N(5), ; & ...Show All

• Lientjie Kat MSComctlLib.TreeCtrl.2 BackColor ???

  MSComctlLib.TreeCtrl.2 does not have BackColor property. Is it possible to define one (it is of course possible) and actually make it functionable Thanks. I never said understanding jokes is an object. It is no object . I think it is a property:) Not to be pedantic about all this, but you do not instantiate properties, you instantiate objects. You set properties. Part of the reason that I nit pick about your choice of ...Show All

• normala DISKSPACE() trouble

  I have an ActivX OleControl Microsoft treeView V6.0 and as a part of Init() procedure I use DISKSPACE() function just to determine which disk drives (physical as well as mapped network drives) are currently available. If the drive A: does not have a disk in it I get repeated error messages: " Drive is empty, please insert...." It does not do anything like this with DVD/CD R/W drives. They are empty and it is OK. Likewise, if I simply click o ...Show All

• devalapa_k how can i get a array from function/procedure as return parameter?

  i wrote one function ,i put the values in a array for return,but  i can't get it . for instance. function a() return arrayname endfu b= a()   jet su wrote: i wrote one function ,i put the values in a array for return,but  i can't get it . for instance. function a() return arrayname endfu b= a() Hi One way to do this is to pass the array to the function by reference: result&nb ...Show All

• simserob VFP6 SP5 distribution

  Do I need to do anything to computers running VFP6 executables to get them to pick up service packs or is re-compiling and recreating executable on machine with SP installed enough   I'm getting various wierd errors and also windows FoxPro fatal errors on some of the computers that run the executables and I understand SP5 may help, but I've installed on my development computer, recompiled and recreated executable and redistributed, but i ...Show All

• oracle47 i can't use movelast in ado

  Hi guys    i can use ado connect to local .dbf and sql server and get the data from it.but i found i can't use movepriveous,movelast function of ado object and also i can't get the recordcount ,any idea o=CREATEOBJECT("adodb.connection") o.ConnectionString="Provider=VFPOLEDB.1;Data Source=P:\test\data;Password='';Collating Sequence=MACHINE" o.Open() r=CREATEOBJECT("adodb.recordset") r.Open("select * from freetable1",o) r.recordcount& ...Show All

• eyekron I am facing a strage problem in VFP 8.0 with Error()

  Hi there,   I am converting old dos program into foxpro 8.0. I am facing problem with below statement. On error lError = Error() the code excuting and throws to error, but I am not getting error number. It is giving always 0. Message() is giving correct error description, I verified in debug mode. also I changed the above statement like On error messagebox(message() + str(error()) . Is there any settings in VFP environment I also installe ...Show All

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

• Vadim Tsyganov Programatically Placing Controls on a Form

  A table's fields are: Text, XformCoordinate, YformCoordinate. What would be an efficient way to  process the  records , placing a label for each record at the form coordinates specified in the record with the label's caption equal to the text field in the record. Thanks, Joe Laden (an old Clipper programmer) Check into using the HTML builder to make the forms into web pages, that may be th ...Show All

• Mike Graser problem with physical sorting

  Hello , my name is victor , and i have a problem ! i am beginner in VFP9 , and i would like to put a question. I try to do a little program wich will help me to see better our employment. I tried to do a table , and to sort workers by theyer names from "A" to "Z", but it doesn`t work. The code is like this : USE tabel_de_baza.dbf SORT TO tabel_de_baza1.dbf ON nume_pren /A USE tabel_de_baza1.dbf List Use. ...Show All

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

• Joel Holdsworth With ... EndWith

  How does nesting work with With ... EndWith Does VFP work out which object I am referring to if I just enter .cDescription for example Is there a potential for ambiguity if the 2 objects have the same property I would like to use nested With ... EndWith but I am wary of introducing some difficult to find bugs.   CetinBasoz wrote: I prefer to use with ... endwith for maintainability and readability:) ...Show All

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