Answer Questions

• Asday using INPUTBOX()

  hi guys...is there a way wherein i can make the text in the input box to be hidden like in password i need it asap..thanks for me i will call another form pop-up then user input password. in tis case inputbox not suitable. HTH I think he meant show what the user types in the textbox as asterisks just like a password entry. I don't think that's possible with the INPUTBOX() function, you could create your own form to simulate this though. Either put nothing as default value or just put a series of asterixes. ...Show All

• thedewd I need to create multiple froms or selects into one cursor with recno()

  I need to take this statement: select recno () from ProvIDs as PRecno and I need to add it to this Statement: select i.DrID,; ALLTRIM (p.PrvLName)+' '+ ALLTRIM (p.PrvSuf)+','+ ALLTRIM (p.PrvFName)+' '+ ALLTRIM (p.PrvMName) as ProviName,; i.SiteID,; ALLTRIM (s.SiteAdr1)+','+ ALLTRIM (s.SiteCity)+' '+ ALLTRIM (s.SiteSt) as SiteInfo,; i.PayorID,; i.IDType,; i.ProvID,; i.DtEnroll,; FROM ProvIDs i, Providers p, ClientSite s ; where i.FedTaxID=Organization.TaxID ; and i.FedTaxID = p.FedTaxID; and i.DrID = p.DrID; and i.FedTaxID = s.FedTaxID; and i.SiteID = s.SiteID; into cursor GridIDs readwrite I need to get one cursor that will have all the data PLUS ...Show All

• Sqnyy Hiding deleted items on grid

  Hello What I want to do is to hide deleted items in a grid in real time. I have a grid bound to a PRODUCT table. The grid displays all the products I have. I have SET DELETED ON in the Form's Load event In the grid's INIT event I have SET FILTER TO NOT DELETED() and in the DELETE event I have Thisform.grid.Refresh, to refresh the grid every time I delete an item. In a button called "DELETE PRODUCT" I have the following code DELETE So, when I choose a item in the grid, I click the DELETE PRODUCT button and the grid behaves a little weird, 1- The last record in the grid gets deleted not the one I chose. 2- The grid gets refreshed only when I click in another Item inside the grid. I have tried other ap ...Show All

• Stéphane Turcotte updating VFP tables from C# ?

  I am trying to update some of my tables from a C# code. When I use a RecordSet class I get this error: + $exception {"Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype."} System.Exception {System.Runtime.InteropServices.COMException} When I open the connection via a DataSet class and use a DataTable I can update the fields but the changes are never accepted: dt1.AcceptChange() does not work. No error is generated though. In both cases the connection string is the same. I use OLEDB connectivity with VFPOLEDB.1 provider. I could post more code but first want to get some experience from anyone who has done something like this. Many thanks. You ...Show All

• Krutika vfp 6 reports

  I am using report format environment preview. When through terminal services, people are able to click the print icon, but they are not able to print out their report. Do I need to specify local printer I am newer to using FoxPro Thanks, I will try using the getprinter() function before that in my .prg It is enought to have a default printer selected from Start>Printer&faxes and the printer to work fine. You may choose,change and check the default printer from vfp with getprinter() function. ...Show All

• Christian Sparre using tow field index with codebase

  Hi, I'm using codebase to create table and index and i use VFP 9.0 to open the table and execute querys. when i'm creating an index for one feild : "CREATE INDEX ind ON person(age)" every thing works fine and there the index is working well. when i'm creating an index for two fields or more: "CREATE INDEX ind ON person(age,name)" VFP cant open the table. what seems to be the problem thanks ishay there is no problem with the table file ( I can open it and use it ) but only if I'm not using the .CDX file so the problem is probably in the cdx file I had the some problem, but with vfp 7. It seems to be a incompability databa ...Show All

• YeeBoon Excluisve access

  I have a VFP 6.0 application that is used simoultaniously on many computers over a network. Sometimes, when a certain form is opened, it returns a error that says that some component can't be loaded for it is used in exclusive mode by another user. Problem is, I can't figure out what it is that's beeing opened as exclusive. Anyone knows what I should be looking for   CFutino wrote: The problem is my system (and therefore the error) is in protuguese. It translates to something like 'Impossible to perform because other user is using some component exclusivelly'. It does not say which component.   Isso e um problema, ne What seems to be happening is that not everything in your p ...Show All

• Chris Lang 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

