Answer Questions

• _PAPOO How to pass a variant value to CFRONT object (Navision) ?

  Hi, I need to pass a string value to a COM Object the method styax as follow S/W Name : NAVISION COM Object : CFRONT.OCX Method AssignField( hTable as Long, hRec as Long, FieldData as Variant) as Void My program source code is ************************************************************ loCF = Createobject("cfront.cfrontctrl.1") lc_Data = "Testing" loCF.AssignField( 1, 2, lc_Data) ****************** ...Show All

• techie3 Downloading data on webserver

  I would have an program (.exe) connect to an external webserver and download or read a datafile (updating prices)  Anyone have a idea to get this job done.  I should upload a .dbf file to www.mywebsite.com/prices/price.dbf How can i read this data into my progrs database Thanks in advance. Take a look at http://www.west-wind.com/presentations/wwCodeUpdate/codeupdate.asp  for a great example of ...Show All

• leiyangcl Computer stops after loads form

  I'm facing a rather strange problem: I've got a form wich calls another form. When I call this second form, the computer (not only VFP)stops at the last comand line in the Load method. No matter what this last line is. But it only happens if I've realized some operation before I do it. Otherwise it runs Ok. I'm using VFP6.0 and SQLServer 7.0. The Load method uses "CREATE CURSOR" and "SQLEXEC" commands only. Thanks in advance for any h ...Show All

• HMCSQL2005 create window

  I am new to foxpro and have a few questions so i will post them seperatly.In my start up program i have added _SCREEN.VISIBLE=.F. I have also added a text file config.fpw with on line SCREEN=OFF That has taken care of not displaying the default window.  Now i want to create my own main window that every form and report will be displayed in.  I also want to have frames in the window.  One frame down the side or across t ...Show All

• MS Guy SELECT - SQL COMMAND again

  In a situation like this where the first field is of type " C " and the second -- " M " SELECT RTRIM (field1), LEFT (field2,20)... INTO ARRAY arr1 The first function < RTRIM > appears to be ignored (the result has trailing blanks regardless) but the second < LEFT > seems to be doing fine. I am wondering if anybody has similar experience and how such needs should be handled. Thanks. The code doe ...Show All

• GMan2 data duplication

  If I have a table with a certian field, and in that field, there is duplicate data, How would i pull all the records with duplcate data in one field ie HERE'S WHAT I'VE GOT lastname anything tell **** soy &&&& cundo !!!!!!!!!!!! tell **** huso ^^^^^^ hydro $$$$&& cundo @@@@@@@2 HERE'S WHAT I NEED lastname anything tell **** tell **** cundo !!!!! ...Show All

• Casey S Packing a table

  I am posting a piece of code that works quite well for me in interactive mode but not after an .exe file was created. When the execution comes to the PACK command I get an error message: "The file must be opened exclusively." I do not understand why it is so. If I click "ignore" I actually see a double (or any multiple) of my record set since the next step for me is to fill the table with some records. SELECT &cAlia ...Show All

• PDMG Memory access error

  I need some help... When closing our application we are getting the error message "The instruction at "0x02245e30" referenced memory at "0x02245e30". The memory could not be "read"". We don't know what is wrong... any suggestions on how to fix this Any input would be really appreciated. >> Where do I type this "Set to null" instruction ...Show All

• RickSmithers dates

  Hi, How would one manipulate a date field to run a query on it I have a field 'date' and i need all records w/ date >= 01/01/2004. is there way to perform a search like that Mike SELECT * FROM MyTable ; WHERE Date >= DATE(2004,01,01) Luis Maria Guayan Tucuman, Argentina ________________________________ SysOp de www.PortalFox.com Microsoft Visual FoxPro MVP ________________________________ Mike, Assuming a date ...Show All

• Range_Finder Excel Automation - Charts.

  Hello Guys The code below works fine (complete code). The problem is, how can one set the number of rows in the following lines. These two lines sets the chart data parameters. Although one can use "oSheet.UsedRange.Rows.Count" but how to encorporate it in the code. Please complete the following 2 lines. oExcel.ActiveChart.SetSourceData(oSheet.Range("A2:A16,E2:E16"), xlColumns) oExcel.ActiveChart.SeriesCollection(1).XValues = "=History!R2C1:R16C ...Show All

• Santosh A H _urlcombobox problem

  I am trying to use this object since it offers much convenience as opposed to shellexecute. This is the problem I run into. When I issue commands in INIT: THIS.AddItem ("www.msn.com",1,1) THIS.AddItem("www.yahoo.com",2,1) THIS.AddItem("www.pdr.net",3,1) The items appear in combobox doubled. This set of urls is repeated twice! Not every url is doubled individualy but the whole set of three urls. This i ...Show All

• osydney ActiveX registration question

  I just downloaded Andy Kramek's book 1001 Things .. and ran through many pages. It is an awesome work! Clearly written and just very good for learning. I tried to find an answer to a question I have (among others) but it does not seem to shed any light on it--the question is rather specific. I tried to play with some ActiveX controls that can be found in Tools-->Options-Controls menu but some of the most interesting ones I could not even d ...Show All

• Grant_csi how to create an exec file

  I want to create an .exe file out of a project which includes a few forms and a number of .prg files. I want to run it with a shortcut on my desktop and I do not want to see any VFP shell (main window) around the main form. I tried to read some help but could not figure out how to get beyond COMPILE command. It does not seem to be useful for this purpose Thanks for any help. Alex, Create a project and add your files to it ...Show All

• Rajesh Giri Spell checking?

  Well, as sort of a follow up, I am using the ActiveX RTF for one of my forms. What I'd like to know if there is a way to do sort of a spell check for what a doctor would type into it. Any one know I want your sample code too. It is a neat idea. Will this method highlight the misspelled words in RTF There is also another option: APSC - All Purpose Spell Checker which is also downloadable: you can find it on the web. It will have to be ...Show All

• Leif902 How to link a VFP DB to SQL 7 DB using Linked Servers

  Hello All, Please, if anyone can let me know how to link a VFP DB to a SQL DB using 'linked servers' that would be great. I need to use the VFP tables in a SQL Server Reporting Services report. Using ODBC w/ a DSN (or even a connection string) locally works fine in .NET 2003. But when trying to use this method on the reporting server, I get some nasty error. To avoid having to write a trigger and a DTS package to populate the SQL DB with the ...Show All