Search results for query: *

Hi! Here I am back with a simple issue that I can't track down. I am updating a field in a view that is the difference in two other fields in a different table. All fields are N 10 with 2 decimals. This is done to display in a grid. The amount is shown without decimals even tho the grid shows...

Hi! I am still learning how to use the power of cursors and want to move forward in understanding. (VFP9) I have a grid with RecordSource an updateable cursor. Checkboxes select the rows to update in the table underlying the cursor. The cursor shows info from several tables, but I only need...

Hi! This is my first attemp to use a checkbox in a grid. I have a grid with a checkbox in the last column (7th) The RecordSource for the grid is an updateable cursor created following Marcia's suggestions in '1001 Things..' USE DBF('csrTemp') AGAIN IN 0 ALIAS PayTick USE IN csrTemp SELECT...

Hi! I can't believe I am having this much trouble with this. I have a textbox for entering a customer number. I want to set the value of the field 0 and use the Z in the format to keep the 0 from showing when the textbox gets focus. I know I have done this before. In fact I just reread a...

Hi All! I often need to find a record that contains jobsnumb C(8) and ordrnumb C(8) so I want an index that will SEEK or SCAN FOR or whatever. The keys will come from textboxes where user inputs such data as jobsnumb 11098 and ordrnumb 9-1. I cannot seem to create an index that will find the...

Hi! Having recently moved to VFP9.0[smile], I am going back and checking all reports and have found that the last two lines (page footer) are not showing on landscape reports. The reports are packed with lots of fields and I am using the 'whole page' rather than 'printable page to show as much...

Hi! I had not used intellisense (did vfp6.0 have it) but since going to vfp 9 I love using it. For someone still learning what can be done where, it is great. My problem is: When I start typing the command and the window pops up and I select the next step by 'entering' that much is completed...

Hi! I had to put that vfp9.0 in the subject. It took me too long to make the move but I love it even if it is causing me to have to revisit a lot of issues [smile] However, this is a new problem, not a revisit. IIF(shpcomp = 1, 0,(IIF(shptotl < duetotl, (duetotl - shptotl), 0))) AS balance ...

Hi, This is a continuation of earlier thread on 'positioning cursor'. Searching through other forums I ran across a suggestion to place this line where the cursor became 'lost' WAIT WINDOW Thisform.ActiveControl.Name When I did this, I got an error message Any ideas on where to go from...

Hi! I'm finally doing it. I am moving my app to 9. I understood that I had some queries that would have to be rewritten because they were done at the very first (before I knew better). I know that GROUP BY must include all selected fields and I know that you experts have many ways to...

Hi! I have a form calling a modal form to get a number and check to see if valid and return to calling form. There I append blank, set values for the first three fields and refresh the screen. The cursor should hold on the fourth field but jumps to the nineth. I have checked tab order and...

Hi! I have a listbox using the code below. Only the first two values show. I created the listbox visually, set columncount to 3. I'm trying to use example from '1001 Things....' LOCAL lcJobsnumb, lcRowsource lcJobsnumb = Thisform.pgfCasting.pagJobs.txtJobsnumb.Value *!* SELECT...

Hi! I have a pageframe that contains a page with 6 buttons that call modal forms - designed as far as I can tell exactly alike except for tables used and report printed. Five work as I want but the 6th gives the error: Of course, I have gotten this before in testing modules but exiting and...

Hi! Never had this one before. My form 'frmSelect' has been in the project manager for a while working correctly. Now when testing a form that calls frmSelect I get an error that tells me it can't find frmSelect. It is trying to find it in a different sub-directory (under 'progs' instead of...

Hi! This is a once/twice a year procedure in VFP 6.0 I am using SELECT to verify balances on invoices and present any orphans (for whatever reason) to users to decide what needs to be done. Now I am presenting either a browse window or a report (user choice) so user can go to edit screen to...

Hi! Never had this happen to me before. I generally use MODAL forms with PRIVATE data sessions. I add the tables I need to the form's DE and SELECT when needed. This has worked but now I need EXCLUSIVE use to PACK the tables. I am using the following strategy. *** select orders records to...

Hi! For the first time I am experiencing a short wait for processing to take place. Still in VFP 6.0 and tables have 20 - 50k records each for the time period I am processing. I used SQL SELECT to get the records and transfer to archive. This is what I am doing to delete them from active...

Hi! I have 2 grids. One has 1 column used to select data for second grid. This grid has 2 columns. I have my selected rows displaying in the colors I want except I can't seem to find a way to have the row in both columns to show 'selected' when I click on either. How can I make the ROW be...

Hi! I have have used the following to set up grids for selecting an item. RECORDSOURCE = "" SELECT someting FROM somewhere INTO CURSOR csrtemp RECORDSOURCE = "csrtemp" This works fine if the resulting cursor has few records and they are easily seen in the grid. However, now I need to create...

Hi! I have been plagued by this question off and on since I started trying to learn Visual Fox. I create a textbox which will hold a numeric value. On the first pass thru I can use it as a numeric value and all is well. Sometime in the processing, I get an error and the field is now char...