Answer Questions

• Whoisit How to fix grid headings?

  Can we do that It does not help if I set: AllowHeaderSing=.f.   Can move or not:) Thank you. This is exactly I meant. Then what does "Movable" mean BTW if you meant not to allow "sizing" of headers then: thisform.myGrid.SetAll("Resizable",.f.) For a column it controls whether the order can be changed at run time by dragging a column to different position. I think you meant AllowHeaderSizing. If you set it to .F. header height is not allowed to change. It doesn't have anything to do with column positions (I think you meant it). To do that: this ...Show All

• Synced Record repositioning

  To debug this, try running the app yourself with the Debug window open and a breakpoint on RECNO("the affected table"). Most likely, it's a command like COUNT or something else that moves the record pointer. Tamar >>The problem is I can go into the exact same record that the user reports the problem on, do the exact same sequence of keystrokes, and the problem doesn't occur. Well, the one thing you can be sure of, it isn't happening spontaneously! There must be some item of code that is being triggered by a condition that arises on your user's machine and not on yours. Could an environment setting be different Or maybe they have some bad data that is causing your error han ...Show All

• PaulWoodcock Converting Foxpro 2.5 to Visual Foxpro 6

  I opened up my Foxpro 2.5 project under VP 6.0 an none of my screens work. When I try to modify the screen I get message much like this. Error loading File, record number 5 InLine3 < or one of it's members> ColourSource: Expression evaluated to an illegal value. I know I am late in the game converting but I sure hate the idea of redoing all these screens. Does anyone have any ideas. Thanks in advance If memory serves me I believe this is due to graphics on your form. Someone made a utility that changed all these ColorSource = 3 to another number. I had to open each form's scx file as a database and change all of mine before I ran the screen converter. Open the form as a data ...Show All

• Frank_Booth Where does the code go when adding to a grid

  My grid is programatically created. I would like to "fire" the Thisform.grditem.column1.text1.programaticChange event , however It does not exist visualy to do so. The value of the text box is altered but I do not know how to change the main table. Where would the code go My goal has been to change the value in the main table from a select statement cursor. Any help would be appreciated. Richard You are most welcome. Thanks for the help, that is exactly what I did to make it work. thanks again for your help. Richard, When you are working with a grid, you are working with the grid's underlying cursor.  (Note that a cursor ha ...Show All

• Will C.404367 Forcing code into a Click Event

  I have added a grid to a form. I'm using the code below to control the contents of the grid. I want to react when the user clicks on Column4.Text1. How can I add an IF...ENDIF set of code to the ThisForm.Grid1.Column4.Text1.Click event WITH ThisForm.Grid1 .RecordSource = 'viols' .Column1.ControlSource = 'viols.oxv' .Column1.Width = 83 .Column1.Header1.Caption = 'Current status' .Column2.ControlSource = 'viols.violation' .Column2.Width = 320 .Column2.Header1.Caption = 'Violation' .Column3.ControlSource = 'viols.allowed' .Column3.Width = 81 .Column3.Header1.Caption = 'Violation Amt' .Column4.ControlSource = 'viols.new_oxv' .Column4.Width = 104 .Column4.Header1.Caption = 'Change status to:' ENDWITH ThisForm.Grid1.Column4.Tex ...Show All

