Answer Questions

• Avi_harush Importing to Excel

  Dear Friends, I would like to export my cursors to Excel file but when I do this they send only the datas of one cursor and the rest not. How to do this eg ; SELECT cursor1 SELECT cursor2 SELECT cursor3 copy to compare.xls type xls only the datas of the cursor3 will be exported not for the rest advance thanks for your suggestions satish Satish, The COPY TO command only operates on the currently selected work area. If your 3 cursors are all the same structure you can use a SQL-SELECT to create a single file: select * from cursor1 ; into cursor4 ; union ; select * from cursor2 ; union ; select * from cursor3 select cursor4 copy to TheFile.xls type xl5 ...Show All

• Digital Farmer LIST BOX

  I can not use a list box.RowSourceType is 6.I am using a database with 37 records.The list box is showing nothing.Sometimes is showing some items but I can not select them. If I build a string from database the list box is working fine. If I not use "SET FILTER" list box is also working fine.Some ideas Thanks dni wrote: I can not use a list box.RowSourceType is 6.I am using a database with 37 records.The list box is showing nothing.Sometimes is showing some items but I can not select them. If I build a string from database the list box is working fine. If I not use "SET FILTER" list box is also working fine.Some ideas Does it work better if you use RowSourceType=3, and SELECT fields FROM tabl ...Show All

• Deanrm Proper practice - edit a table in a grid.

  Hello everyone; I have a very simple form with a grid. The grid's record source is set to a cursor which contains a subset of a single table: Select * from PriceList where acct = cSomeAcct into cursor curPl I would like to add an edit button on this form which will alllow the user to edit the grid and update the Pricelist table. My question: What is the recommended way of doing this I thought of a few ways including issuing a "delete" and then an "append from", or maybe updatable views. How would you do this Thank you all. Hi Cetin >> I don't understand where I meant to use filters. I agree editing in a grid is not trivial but it works quite well ...Show All

• Grahamrounce updating VFP tables from C# ?

  I am trying to update some of my tables from a C# code. When I use a RecordSet class I get this error: + $exception {"Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype."} System.Exception {System.Runtime.InteropServices.COMException} When I open the connection via a DataSet class and use a DataTable I can update the fields but the changes are never accepted: dt1.AcceptChange() does not work. No error is generated though. In both cases the connection string is the same. I use OLEDB connectivity with VFPOLEDB.1 provider. I could post more code but first want to get some experience from anyone who has done something like this. Many thanks. Ale ...Show All

• tarzan123_us Excel header/footer fonts and automation

  Hi, I did a search but didn't see this topic brought up. I want to change the font of my header in Excel (ver 11) using Visual Foxpro (ver 9). I used the macro recorder in excel to get a general idea, but I can't seem to get the code to work in VFP. Here's the excel code: ActiveSheet.PageSetup.LeftHeader = "&""Arial,Regular""2nd QTR 2006 vs 2nd QTR 2005" How do I get that code to work in Fox Any help would be much appreciated! Jeff XLApp = tmpsheet. Application XLApp.WorkBooks. Add () xlsheet = XLApp.ActiveSheet xlsheet.PageSetup .LeftFooter = "-Footer here--" That worked perfect, thanks! ...Show All

• Justin Voshell Visual Foxpro report writer

  I have a dbf with following fields bill no, bill date, cust name,item name,qty,rate,amount and i have 553 records. i want a simple report on 132 column stationary. i dont want totals also. (so no page footer or summary). i used visual foxpro report writer. but the report does not print with proper ejection i.e. second page starts printing from bottom of first page and third page prints from bottom of second page and so on. printer is absolutely fine because documents from excel and word print with proper page breaks. can anybody help in dos based foxpro we can set the page length sir. but in windows foxpro how do i set the page length. i am selecting us std fan fold for paper setting. i have tried quick report sti ...Show All

• mako_123 Font Size Randomly Changing

  Has anyone experienced a problem in a FoxPro 9 application, where the font size of some controls on a form change It could happen going from form1 to form2, or form3 to form2.  The size changes from 9 to 8, 12, or 18. There doesn't seem to be a pattern, and it could happen today day and not happen for several days later. May be you have problems with gdi+ lib. http://msdn2.microsoft.com/en-us/library/ms947605.aspx >> I've thought that it might be that, but with the number of users experienceing the problem I don't believe that would be the problem. I would also think if it was the windows font problem then other applications would have the same problem. As I said earlier in this thread, I dou ...Show All

