Answer Questions

• Dmitry.K 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

• turtleman getting things working on a network

  im having problems when 2 people save at the same time on my network. the person who saves last is going to over write everyone else. PRIVATE B DO WHILE !THISFORM.MULTIUSER() WAIT 'Getting Network Attention... Please Wait' WINDOW NOWA NOCLEAR ENDDO B=THISFORM.SAVEUPDATE() SELECT CLIENT UNLOCK WAIT CLEAR IF B=1 MESSAGEBOX("Client Successfully Updated",'KM SYSTEMS') ENDIF IF B=2 MESSAGEBOX("Client Successfully Saved",'KM SYSTEMS') ENDIF _______________________________ this is what is in the method multi user SELECT CLIENT IF FLOCK() RETURN .T. ELSE RETURN .F. ENDIF save update is this _______________________________ PRIVATE A SELECT CLIE ...Show All

• SharonD How to see the code behind a foxpro report

  Hello I am new using FoxPro. I have in my hands a foxpro application. This application produces reports. I can see the report design, but I dont know where to look to see the code behind the report. Can somebody tell me where can I find the coding behind a report in FoxPro Thank you Erick, Open the project, then from tools/code references search for "report form" (you might need to use regular expressions because "repo form" is as valid as "report form" - first 4chars are sufficient for many commands/functions). If you find one with the filename of you report file then you're just on target, but generally do not expect to find one. ie: In a big application we have only one line starting with &q ...Show All

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

• Amin_msw 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 I can't tell you how grateful I am for you help. YOU"RE BOTH AWESOME! I've put off converting for a few years now as I was just sick thinking about re-writing the whole application. You have renewed my faith in developing software again. Thanks! ...Show All

• Eusebiu DLL Language in Portuguese

  This is my first Post :) I work with VFP since '99 and has been always in english. Dealing with english is not a problem, but for my custumers yes, especially with error messages prompted from VFP (due to program code error ou just a crash). Is there a possibility to translate a Resource DLL to portuguese just like exists in Spanish, French, etc. This avoid me have an error routine to translate some messages (one of the common messages is "The visual foxpro support library is missing or invalid"). thx, DaCosta11. As far as I know all of the existing localizations have been undertaken by dedicated volunteers from that country - Spain, France, Germany and, I think, Russia. If you want a Portuguese DLL I am afraid that you w ...Show All

• AksaiGora SYS(3056)

  SYS(3056) - Forces Visual FoxPro to read its registry settings again and update itself with the current registry settings. Hi. I have accidentally executed "SYS(3056)" command in the Command Window. Now, whenever I open the Debugger Window (Environment: Debug Frame), VFP starts to crawl real slowly and the CPU usage jumps to 100%. Is there anyway to "undo" SYS(3056) command Thanks. Danny Thanks. It doesn't work as I am using VFP 8.0 However, I've tried Tools/Options Set As Default button. Problem still persist. I have managed to sort out the problem. Realised its got to do with the debugger. ...Show All

• samithad VFP Bug... Or is it a feature?

  Hi all; In a grid's AfterRowColChange I have the following: if CertainCondition this.AllowCellSelection = .T else this.AllowCellSelection = .F. endif This is basically to implement a 'when' for the record the user is in. I have noticed that in some cases the AfterRowColChange won't fire. I have used ReadOnly (Instead of AllowCellSelection) and it works fine. Aleniko Don't want to sound like Monti Paython but... No it doesn't... But readonly works fine. Thanks. Aleniko wrote: Don't want to sound like Monti Paython but... No it doesn't... But readonly works fine. I did not make this statement witho ...Show All

• lidiya application and webdata interacting.

  ok first off here is some info about my webserver: i dont no if you needed the information but maybe you do General server information: Operating system Linux Kernel version 2.6.17.11-grsechg Machine Type i686 Apache version 1.3.37 (Unix) PERL version 5.8.7 Path to PERL /usr/bin/perl Path to sendmail /usr/sbin/sendmail PHP version 4.4.4 MySQL version 4.1.21-standard cPanel Build 10.9.0-CURRENT 117 Theme cPanel X v2.6 ...Show All

• Freedon Nadd Strip HTML out of a memo field

  What is the best way to Strip all HTML out of a memo field I can’t think of a better method than of looping thought every charter copying one at a time but ignoring those between “<” and ”>” . Is there a better way A faster way Thanks, Sammy Regular expressions might help you out here. lcMemo = "<HTML><HEAD><TITLE>Title</TITLE></HEAD>" ; + "<BODY><H1>Header</H1><P>Paragraph</P></BODY></HTML>" _regexp = NEWOBJECT("_regexp", HOME(1) + "ffc\_REGEXP.VCX") _regexp.Pattern = "<\/ \w*>" lnMatchCount = _regexp.Execute(lcMemo) lcTest = lcMem ...Show All

• PeterGillham How to remove redundant phrase in field?

  Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown above or there could be 6. I suspect that the 'common denominator' is the semi-colon, but everything I've tried has failed. Any help is greatly appreciated! assuming that data is "V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT; I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FO ...Show All

• robinjam Working with field General!

  Hi, all! Help me to update field type General: append object, edit, open,... in VFP from program control with bottom command. (use line command MODIFY GENERAL <field gen> don't open object) Thank! If you 'have to' store in table then use memo (foxpro 1.0 and up, VFP9 BLOB). I'll add my $.02: DON'T USE GENERAL FIELDS . Alex Feldstein wrote: ... Instead: - Use BLOB fields (VFP9) or - Use a text field to keep the path+filename and keep the original file on disk You'll be glad you did. PS: Did I say: don't use General Fields What about VFP 8.0 Which data type should I use instead ...Show All

• Deleep P Native Financial Functions in VFP

  Anyone know how to simulate the financial functions in excel or vb.net Besides clarifying as Andy said, whatever functions you need that do not exist or are cumbersome to make in VFP, if the client box has Excel installed, you can always use Excel financial functions in the background through COM Automation and it will be transparent to the user. Im looking for function IPMT(). Currently I used IPMT() of Excel, but I think it is better that you have a native function. Thanks Like what VFP already has some financial functions built-in (e.g. NPV(), PV() and FV() to name but three) You can easily create your own functions to do anything you want - or are you looking for the formulae ...Show All

• pinkybaby how to return other keycode in keypress method

  this is my code:- LPARAMETERS nKeyCode, nShiftAltCtrl IF nKeyCode == -3 && F4 do form ... * return a keycode as enter ENDIF after run the form, i like to return a ENTER keycode instead of F4 keycode, may i know how to do that IF nKeyCode == -3 && F4 nodefault keyboard "{ENTER}" PS: You should think twice if there might be another way to do what you're trying to do. ...Show All

• Pete_M OLE error code 0x80040154. Class is not registered. OLE Object is being ignored

  Hi, I get the error : OLE error code 0x80040154. Class is not registered. OLE Object is being ignored . I get this error when i run a form which has a chart in VFP 6.0. Can somebody help Alex AlexDcosta wrote: I cant seem to find the right ocx or dll. If i right-click the OLE chart object on my development pc, it shows MSCHART properties. So, can u tell me what dll or ocx do i need to register at client PC. c:\windows\system32\mschrt20.ocx Hi, I cant seem to find the right ocx or dll. If i right-click the OLE chart object on my development pc, it shows MSCHART properties. So, can u tell me what dll or ocx do i need to register at client PC. Alex ...Show All