Answer Questions

• blange how to backup data to CD using vfp 6?

  Hi I'm trying to backup my data in zip format to CD through foxpro 6. Anyone know the solution Ms Yap To compress files use one of the many libraries (generally DLL or OCX) that create ZIP files: DynaZip http://www.dynazip.com Xceed ZipLibray http://www.xceedsoft.com/products/ZipCompL/ EEVA ZIPMASTER http://www.eetasoft.ee/zipmaster.htm X-ZIP http://www.xstandard.com/download/x-zip.zip   To copy to CD you'd have to send it to the CD drive and use the CD provided software (e.g. Nero) to do the actual writing. ...Show All

• Peter Richard 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 1. You may fill a array with data from cursors and then export in excel format. 2.You may export in 3 excel diffent files and join them with excel(you can make a macro). Copy to xls is almost useless. Here is a sample using ADO instead. Select emp_id,First_Name,Last_Name,; Title,Notes ; from (_samples+'\data\employee ...Show All

• Ron A. Buckton SELECT .... INTO TABLE <existing table>

  G_TempDBF = "C:\scratch\" + SUBSTR(SYS(2015), 3) + ".DBF" SELECT field1, field2 FROM myTable INTO TABLE (G_TempDBF) USE (G_TempDBF) ALIAS CUSTOMER INDEX ON field1 TAG field1 I have created a temporary table, stores the retrieved records into it and alias it CUSTOMER How can i reuse this temporary table for other SELECT statements SELECT field3, field4 FROM myTable INTO CURSOR CUSTOMER ---> results in an error saying Alias CUSTOMER has been used. Alex Feldstein wrote: You can't. If you want to add to an existing set, and the previous cursor is R/W (use the READWRITE keyword in SQL statement), then simply APPEND FROM the new tremporary. ...Show All

• Terry Smith sending email through Visual FoxPro

  Sir, i have got one small program which has menu item report. when clicked on report push button the vfp generats a report (shareholders details who opted for adr). basically it is a 80 column report with just folio no,name of the shareholder, address of the share holder, no. of shares offered and weather some doucuments affixed. after viewing the report if the user clicks on email the report should be emailed to 2 common mail id's which i should be able to set inside the program. i will be greatful if any body can help me with the code thanks and regards (lakshminarayana r) Check: http://fox.wikis.com/wc.dll Wiki~MethodsToSendReportByEmail~VFP No outlook. only internet exp ...Show All

• nhaas Future of Visual Foxpro

  Hello friends, I have a general question. What will be the future of VFP The reason for asking this question is because, our company is planning a major commercial software development. So far we were very much satisfied with VFP. But now doubts are being raised whether we should base our investment on this platform or consider something new like VB.NET. Especially when we hear that the products will not be served beyond 2009!!! Any sincere opinion will be a big help. Thank you. Financial Investment companies here in the US often use the phrase "past performance is not an indicator of future returns". The same holds true with software. Just because old applications continue to run fine does not mean they will cont ...Show All

• Viking_p MS SQL Server or VFP Database???

  Hi every one, hi MVFPs, I am working with SQL Server database, but I wonder that I've got some big problem with SQL table that has more than 500,000 records. If there are about 50 connections access to that table with select, update,,, task, the SQL will become very slowly and return error message as: ....query out of time,,, or dead lock.... If I work with VFP database, there are about more 100 connections with command "use" the table, and so often tasks to seek, select, update.... but It still work well even if not too fast. And I have a VFP table with more than 1,5 billion records working hard like that. So now I don't know if I will working with VFP database or getting SQL instead because of the more security of usin ...Show All

• GethWho datatype casting

  Hi, I want to know how to convert or cast a string to an int. Thanks INT(VAL(string)) In VFP, you can also use CAST(cString AS I). Tamar ...Show All

• chris_dev Dbf Autoincrement with ADO

  Hello everybody, I created a table with an autoincrement field( CREATE TABLE `Synch_LogFile` ( `ID` I Autoinc NOT NULL, `TableName` C (100) NOT NULL, ...) ) when I try To open it by ADO with VB (Select * From Synch_LogFile) I get this error message: [Microsoft][ODBC Visual FoxPro Driver]Not a table. What's I'm doing wrong Thanks, You may try to disable connection pooling. nothing changed You are using the old ODBC driver which dates back to VFP version 6. It does not understand newer types as incremental fields which came out in later versions. Your only choice here is to use the newer OLEdb Provider as the ODBC Driver has not been updated. You can download it here . ...Show All

• JWedg Imagelist control

  I want to add the imagelist control to the treeview control(ocx) but I keep getting a message that I have to initialize the imagelist control first. How is this done The treeview works fine. Both ocx controls are dropped on the form but I have been consistently getting the error. Appreciate the help. && BUG: Set ImageList Property of Treeview Visually - MSKB Q163803 THIS.oTree. Object .Imagelist = THIS.oImageList.Object Giulio Alex, Thanks for website. The example was good enough to get me finally working. I've already sent David a note but wanted to thank you too for sending me in the right direction. JohnL David, Thanks for your ...Show All

• lawrenceville_bruce Listener-HTML Wallpaper Automation?

  Desktop wallpaper is become straitforward ... ie., DECLARE INTEGER SystemParametersInfo IN user32 INTEGER uiAction, INTEGER uiParam, STRING @pvParam, INTEGER fWinIni lcBMPFile = "BITMAPS\MYSCHEDULE.BMP" loListener = CREATEOBJECT ('ReportListener') loListener. LISTENERTYPE = 3 REPORT FORM &a OBJECT loListener loListener. OUTPUTPAGE (1,lcBMPFile,105) && 104 = GIF, 102 = JPG, 105 = bmp (only bmp seems to work) = SystemParametersInfo (20, 5, @lcBMPFile , 3) && Voila ... desktop wallpaper (albeit with a 'white paper' border) Now, how to make HTMLs (vs. BMPs) become window's desktop wallpaper in similar manner (...Being an avid enthusiast of Doug Hennig's Hyperlin ...Show All

• Joe You the grid's recordsource is from combobox

  Hello, I have a beginners question. In my form I have a grid, combo box, some edit boxes. When I run the form the grid is already filled with values by default, when I select one of the rows in the grid, particular values are showed in the text boxes also (mainly the values of the selected row in the grid). When I select the value from the combo box which filters some information (I use cursor for that thisform.grid1.recordsource="apieprek") and then feed the grid with new filtered values, the particular values doesn't appear into the text boxes when i select the row in the grid. Thank You in advance. If you want to display the information in textboxe/s of particular record when you select on ...Show All

• 67RAM67 Shed any new light on VFPOLEDB directions?

  Any info available on VFPOLEDB new versions or updates coming down the pipe I'm not holding my breath, but let me know if there is any info available...... Thanks Dan Ribar If there was anything that could be shared publicly it would be posted here: http://msdn2.microsoft.com/en-us/vfoxpro/bb264582.aspx Milind Lele, the VFP Program Manager, publishes a monthly letter with news.. ...Show All

• DaPosh character fields to numeric

  I have a table with some fields like as below which are characters. i want to convert them to numeric and store them in another table. can someone assist me please field_1 field_2 field_3 000000057770.00 000000057770.00 000000000000.00 000000154948.00 00000-279204.00 000000434152.00 000000069766.00 000000016928.00 000000052838.00 Yes did it as stated but the negatitives showed as zeros. However i did it this way and it worked. mtot = TRANSFORM(EVALUATE(field_1)) mnth = TRANSFORM(EVALUATE(field_2)) marr = TRANSFORM(EVALUATE(field_3)) then replaced the variables in amother field REPLACE field_4 WITH val(mtot) REPLACE field_5 WITH val(mnth) REPLACE field_6 WITH val(marr) i'm usi ...Show All

• Alex Ivanoff How to adjust column width when export to Excel?

  I hv created some table and want to save it as Excel I used "export to <filename> type xls" to do the job I find that the result table column width is too narrw that it can't display the contant can I adjust the column width when export to excel how can I do that with just export command you can't. You need to do some automation. ie: lcXLS = fullpath("yourxlsfile.xls") oExcel = createobject("Excel.Application") with oExcel .DisplayAlerts = .f. .Workbooks.Open( m.lcXLS ) .Activeworkbook.ActiveSheet.UsedRange.Columns.Autofit() .ActiveWorkbook.SaveAs(m.lcXLS, -4143) && xlWorkbooknormal = -4143 .ActiveWorkbook.Saved = .t. .Quit endwith ...Show All

• rob2xx2 Help converting string to numerical value

  hi, I'm trying to convert a string to a num with VAL(variable) however it returns a whole number with a decimal place. i.e. 69232.0 , how can I get VAL to just return a whole number Thank you! aa = '69232.0' bb = CEILING ( VAL ( aa )) bb = int(val(aa)) ...Show All