• Samuel Nakano command window always on top

  Hi, I am trying to figure this out for over an hour without much luck. When I open a table and browse it, the command window always stays in front. How can I get it to go to the back so it won't be in the way Thanks, Mark Thanks, it worked like a charm Right-click on the title bar of the Command window and uncheck Dockable. ...Show All

• voevoda Moving text cursor to the end of line

  I have a questions about text fields in forms, I have a field where a user types in an article but inputs a lot of invalid characters like ' & ' or ' <br> ', im trying to convert these to the correct syntax when typed in. So far I have it working so that when someone types in ' & ' it turns into ' &amp; ' (the correct HTML coding), but there cursor appears after the character they typed and not after the text I inserted. How can I move the cursor to the end of the line   Spangltk wrote: How can I move the cursor to the end of the line KEYBOARD "{END}" PLAIN     ...Show All

• Benin SCATTER/GATHER

  Hou can I "scatter" in a method (valid) and "gather" in other method(click).My vf.7 is forgetting all "m." variables between methods. Thanks, Daniel dni wrote: My opinion is: This is a visual fox limitation. You can declare a variabile as "PUBLIC" in "INIT" and can use it over all scopes, until release it or release form. Scatter/Gather should work in the same mode.(If I am using 10 databases and I am doing 10 "scatter" I will "charge" my form with 10 objects. Actually, SCATTER/GATHER does use existing variables, given the chance. CREATE CURSOR fred (cField1 C(1)) INSERT INTO fred VALUES ("A") INSERT INTO fred VALUES ("B&qu ...Show All

• MaggieChan Printing Rich Text

  Hi, all Can anyone tell me if I cam print th content of a Rich Text Box In case I can't, is there any way to print formated text (i mean, with justification, italics, bolds, etc..) Thanks a lot   David.Cheung wrote: ... Starting from this year, all the new project started to use HTML in most of the reports. so, I use the HTML format instead of RTF as the source text. ^O^   Hi David, how do you incorporate HTML in reports Thanks, Danny. I use OLE object to do that. I use a table with GENERAL field storing each 2 lines of the RTF source. And print it out like an IMAGE/PICTURE in the report. That job was finished 2 years ago. And ...Show All

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

• IXOYE333 autoincrement problem foxpro ADO and Visual C++.net

  Hi I am trying to enter a record into a table that has only two fields (for simplicity) the first (fielda) is of type auto increment and the other(second) is char 100. I can not insert data with the command INSERT INTO table (second) VALUES ("firstrecord") When i do this process driectly from an sql interface in VISUAL C++ IDE it runs ok. Hi, The error I got is "Not a table." VERSION of IDE / COMPILER microsoft development environment C++ 7.1 I just created a windows form project and in public __gc class Form1 : public System::Windows::Forms::Form function i put the following code String* stringCustomer[]; stringCustomer = new String*[1]; CD ...Show All

• Antarctica VFP TIMER MEMORY PROBLEM

  Hi All, Our product is a 24/7 Hospital product and i face a critical issue in Timer control. The below code is a small example of my process, i created an exe of this code and this runs as a process in the task manager. The issue is this eats up memory consistently in time intervals. if this exe is ran for days the memory is used is like in MBs and slowing down the PC's performance. TimerCtrl() procedure TimerCtrl LOCAL poTim poTim = createobject ( "iTimer") poTim. interval = 1000 poTim. enabled = .t. read events endproc *========================================================================================================================= define class iTimer as timer fun ...Show All

• Quilnux How to make a web page in VFP

  May I please know what is the easiest way to make a web page using VFP 6 or 7. For a start I may just put some photos and then use a table to accept input from user. Thank you for your help. Rolly Thank you very much for your quick reply. God bless you for helping other people. May all go well with you. Rolly Militar Check www.activeVFP.com , www.west-wind.com etc sites. You might as well get visual web developer along with express editions of .Net products from msdn.microsoft.com/express (and do a simple page within minutes from a VFP table even if you don't know .Net - just an idea you should also check that, anyhing is not that simple f ...Show All