how to fix the width of a column in grid?

Visual FoxPro General

Index ‹ Visual FoxPro

- Previous
  - 1
    - Need better performance with FP Tables I dont suppose I meant that FP itself was slow. It's more of a "Way things are" being slow. I set up IIS and ran some tests making the ADO calls through ASP and the results were astonishing. I didnt bother with any real testing but my guess is that it's happening at about 1/100th of the time that the Access/linked tables method. To give an examble of slow, I had a recordset of 4300 records that needed 1 field updated. Select client, udf3, name from tablename where client='xyz' and name like '%WALMART%'; I would open the recordset and run a loop. If the record meet some simple conditions, I would update UDF3 with some text. It seemed real simple. I ran it with access / linked tables through a module and it was averaging 1 record per second. The same procedure using IIS server side, did 850 records in under 2 seconds. Anyway, thanks for the help. Dave Tag: how to fix the width of a column in grid?
  - 2
    - Problem with Vista Windows mail You aren't getting mail from Outlook though, you're getting it from Exchange if it's MAPI. So I don't understand what you mean by "fetching" mail from Windows Mail (which is just a client piece of software) Tag: how to fix the width of a column in grid?
  - 3
    - DCT FILE I tryed both but no results. Full error message is: "Memo file n:\data\data.dct is missing or is invalid" All is fine with vfp 7. I can build a new dbc file, and make tables free and add them in new vfp 9 dbc but I will lose long field names .... Tag: how to fix the width of a column in grid?
  - 4
    - Visual FoxPro9 Report Designer BUG I got the same error and I have VFP 9.0. I also have VFP 6.0 installed, also. Mine is ran Windows XP, too. Tag: how to fix the width of a column in grid?
  - 5
    - Sqlexec() command line maybe too long. Hello, Yes it does work if exclude subject, it does work perfectly, the problem is I need to include subject and some more fields after subject, its just that i beleive when i enter the subject field, by then i would have reached my limits. Thank you Tag: how to fix the width of a column in grid?
  - 6
    - OLEDragDrop errors Good you got it working Sometimes a fresh look at the code can help. Tag: how to fix the width of a column in grid?
  - 7
    - Display "Running query..." progress bar Yes, may be VFP thinks it is not going to take long time to run it. Anyway, this class can come handy for other selects. Tag: how to fix the width of a column in grid?
  - 8
    - Recursive function call stack cleanup Below is a program that calls two recursive functions. With the first one, I am able to watch as the call stack is built with each instance of the function one by one, and then am able to watch as each instance of the function is removed from the call stack, one by one. With the second function, I can watch the call stack grow as each instance of the function is added, but after the last instance of the function is added, and the call stack pointer is at the top of the stack, that function then returns, and it seems as if that instance of the call stack immediately returns to the next line in the program, after the line that initially called the function. It seems as if all of the parent instances of the function on the call stack are skipped. I know this is not what really happens, because the final value after the functions return to the main part of the program is correct. However, I would like to be able to use a breakpoint or a suspend, so that after the second function is called, as each instance of the call stack have all been added, and then start returning to the parent instances, I can stop the program each time and know that those instances are actually being removed one at a time, and not being cast off into memory as a leak. Any ideas All of my efforts with the second function have not been successful. Struggling with this led me to creating the first function, in which I was able to successfully watch the recursion step by step. However, I really would like to verify the same thing on the second function. Thanks. *------------------------------------------------------------------------------ *- Program Name..: recursiveFun.prg *------------------------------------------------------------------------------ *- Description: Visual Foxpro Recursive Factorial functions *------------------------------------------------------------------------------ *- Synopsis...: This program demonstrate two different versions *- of recursive functions that both determine the factorial *- value for a number. In this case, I've used 10 *- for simplicity. *- *- Source: http://fox.wikis.com/wc.dll Wiki~RecursionInVFP~VFP *- *------------------------------------------------------------------------------ Private ll_Cntr PRIVATE ll_funcCntr PRIVATE ll_stuff CLEAR ll_Cntr = 10 ll_funcCntr = 0 ll_stuff = 0 "Beginning program!" fact = Factorial1(ll_Cntr) STR(ll_Cntr) + "! = " + STR(fact) *!* fact = 0 *!* fact = recFun(ll_Cntr) *!* STR(ll_Cntr) + "! = " + STR(fact) "End of program!" FUNCTION Factorial1 LPARAMETER n IF (n < 1) IF ll_funcCntr < 10 && track function call instances ll_funcCntr = ll_funcCntr + 1 "In Factorial1 instace " + STR(ll_funcCntr) ENDIF ll_stuff = ll_stuff + 1 ELSE IF ll_funcCntr < 10 && track function call instances ll_funcCntr = ll_funcCntr + 1 "In Factorial1 instace " + STR(ll_funcCntr) ENDIF && recursive call ll_stuff = ll_stuff + n*Factorial1(n-1) ENDIF && program returns here after each recursive call IF (ll_funcCntr > 0) && track function call cleanup "Performing Cleanup on function instance " + ; STR(ll_funcCntr) ll_funcCntr = ll_funcCntr - 1 ENDIF RETURN ll_stuff && returns to next line after function call && in the main code above **-- End Function FUNCTION recFun LPARAMETERS n && After the last recursive call, does the instance && of the function on the top of the call stack && return to the line after 'fact = recFun(ll_Cntr)' && && Or does it return to the next parent instance of the && function on the call stack until the last instance && of the function has returned to the calling command && && Is there a way I can stop the program in this function && after each instance of the function on the call stack && returns RETURN IIF(n>1,n*recFUN(n-1),1) **-- End Function Tag: how to fix the width of a column in grid?
  - 9
    - Little Doubt with Grids Hi Markish, Well. But those are different tables... Tag: how to fix the width of a column in grid?
  - 10
    - Catch "The uniqueness of primary or candidate key is violated." (Error 1884) in Browse window Hi Everybody, Help me, please I have problem with unique index. How to catch the message "The uniqueness of primary or candidate key is violated." (Error 1884) in Browse window (or Grid control). Because I want to display my message instead VFP's meassage. I use VFP9. Sorry because my english is not good! Thanks everybody Tag: how to fix the width of a column in grid?
  - 11
    - Report Designer Hi all Is there date sorting on the field in the report designer Thank you. Tag: how to fix the width of a column in grid?
  - 12
    - Opening VFP tables with Fox2.6 (Dos) Thanks to the authors of this and the two previous posts. VFP is not an option, we just do not have it. Changing the first byte actually does work in some cases, but not all. I'm still trying to nail down the reason for this. My intention is still to manufacture a "replacement" header, I presume some things are going to have to be stripped or altered (like the db container link you mentioned). Thanks Tag: how to fix the width of a column in grid?
  - 13
    - VFP 8 Form Issue TRJ48 wrote: I have developed a form in VFP 8 which has multiple grids on it. It runs fine from VFP but when I run it from the EXE it gives the following error when trying to load the form. Error Loading File - Record Number 66. ResoGrd <or one of its members>. Parent : Not a Table. Just a SWAG here - is the grid class that is causing the problem using member classes Tag: how to fix the width of a column in grid?
  - 14
    - Urgent - Need Help In VFP 8 Deployment Hi Greetz, Thanks for showing me way, however i have main prg file in which i have define menu and no " do form " is called i have simple display menus and in that i called forms. so where should i include read events in main prg so that as per my exe my deploy project also run fine, Regard Hemangi Tag: how to fix the width of a column in grid?
  - 15
    - How to Filter Records in a Grid Okay, I've put the lcKey = alltrim(this.value) command in the interactive change code but I'm not sure where to put the SET KEY to m.lckey command. I thought that it might go in the Keypress code but when I put it there I get a "variable not found LCKEY" error message. Tag: how to fix the width of a column in grid?
  - 16
    - Retrieving values of every selected item in a listbox Its loaded from a field in a table. It fails on the myString = myString + ' ' + ThisForm.myListBox.List(Counter) Tag: how to fix the width of a column in grid?
