Answer Questions

• jakub78 Errors running FoxPro Stored procedures in .NET windows app

  Hi I want to run a stored procedure in user selected database which basically creates two new tables to be persisted in the same database. I am able to call this stored procedure but I keep getting the same error "One or more errors occurred during processing of command." There are no details of what the error is specifically about. I am able to run the same stored procedure using Microsoft Visual FoxPro 9.0 software. My Connection string is "provider='VFPOLEDB.1';data source='strPathName.dbc';password='';user id='';Mode=ReadWrite". Any ideas or suggestions are appreciated. Try If VFP7Connection Is Nothing Then VFP7Connection = New OleDbConnection(VFP7ConnectionDefinition) If VFP7Connection.State = ConnectionSt ...Show All

• KRSE How to handle transaction consisting of different data sources?

  I want to know how to handle transaction consisting of different data sources (e.g. VFP dbfs and MS SQL tables). Thanks, Peter Hi Tamar, I'm reading an article by Craig Berntson that mentions using the DTC to participate in DTS transaction. Is that still applicable to VFP9 SP1 Thanks, Peter Hi Craig, Thanks for the post. I will check your website for the updated article. In my case, I have a VFP application which is using VFP data and another VFP application which is using SQL Server tables. Now, I want to add a module from the VFP (SQL tables) application into the VFP (VFP tables) application. So, for some transactions, I will need ...Show All

• Jhedron Excel & Foxpro 5.0

  oSheet.Paste(oSheet.Range('A30')) Looks like I'll end up writing your whole code step by step. Please create a new thread next time so others would also deal with your questions. oExcel = Createobject("Excel.Application") With oExcel .Workbooks.Add .Visible = .T. With .ActiveWorkBook.ActiveSheet .Range('A1:F10').Cells.Value = 'filledbefore' .Range("1:6").EntireRow.Insert Endwith Endwith I don't know what you mean by transparent. Maybe you meant this: oExcel.ActiveWindow.DisplayZeros = .F. ...Show All

• skynes Programmers out there Pls Help

  Please Help me... I really need a Sample Program its because We have Project and I don't know how to create a Form Program using Foxpro 6 can someone please Help me... Any Program will do... just a simple Program using Foxpro 6 Please I really need some Help anything... just a Simple one... please please just send it on my Email mobidest6600@yahoo.com Thank you Please I really need some Help... I don't know how to use foxpro This is a VFP program you can use: MessageBox("YOU SHOULD DO YOUR OWN HOMEWORK!") Thats it. CodyPasspied wrote: I really need a Sample Program its because We have Project and I don't know how to ...Show All

• dagjo VFP9 applications running much slower than VFP6 and VFP8

  I have same vfp application program. But I found that it run much slower than previous version when loading a form in vfp9 compiled application. Anybody have same problem At the first time loading form is slow and second time is fast. Close the form and loading the form again, it change slow again. I don't know why It never happen in VFP6 and VFP8 before. Same program and same computer. I set SET TABLEVALIDATE TO 0. It is still same slow. Nothing change. Only loading the form. Try setting Enginebehavior 80 and see if this helps. Also, is it just loading the form or something in the load events that slows down Are you using any collation sequences other than the default If so, m ...Show All

• withRajeev Accessing VFP 8 through C# and ODBC

  Our company has an online product ordering program that accesses our VFP 8 accounting package through an ODBC connection on our server. Occasionally, our system error log table will trap the following error: "ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]This file is incompatible with the current version of Visual FoxPro. Run 30UPDATE.PRG to update the file to the current version. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)." All the offending lines are doing are forming a SELECT statement: OdbcConnection ODBCConn = null ; O ...Show All