• Amos Soma Problem with Browser activex control

  I have a vfp form with a browser activex control (which I've named ole1). I use the browser to display an html page which uses javascript to create a text editor object like this: var oFCKeditor = new FCKeditor( 'FCKeditor1' ) And then (again in javascript) I can set up the text to be edited like this: oFCKeditor.Value = "Some html <b>text</b> here" Is there a way of accessing the oFCKeditor object from foxpro after the page has been displayed I've tried something like Thisform.ole1.document.oFCKeditor.value but that doesn't work. Malcolm Thanks Alex ... that did the trick! Actually, my editor object wasn't listed as an element or the form, but it was in ...Show All

• Jamie Thomson Remote views on SQL Server 2005

  I have a simple RemoteView on an SqlServer 2005 database. Select id, ammount from table where month(data)=MONTH(GETDATE()) When I make an update on a single record it update all records for that id not only for that month. What's wrong You are not showing the update code. I'm not clear. Is this a VFP remote view to a SQL Server 2005 DB The query you showed only returns data for a certain month for all IDs. You are asking to update for one month for a single ID. Something like this maybe Update mytable set amount = nAmount where month(data) = nMonth and ID = cID ...Show All

• KathyGirl Same Report...Different Printers?

  Hi all, What may be causing the same report file to print differently on different printers We are developing the reports in VFP9 and we make sure that tag and tag2 fields are emptied before compiling the exe. The differences are various like: 1. Difference in left/top margin. 2. Extra blank spaces left out in the middle of the report on certain printers. 3. Shift in borders printed along the edge of the report. The printers in question are HP LaserJet 4000, Brother MFC 3900, ADOBE PDF, Microsoft Fax/Document Image Writer. The latter 2 always leave a very small left margin. All thoughts are appreciated. Bini look at margins in printer settings... Different printers have different settings. Since you are not specifying anything ...Show All

• l33t image from webcam

  hello! i am new in vfp and i have vfp6.0 now i create database include ole object field i need to tab skip image field and create one cmd button call take picture and i connect my web cam so image come from webcame and store in pic foleder also delete button so cancel only image not record thanks To delete a image the simplest mode is to replace the field value with a blank image. Here you can find some good information about capturing images from your webcam: Using Video Capture: displaying on FoxPro form frames and previewing video obtained from a digital camera http://www.news2news.com/vfp/ example=437 HTH Cesar Can you give more details ...Show All

• shido What comand to clear content of General field?

  - What comand to clear content of General field Now I only use menu Edit/Clear to clear content of General. I want use commad in program to clear it. - Why when cleaned content genefield but size of file .FPT too large ! Thanks! Table customs.dbf has field CUST_BMP(G) ... 1 -Now I want clear content field CUST_BMP all Use customs share Scan for not empty(cust_bmp) Append general cust_bmp EndScan ... 2- Why when clear content of general is OK but size file.FPT too large blank field genFieldName However do NOT use general fields. FPT bloat is just one of the problems with it. Just store path&filename. If you have to store the ...Show All

• resnickaXXX anything wrong ?

  is there any thing wrong with this expression because its giving me an error. thanx for the help SCAN FOR BETWEEN (ldDate,from_date,to_date) ! EOF () Actually, it's easier than that. SCAN FOR implies WHILE !EOF(), so leave that off. The statement can be: SCAN FOR BETWEEN(ldDate, From_Date, To_Date) There is not any operator or scope clause between 2 functions. scan for between(ldDate, from_date,to_date) && no need for eof() check scan does that for you   scan for between(ldDate, from_date,to_date) while !eof() ...Show All

• Muralidhar M S VFP7 COM+ error while calling from ASP.Net 2.0 on IIS6

  Hi, I have an ASP.Net 2.0 application which interop with VFP7 COM+ (using DCOM). It was running fine on IIS5, WIndows 2000. Recently I migrated the server to Win2003 and IIS6 is running on native mode, and I couldn't get the COM+ running, below is the information and hope someone here could help: 1. If the application pool identify set to 'Network Service', I can't even create the COM+ object in the ASP page even though I have granted the 'Network Service' account with neccessary NTFS folder permission. 2. If I change the identify to let say Local System or Administrator, I have no problem to create the COM+ object in ASP page, and VFP codes in the OLEPUBLIC class Init event has actually being processed as well (for example I put a Create ...Show All

• Ha Duo A problem overwritting a temporary cursor

  I have the following code in a procedure that is called from a combo box. The first time trhough everything works great. when I call it a second time I get "Alias name already in use." I need to redo the temporary cursor baised on the selection of the combo box. Any ideas Thanks in advance. ThisField = ALLTRIM(CGames.DataField) SELECT date,&ThisField,ball1num,ball2num FROM btldata INTO CURSOR CGridCursor READWRITE Worked great thanks. I dont know why I didnt think of that solution just fighting with it for too long. if used('CGridCursor') use in 'CGridCursor' endif ThisField = ALLTRIM(CGames.DataField) SELECT date,&ThisField,ball1num,ball2num FROM ...Show All

• AndyL [OT] Help in translation

  Hello all, I need English native speakers’ help to correct the English text of my description of User-defined functions LCK Visual FoxPro and the several comments in the C++ and VFP source code. They will be disseminated as a free of charge download. But first I would like to tell you a bit about myself. I am an author of User-defined string functions. Each day my functions are downloaded on average by 30 people from around the world. More than 16 000 people have already downloaded my functions. My functions include versions for MS SQL Server (7.0, 2000, and 2005), MS SQL Server 2005 CLR .Net, Sybase ASA, DB2 and Oracle. I would like to bring to your attention that I found errors in the VFP, MS SQL Server, Sybase and DB2, which attests ...Show All

• Sqnyy Replace doesn't work

  Ok , what I'm trying to do is to generate a new ID every time I append a new record, this is the code I use I find the maximum value and store it to a variable CALCULATE MAX (invoice.id) ALL TO var_id Increment the variable var_id=var_id+1 I replace the "id" field with the variable, but it doesn't work REPLACE invoice.id WITH var_id What could be wrong the field's value doesn't get replaced with the variable's value The CALCULATE command moves the record pointer to EOF() (it has to, to be sure it has checked all records) REPLACE has a default scope of NEXT 1 - i.e. it only replaces data in 1 record. If you are at EOF() there is ...Show All