Answer Questions

• RickPoe How to make a form truely private?

  A newbie question: I have a form which I have set it to private datasession. The form has an object which is based on a class: cboacct. This class is a container class which has a cbo and a text box. The cbo takes an acct# and seeks the customer file. Originally the ControSource for the cbo was simply 'acct' and being blobal, it worked fine. I'm trying to use a protected property instead. I have created a protected class property named 'acct'. ...Show All

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

• Meareg Foxpro odbc sql statement for list of tables

  Good Morning Can anyone tell me the sql statement that will list all the dbf files in the data directory pointed at by my foxpro odbc DSN. Some thing like Select tablename from systables thanks    David Hills         Like systables Its counterpart is SQLTables(). ie: lnHandle=Sqlstringconnect('Driver={Microsoft Visual FoxPro Driver};'+;  & ...Show All

• baskardurai Character string

  I have  textbox.how can i select the first letter in it for example if 1st letter in textbox1="a" then messagebox ("ok") thank you all replace .value with .listitem(i) You need to test each List Item in this case, not the value (the value is only the currently selected item). Code like this will do what you want: loTgt = ThisForm .AllPages.Page6.cListBox WITH loTgt ...Show All

• BullZhot Spell checking?

  Well, as sort of a follow up, I am using the ActiveX RTF for one of my forms. What I'd like to know if there is a way to do sort of a spell check for what a doctor would type into it. Any one know It's on the way. I want your sample code too. It is a neat idea. Will this method highlight the misspelled words in RTF There is also another option: APSC - All Purpose Spell Checker which is also downloadable: you can find it on the we ...Show All

• Thomas Smith table buffering mode

  On a statement like this: IF NOT initTableEmpty TABLEUPDATE () ENDIF I get an error: This operation requires table to be opened in buffering mode . SQLBUFFERING is set to ON before the table is opened. It does not help. Actually the error happens once in a while for no reason. I cannot understand what triggers it. Most of the time the statement works. The USE command does seem to have no option for buffering either. Is any h ...Show All

• wesnerm1000 how can i select mutiple the records and highlight them in the grid control?

  can i do that thank you everyone. screen.width*0.5) {this.resized=true; this.width=screen.width*0.6; this.alt=' 查看全 ';}" border=0>  i am working on it now and almost finish it.but i found i can't control the current activated cell color.how can i fix it thank you jet thank you everyone Multi-select is not directly supported by the grid control. You can add a Logical column to the query that generates the cursor used for ...Show All

• stevebio proper practice: Grids with my own classes.

  Hi all; I am trying to find out what is the best way to put a grid in a form so the classes used in the grid are not the base classes but my own classes. If I drag the table from the DE or anywhere else, the grid created is using base classes. Should I manually create the grid by groping my own grid into the form and then start assigning the new columns etc, or is there a better trick to doing this Thank you all. ...Show All

• Vivek Mayur Khan cursorschema property limitation problem

  Hi All, Am migrating a VFP app from DBF to SQL Server database and am using cursoradapters for that. I have a table that has many fields and when I create a cursoradapter for it, when I try to save, I get the error message "The CursorSchema property must be no longer than 255 characters". Most of my tables will generate schemas of characters > 255. What is the best workaround for this I don't want to imagine splitting all the tables into smal ...Show All

• natetrost How to change Default FONTS in Forms, Menus, status bar, title bar and so on...??

  Hi, Could somebody tell me, how to change default fonts of Menus, Status bar, titke bar and so on... Right now I can see everything in Arial but I need to use different font. Thanks Hi, You can set the StatusBar's font from it's Font property. myStatusBar.Font = new Font(...) As for Menu and TitleBar, unless you provide OwnerDrawing, these controls will use the default settings of System Display (Start->Settings->Control ...Show All

• Vikas Pradhan Cannot 'USE' two tables in VFP90 - XP ONLY?

  I am using a stand-alone exe in VFP90 and I am trying to create a new form with the following in the init: SELECT 0 USE 'accntdb' ALIAS 'accntdb' SELECT 0 USE 'presetdb' ALIAS 'presetdb' I am compiling with VFP90 S/P 1.  Now, this will open both tables when run on Win2K just fine, but when run on XP (latest s/p) only the data in the 'presetdb' table is visible in the browser.  The alias is still recognized, but ther ...Show All

• slolife Delete Folders

  Dear Experts I have a folder entitled "Tables". It has sub folders named as 12102005 13102005 14102005 15102005 16102005 17102005 The name of folders are like British Date I want to delete the folders that names are less than date()-2 and suppose today date is 17102005 After applying command the following folders will be delete 12102005 13102005 14102005 15102005 and following folders will be left in "Tables" 16102005 17102005 Please Hel ...Show All

• Byebye formset=>deployment=>etc.

  Hi there, As a part of an effort to deploy and application I have been trying to do a few tricks. They have been suggested previously by Cetin and Tamar especially. The code is placed in a .prg file. I tried a few things. oNewInstance = CREATEOBJECT('FormSet') oNewInstance.NewObject ("urls","form") <= secondary, child form oNewInstance.NewObject ("cPlusIntrnals","form") <= main form oNe ...Show All

• Warhorse Using VTable interface of Excel Component from FoxPro 8.0

  I am writing a FoxPro program that uses the Microsoft Excel component in order to generate a XLS file. However, FoxPro is evidently using the IDispatch form of the Excel interfaces instead of the VTable interface. How do I write the program so that FoxPro will use the VTable interface instead Check CreateObjectEx() and sys(2333). My curiosity why do you need Vtable interface to create an XLS file Your w ...Show All

• Vishnuprasadh Open table exclusively?

  Forgive my ignorance - I've recently reinstalled XP and subsequently Foxpro 7.0. Now when i double click on a foxpro dbf file it opens the table and another datasession labeled 'B' (i'm supposing it's a datasession). Previously, when i opened a table i was in exclusive mode and didn't have this duplicate table open also. I normally work in exclusive mode because my data is not in a shared environment (i'm a vb developer). Any suggestions thanks ...Show All