Answer Questions

• Wolfgang12345 Visual FOXPRO ODBC Drivers... still broken in Vista RC2

  Hi. Does any one knows where i can get the Visual FoxPro ODBC Drivers for Windows Vista Thanks. Helder Santos Still broke It was working and still working under RC2. However I suggest VFPOLEDB instead. Thanks for the head's up! MD Just don't let any of your users run a 64-bit version of either WindowsXP or Vista. 32-bit ODBC and OLEDB drivers are not visible or usable by 64-bit applications. We have a bunch of code that doesn't work under VFPOLEDB, but works just fine under VFPODBC so we can't just switch... plus it's a deployed application, so in order to change code we'd have to put a ...Show All

• Febin Convert ADO recordset to a Foxpro DBF free table

  Hi,     I currently have a need to convert an ADO recordset to a DBF. I've seen some posts here on how to create and write to a DBF using C# in conjunction with the VFPOLEDB provider. I mocked some code up in VB6 similar to the example and I am able to open the dbf in VFP6 no problem. However, I'd like to find out what ADO to Foxpro field type conversions would work. The ADO recordset comes as a result of a query from SQL Server 2000, so there are bound to be some datatypes that will not convert natively. I've come up with this matrix so far based on some MSDN Library materials.     SQL DataType              ADO DataType   &nb ...Show All

• Adam Machanic using amouseobj to determine current position.

  I'm trying to open up a form and position it right where the user clicked the mouse. I'm trying to use amouseobj to get the current position of the mouse but for some reason I'm having problems doing so. Can someone please give me an example of how to use amouseobj() Also, if there is a better way to do this, please let me know. Thanks. Check out ObjToClient(). It should help you make the leap. Tamar AMOUSEOBJ(ArrayName [, 1]) or you can use SYS(1270 [, nXCoord, nYCoord]) See: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/e3730f77-7138-4d79-8450-2f8cef726e63.asp   Tamar has a good article on ...Show All

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

• captainsina Views

  I am trying to write a VFP Remote View that selects data from a Microsoft Database, unfortunately some of the mssql  fields are reserved word (IN FOXPRO) so the VFP will not allow me to inlude these fields in the view.  For example this remote query pulling data from MSSQL by a foxpro view select  table1.pers_name,  table1.pers_address, table1.values from table1    returns an error because of the word Values is a reserved word in foxpro. Is there a way to get around this. I tried that but when I insert a record to the view it crashes because of the reserved words. Quite frustrating. Do it as Andy said. Put [ ] around reserved words. What you should understand is, it ...Show All

• AliciaV ? FoxBase Report Form .frm Conversion

  Does anyone know of a foxbase report form conversion software I have a customer in need. The file extension is .frm and I can't find anything on it. Thanks to everyone!! You are absolutely correct. I found out from my new client today that those reports never worked anyway, so I guess I'll construct from scratch. Thanks, Dan. >> The file extension is .frm and I can't find anything on it. That is not a standard VFP extension - it is a dBASE report and there should be at least one other file: dBase Report Extensions are: .FRM, .FRG, .FRO I honestly don't know whether VFP will open that file but you might try using SET COMPATIBLE and see if you can open it normally reports will have exten ...Show All