• Bhanu Prakash Nunna - MSFT VFP 9 Form wizard - grid problems...

  Hello, I'm attempting to be lazy and whip up a form for data enty. It's a one-to-many form with a parent and child table. I use the Wizard to set it up and when I run it and click on the grid (child table) the data in it disappears. Sometimes, if I tab into the grid from a text box it will work okay...but as soon as I try outside of VFP it disappears regardless of how I get to the grid. I have just recently installed VFP 9, along with SP 1 and am new to this version. Could I be missing some components or something else Help is much appreciated! Thanks Wizards are a way to keep one busy. If you want to be lazy forget wizards. Thanks for the help. I ...Show All

• pjwhams 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 I have managed to sort out the problem. Realised its got to do with the debugger. You may try: SYS(3056,2) it means "SET AS DEFAULT". Thanks. It doesn't work as I am using VFP 8.0 However, I've tried Tools/Options Set As D ...Show All

• IgorB SCATTER/GATHER

  Hou can I "scatter" in a method (valid) and "gather" in other method(click).My vf.7 is forgetting all "m." variables between methods. Thanks, Daniel dni wrote: My opinion is: This is a visual fox limitation. You can declare a variabile as "PUBLIC" in "INIT" and can use it over all scopes, until release it or release form. Scatter/Gather should work in the same mode.(If I am using 10 databases and I am doing 10 "scatter" I will "charge" my form with 10 objects. Actually, SCATTER/GATHER does use existing variables, given the chance. CREATE CURSOR fred (cField1 C(1)) INSERT INTO fred VALUES ("A") INSERT INTO fred VALUES ("B&qu ...Show All

• VRATZ Same Report...Different Printers?

  Hi all, What may be causing the same report file to print differently on different printers We are developing the reports in VFP9 and we make sure that tag and tag2 fields are emptied before compiling the exe. The differences are various like: 1. Difference in left/top margin. 2. Extra blank spaces left out in the middle of the report on certain printers. 3. Shift in borders printed along the edge of the report. The printers in question are HP LaserJet 4000, Brother MFC 3900, ADOBE PDF, Microsoft Fax/Document Image Writer. The latter 2 always leave a very small left margin. All thoughts are appreciated. Bini This is one of the problems with printers. You can have the same report run over two printers and get different results. You c ...Show All

• philcart msxml3.dll error when using XMLTOCUROSR()

  When using the XMLTOCURSOR() function in version 9, I receive the follow message [msxml3.dll : The system cannot locate the specified object ]. Steps taken include uninstalling VFP9 and reinstalling both 7 and 9 and installing the service pack and registering the dll separately. The code works fine in version 7 but not in 9; Test Code lcxmlalias = 'xmlalias' lcfilename = 'c:\indir\pfpcxmlfile2.xml' XMLTOCURSOR ('c:\indir\pfpcxmlfile2.xml',lcXMLAlias,512) Anyone encountered this issue. any ides would be helpful used regserv32.exe to register previously no help, is regserv.exe different from regserv32.exe First of all I'd recommentd to install the lates ...Show All

• jason.t HOW TO ACCESS A TABLE FROM A REMOTE SERVER USING A "USE" COMMAND

  Hello everyone we are trying to access our table directly from a remote server using a command use " ftp://servername.com/foldername/table.dbf " it is giving me the message could not find the file table.dbf so we make the path as use " \\servername.com\foldername\table.dbf " still the same problem can anyone help us how to directly connect a foxpro program with the remote table using ftp. As Alex says, you cannot do this using a FTP site. But there is a way to open a table on a remote server over the internet securely. Use a VPN or virtual private network. A VPN creates a secure "tunnel" through the internet (properly encrypted, et al) using something called Point to Point ...Show All

• netweavernet Tables Relation

  Dear reader, I hope you can help me. I dont know how to relate two dbf free tables files. Table Sub (submenus Items belongs to) ID OWNERID USERNUMBER SHORTNAME LONGNAME EXCEPTIONS ITEM01 ITEM02 ITEM03 ITEM04 1000 0 1000 Entradas Entradas 0 1001 1002 1003 1004 1100 0 1100 Ensaladas Ensaladas 0 1101 1102 1103 1104 1200 0 1200 Sopas Sopas 0 1201 1202 1203 0 1300 0 1300 Cremas Cremas 0 1301 1302 1303 0 1400 0 1400 Ex tico Ex tico 0 1401 1402 1403 1404 1500 0 1500 Aviant\nCuisine Aviant Cuis ...Show All