• barkingdog Command contains unrecognized phrase/keyword VB.Net

  Hi I am facing the above problem when I am trying to insert a MEMO data in to the VFP table. I am using a OLEDB connection string in VB.Net My data present in the file is //------------------------------ Pen Pencil Erasier Sharpener //---------------------------- Each an every line has a (Vbcrlf) that is a line feed in it I need the File as in the above format to be stored in the memo file without any change I get the data from the file by the following procedure ---------- Dim lstrData As New String (" ", 500) FileOpen(1, "C:\soc.txt", OpenMode.Binary) FileGet(1, lstrData) FileClose(1) -------- I get the data in the lstrdata Now I use sql statment to insert i ...Show All

• PaulCzy Grid Reusable Form or Active-X question. Any Help?

  Hi, A problem I am always facing when I am creating a new software is the following: I usually need in every software a grid to display my records in some sort of way from a table of cursor. Ok the grid will change a bit from form to form and from software to software (different row colors, sometimes I ll need to sort by columns somentimes not, different fonts, buttons in grid or not or others things etc etc). Is there anywhere around the Internet such a ready made form-grid or Active X control that will do my job instead of each time spend a day of recreating it from almost scratch If it is also free (or cheap!) it would be really really very very nice :) Any help Thanks, Athan PS. Also any other forms - or links that ...Show All

• UmairKhan switching pages in pageframe

  I want to be able to detect when I am clicking on a page tab to switch pages, so I can control which portions of a lostfocus event on an object in the current active page will execute. I appears that I can't use mouseenter on the target page, like I do on command objects. Ok, I've been trying another tack, albeit a little kludgy - placing invisible commandboxes over the tabs. Problem is, I can't find any combination of placement of commandboxes on pages or screen, with any setting of zorder, that will keep the buttons in the list of active objects. It's sort of like the area of the window taken up by the tabs of a pageframe is a dead-zone for objects, and all mouse events are directed to the curre ...Show All

• Craig Bye System resolution

  Hi. How can I find out what the system resolution is, and how can I change it via FoxPro Thanks I have found this site before, but the Sysmetric is better for fining out what the system resolution is. Anyway I want to know how to change the system resolution. I will be glad if someone tells me how to do so. Thanks for advices Misiacik7 wrote: You mean the right way how to do that is to resize the form I tried, it works but if I want to run this form on 640X480 I have to degrease the font size of all of the controls some to value of 6. You do not say which version of VFP you are using, but you could always set the ScrollBars property of the form ...Show All

• Eric George 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. 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 temporary. ...Show All

• Bridel Vinamit How to email with Chinese characters

  I used the code provided by Dave M. as follow: loConfig = CREATEOBJECT('CDO.Configuration') loCdoMessage = CREATEOBJECT("CDO.Message") loCdoMessage.Configuration = loConfig loCdoMessage.From = "info@wantit.nl" loCdoMessage.To = "info@microsoft.com" loCdoMessage.HtmlBody = "Body text" loCdoMessage.Addattachment("c:\file.doc") loConfig.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 loConfig.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "yoursmtpserver" loConfig.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 loConfig.Fields.Item("http://schemas. ...Show All

• CalinMac 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. Hi Cetin >>If they ever created on disk If they ever created on disk I assume you are referring to those cases where VFP will offer a filtered view in memory rather than create a physical disk pre ...Show All

• Ian1971 Hackers Guide worthy for VFP 9?

  The Hackers Guide only goes to VFP 7, for those who are in visual foxpro 9 is it still useful thanks! Yes. Although it does not cover the newer functionality, I find it very useful as most of it is still relevant. I even have the older one for VFP 6.0 which was a huge and heavy book. It stays on the shelf because it comes with an electronic version!! I use F1 for VFP Help and assigned ALT-F2 to trigger the Hackers Guide help file. The examples still work and the articles are better explained than in MS Help.  My setup configuration file calls a routine that sets the mewnus and environment. This is the relevant portion: * Setup Hacker's guide to ...Show All

• ruckuss 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 no. us std fanfold is paper size. i am putting the paper in spraket. i.e. sticking the paper in holes. and it is a portrait layout. i am using continuous stationary only. but i cam ...Show All