Search results for query: *

Hi Has someone noticed, that a reader of Tek-Tips without having our lovely page Microsoft: Visual FoxPro Forum in "My Threadminder" is unable to see it, unless he knows exact location http://www.tek-tips.com/threadminder.cfm?pid=184. In other words: Home > Forums > Programmers > DBMS Packages...

For debugging I occasionally use commands like _SCREEN.Print(cMyVar + CHR(13)) I think it has some advantages over WAIT WINDOW, MESSAGEBOX. Unpleasant is, that this way I can use only some area of the screen to show results. I have a suspicion, that this part has the same height as the form...

After pressing a key in Textbox or so, mouse pointer disappears and comes back after almost any mouse action. True for Windows and VFP too. Is it possible to simulate this state (mouse pointer disappearing) programmatically? In fact, I can avoid situation when disappearing would be helpful...

Hi, Is it possible to generate SELECT SQL command without automatic switching to a work area with query results? I've finished my experiments with SELECT * FROM table TO SCREEN NOCONSOLE which is perfect, no switching, just results are neither visible nor accessible. Thank you, Tom.

I’d like to hook some action on keys combination Ctrl + [PLUS key on numeric keypad with Key Code = 43], which is quite usual these days. Problem is that KeyPress procedure does not give any ShiftAltCtrl parameter to check. It is in fact not fired at all. I know how to read Ctrl state by means...

I am sorry for that question, but where else find help, then on Tek-Tips… Next to the one old VFP project I’ve found a text file on a disk with content like that … Processor is Pentium Select area: 19, Table in Use: C:\... Alias: … Code page: … Lock(s): Exclusive USE...

SQL query sends results into cursor named tmp. If at the moment some table with name tmp is open, error message “Alias name is already in use” appears, regardless to “SAFETY” setting. In given context existing tmp table could be closed or even deleted. I understand that: - well behaved...

Hi, Sorry for such a basic question. In textbox one writes a character expression that I later search in a table. Because text property returns some additional spaces I use ALLTRIM(thisform.txtFind.text) as a search string. It looked good till now, when someone want to distinguish between...

I wish a nice day to all. I'd like to loop through collection of Project Manager windows on my VFP 7 IDE screen. They seem not to belong to _screen.forms collection and the only way how to "contact" them is by means of WVISIBLE, WTITLE and DE/ACTIVATE, HIDE commands. My task was originally to...

Hi All, I'm opening a form with command DO FORM SomeForm NAME oSomeName In a given situation would be nice to read back the name (here "oSomeName") from the child form SomeForm. oSomeName.name works, but returns "SomeForm" of course. I'm looking for something which returns string "oSomeName"...

Nice day to all. I've noticed (using VFP7) that issuing command SEEK with phrase DESCENDING changes order of appropriate TAG in a table even after SEEK is done. It seems to be a little insidious. According to helpfile DESCENDING in SEEK specifies that the table is searched in descending order...

Could someone explain the real difference between RecordSourceType "Alias" and "SQL Statement" in a grid when data for a grid comes from SQL. I don't mean slight differences in coding (I'm able to use them both), but like to know which method is preferable. Thank you, Tom.

Nice day to all. I need to set INDEX ON expr FOR MyFieldName = ldMyDate where ldMyDate is date type variable. To avoid troubles I want to refer to literal values only so I rewrite the code to: lcMyDate ="{" + DTOC(ldMyDate) + "}" INDEX ON expr FOR MyFieldName = &lcMyDate It seems to work...

Hi, a textbox is bound to a variable lcVar. In some special case I need this variable to reflect textbox value all the time, e.g. after every meaningful keypress. So I put following "refresh command" into textbox InteractiveChange method lcVar = this.value && this works Later willing to make it...

Hi. I have remembered that in FoxPro 2.6 days, when someone was creating command by means of some Designer or Wizard (don't remember how we called it at that time), appropriate command was then shown in Command window to be copied into the program if needed. Let's say: INDEX ON MyField TAG tmp...

I'd like to link two tables with common date type fields. The child table has only a few records (stores a history of prices, date field indicates date when the price was changed). If the date from parent table is not included in a child table, record pointer in the child goes to EOF position...

Hi Using GROUP BY clause in SQL returns one record per group and I need it to be some extreme record in that group For example in following table dept size -------------- dept1 2 dept1 3 dept2 9 dept2 8 I'm looking for the biggest size in every group, so I want...

Hi, There is a combo box on a form with some testing in valid procedure. If test is not successful, procedure ends with RETURN 0 to prevent leaving the control. Testing has no sense when the user is about to leave the form with Cancel-like button. Solution for such situation was discussed here...

Switching from VFP5 to VFP7 (under Windows XP environment) I've noticed that line spacing in submenus has been changed (increased from 15 to 19 px in VFP7). Is this parameter under programmer's control? Thank you, Tom

My provider has switched from Apache server to Microsoft-IIS/6.0 and my SHTML pages displays incorrectly. It seems to me, that Microsoft support for SSI directives is not as wide as with Apache. I'd say that conditional jumps (<!--#if expr=...) and user variables are not supported. Is that true...