- Next
  - 1
    - Performance problem: Querying fox tables with oledb Hi, I have a big performance problem querying fox tables using oledb provider from a win32 (C#) application: one select takes 30 seconds to done!!! Is there anyone who has experience the same problem and has a way to improve querying performance Thanks! Tag: how to fix the width of a column in grid?
  - 2
    - memo file c:\...\.sct missing or invalid Hi, plase help me I heve a form and in one moment .sct file is missing, and thear message memo file c:\...\.sct missing or invalid Thanks Tag: how to fix the width of a column in grid?
  - 3
    - about vfp9 sp2 does vfp9 sp2 have bugs a month ago,I installed sp2,but when I closed the cursor (got by SQLexec() from SQL Server),the IDE opened a dialogbox containing mistakes,then the vfp9 IDE closed right away, Tag: how to fix the width of a column in grid?
  - 4
    - Cursors Help Lightening wrote: ...... Select yourCursorName Report form YourReportFileName nonconsole preview Ok, but don't I need to have the table in the data environment I am new to reports Tag: how to fix the width of a column in grid?
  - 5
    - numeric values hi all, i would like to know why my columns on grid display numeric values as ***,*** I had set the columns format = !R and inputmask = 999,999. thanks in advance. regards. Tag: how to fix the width of a column in grid?
  - 6
    - Error Anomaly in Control Valid Events Hi... I'm getting some very weird problems when an error occurs in the valid event of a form combo box. I am attempting to handle form errors within a TRY block that wraps a READ EVENTS. When an unhandled form error occurs, the CATCH releases the form, and then evokes the READ EVENTS again. In this way, I can dump the form without losing the whole app. This methodology works fine - except when errors occur in valid events for combo boxes, text boxes, and edit boxes!!!! For some reason in these cases, the form cannot be released - almost as if a reference to the form or form-object is being maintained somewhere that I am unaware of, and this is preventing the form and it's objects from being destoyed. This problem can be easily reproduced with the following code: LOCAL frm SET CLASSLIB TO misc TRY frm = CREATEOBJECT ("frmCrash") frm. Show() READ EVENTS CATCH frm. Release () ENDTRY Any takers Tag: how to fix the width of a column in grid?
  - 7
    - Accessing VFP 8 through C# and ODBC AlexIn(warm)Miami... As I recall, the shuttle had to be taken to the local shop to have hail damage fixed, right Well, after this morning, we can add my car to that list. I'm afraid I'm not that experienced in using VFP. My previous places of employment all used either Oracle or SQL Server. We just wrote the connection into the code. How would I use OLEDB to connect a C#2003 program to VFP8 data Thanks for your help! KevinIn(not-so-cold-but-REALLY-wet)Indy Tag: how to fix the width of a column in grid?
  - 8
    - export file question Hi, I don't know how to export a dbf file to a text file with character fields without quotes. For example, I need that in the text file, fields appear like this: simon 150 manager robert 300 sales representative Thanks, Tag: how to fix the width of a column in grid?
  - 9
    - DBCs and Citrix/ Terminal Server This looks like something I could check out for my post. Thanks for the link. Tag: how to fix the width of a column in grid?
  - 10
    - same field on several tables Yes, this is useful. I was just trying to solve the original problem. Tag: how to fix the width of a column in grid?
  - 11
    - Report navigation buttons disabled I uninstalled VFP9 and removed all VFP9 directories and reinstalled clean. Recompiled my application again and the same final result. Frozen report navigation toolbar!!! Only page down key from the keybaord works OK for page navigation. To close the report I used <ESC> key. And report navigation toobar in preview window with "SET REPORT BEHAVIOUR 90" works only in window with 'IN SCREEN" attribute. Any other "IN TOP LEVEL WINDOW" or "AS TOP LEVEL WINDOW" does not work - frozen navigation toolbar!!! Tag: how to fix the width of a column in grid?
  - 12
    - refresh form Yuu may try thisform.Refresh after values are changed and you press next button or refresh each textbox individualy, thisform.textboxname.Refresh. Tag: how to fix the width of a column in grid?
  - 13
    - How To RUN Configuration File in VFP-Application File...for Hiding Foxpro Screen & Task Pane... Helo, Actually I Build 1-Application file....My Problem is that whenever I run the Application File, The Visual Foxpro Screen is coming First and after Task Pane is coming, and next my Application file is running.... So what I need, how to disable the Foxpro Screen & Task Pane at Starting time..... Is there any one to help me please.... By PARAMU Tag: how to fix the width of a column in grid?
  - 14
    - VFP6 to VFP9 broke Dataenvironment.OpenTables Maybe then you have code in OpenTables. Tag: how to fix the width of a column in grid?
  - 15
    - Problem indexing views Thanks, Naomi. I have no table buffering yet. My next challenge is to figure out what I have to do to update views and to update tables. I have an Undo button on each screen with updatable data, so I need to buffer the view (and if default is okay, good), and then, I have to decide when I want to update the underlying table (not until I close the application -- and the view -- I guess). Regards, Hans L Tag: how to fix the width of a column in grid?
  - 16
    - SELECT-SQL vs. SET RELATION Thank you, once again, T.E.G., N.N., and C.B. for your very helpful posts. C.B., the extent of your last post is truly above and beyond and is more than greatly appreciated. T.E.G. and N.N. you've both stuck with me for about two weeks now with excellent ideas and examples and the "thank you's" I've expressed really don't quite measure up to the appreciation I feel. I've corrected each index which had ALLTRIM() and, suprising at least to me, that speeded up the process considerably for some reason. It's roughly twice as fast now (I'm pretty sure that's the case but that's based on only 1 fairly extensive test). Regarding the other ideas and issues the 3 of you have generously brought to my attention, I've downloaded and bookmarked tutorials from various sites (thank you T.E.G.) and will try to get a better handle on those which will probably take me the rest of the week. Thanks again. Tag: how to fix the width of a column in grid?

Lightening

I added a new column to a grid in my form.

But it was squeezed to a vertical thin line though I can expand it using

my mouse pointer. How can I let it stay as a fixed width I set its width=75.

Thanks!

Re: how to fix the width of a column in grid?

dni

Normally you should be able to change column width, from properties window, selecting grid and then the column. Also you may check property AllowAutoColumnFit from grid to be 2.

Re: how to fix the width of a column in grid?

Lightening

Sorry, I use VFP6. I do not see AllowAutoColumnFit in my grid property.

I changed AllowHeaderSizing back and forth, but did not help.

Re: how to fix the width of a column in grid?

dni

Sorry I thought you have 9, but is valid in 6 the same think. You may select from properties (under grid1 or grid name column number and then ajust width property. You don't need to select header, select just proper column number from properties widow.

Re: how to fix the width of a column in grid?

CetinBasoz

with thisform.myGrid
.Columns( .columnCount ).Width = 75
.Columns( .columnCount ).resizable = .f.
endwith

Re: how to fix the width of a column in grid?

Lightening

Its strange. It is OK now after I changed the column's width to 80. Not sure if it's because the previous value 75 was taken by another column.

Thank you all.

Re: how to fix the width of a column in grid?

AndyKr

No, this functionality was not available until VFP 8.0