• acoliveira 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, Connection pooling is activated automated when you connect.You may disable it with OLE DB Services= -2 inserted in connection string (at the end). Do you have a error number like "80040e37" Can you post the error message in italian I downloaded and installed, but I already had the version 6 of the driver. Now I tried 2 things: 1) with this connection string (Prov ...Show All

• smalamas using Textbox control...

  Hello friends...    I am new to visual foxpro. I have been learned programming in Foxpro 2.6 for Dos.. Now I want to learn visual foxpro..  I had make just a simple form  with one textbox and two command buttons. I just want to do if I click command button1 then textbox show today's date and if I click command button2 then  textbox show currunt time... What codes I have to write in command button1 and 2 Need your help...thanks a lot     Assuming you haven't changed the Name property of any of the controls, code like this should work. In the Click event method of Command1, put: ThisForm.Textbox1.Value = DATE() ThisForm.Textbox1.Refresh() ...Show All

• drumstick Ideas for Desktop Wallpaper using JPEG, TIF, HTML, Etc., vs BMP?

  Hi all; much thanks in advance for any specific or general thoughts on Desktop Wallpaper automation of VFP-9 reports. Now that report listeners (VFP-9) create TIF files from reports I wonder if peradventure it might be easier to automate Desktop Wallpaper from such reports. Currently I use bitmaps as allowed by the dll: PCT_DLL.dll (see below). This works but requires akward 'Print Screen' automation do wallpaper with 'reports\visit\schedmo' && below FUNCTION wallpaper LPARAMETERS a,a1,a2,a3,a4 _SCREEN.AlwaysOnTop = .T. lstate=(_screen.WindowState) IF EMPTY(a1) or EMPTY(a2) &&etc lcBuffer=Space(22)+Chr(0) If GetPrivStr("Screen","WallPaperDimensions","", @lcBuffer, Len(lcBuffer), Cur ...Show All

• E.Ganesan Win 2K vs Win XP Pro SP2

  Hi, Just wondering if anyone has changed the development platform from Win 2K to Win XP SP2 Any problems encountered I've been working exclusively in XP Pro (SP2 now) since its inception. No problems. Changed from w2k to xp sp1, sp2 no problems with vfp7, vfp8, vfp 9. >>changed the development platform from Win 2K to Win XP SP2 Yes, I did this some time ago now, (when XP SP1 was released) and have not had any specific problems with VFP and XP. Everything seems to work just as expected. Yes I've changed from w2k to XP Pro, then SP1 and SP2. No problems. ...Show All

• Chrislm Using Visual FoxPro functions

  I'm working with Visual FoxPro 6.01 odbc driver in c++, trying to use function such as "USE" or "SYS" etc... I dont understand how to use those functions should it be used as a paramter to the function s QLExecDirect or some other function Or is it a normal function and if so what .h file i should include thanks ishay You may check: http://msdn.microsoft.com/library/default.asp url=/library/en-us/odbc/htm/odbcsqlexecdirect.asp USE is not a function but a command in VFP, which you may not call from an ODBC link. You may call a series of functions (but not all) via ODBC. I don't think sys() would be a supported function through ODBC and that makes sense to me. ODBC driv ...Show All

• Jessica Alba Modal form dilemmas

  Thank you (again) for your timely responses David, I'll focus on #4 a bit (if thats OK)... I've written MyAutoTextListForm that works for MyEditControl (class).  MyAutoTextListForm behaves like VFP-9 Intellisense (a non-modal list-form) in most basic ways.  It also behaves similar to the auto-text (non-modal list-form) property of text-controls.   Perhaps the VFP-9 AutoText property for Text-Controls is not modally affected as it probably works seamlessly with modal forms.   But MyAutoTextListForm is limited by my modal forms (namely mouse clicks).   Through much trial and error I’ve managed some fairly tolerable workarounds where MyEditControl (class) within modal forms can respond well enough with MyA ...Show All

• Phillip S. VFP & ASP.NET 2.0 COM/Interop Problem

  hi i need help i developed simple website (just for test) that use Simple VFP Com (one class have one method get the string and returns it's length) i tested the COM in VFP IDE , it;'s work fine i tested the COM in VB.NET (VS 2005) windows project , it's work fine without problem i tested the COM in simple ASP.NET 2.0 , and tested it in the web developer server which comes with VS 2005 , IT;S WORK FINE WITHOUT PROBLEMS but when i turned to ISS , i have problem when i click the command button which called my COM, this problem doesn't appear in web developer server (vs 2005-IDE) the error message is : error retriving the COM Class Factory , 80005004 i use Windows XP SP2 , ISS Version 5.1 what is wrong Greetings ...Show All

• Glenn Wilson MSCHRT20.ocx erro

  I have just restored a machine in which a program is loaded for testing. (I am not the programmer I was just hired). When I try to start the program i get the following error; mschrt20.ocx or one of its dependencies is not correctly registered. I did a full restore from backup to the new machine. The program will not start. Any Ideas I am not a seasoned programmer I am a network administrator. Your help is greatly appreciated. Thanks Christina I would like to thank everyone for your support. I removed the file and reinstalled it. Mission complete. Thank you all. Christina853 Check if you have that ocx in system32 folder. If not dow ...Show All

• Martin Eley Can Foxpro list "Directory Names" or "Folder Names" to a table?

  I am trying to produce a list of the sub directories contained within a folder in Windows. Can I Is there a foxpro command that allows this functionality to a table or array or something I am using Visual FoxPro 7.0 Thanks in advance. Richard Peterson There is: ADIR() Filer.dll that comes with VFP Scripting.FileSystemObject (aka FSO) ie: With Adir() GetTree("c:\My Path") Function GetTree lparameters tcPath create cursor dirlist (dirname m) =getsubdirs(m.tcPath) browse function getsubdirs lparameters tcPath local lcCurDir, lnSubDirs, ix local array laDirs[1] lcCurdir = ADDBS(m.tcPath) insert into dirlist values (m.lcCurdir) lnSubdirs=adir(laDirs,m.lcCurdir+" ...Show All