Answer Questions

• Payal Kapoor Old Fox Pro Code Please Help

  I have the following code from an older version of Fox Pro.  I typed it into VFP 8 and I can't get it to work. Does anyone have any suggestions SET BELL OFF SET TALK OFF SET DEVICE TO SCREEN CLEAR ****** NUM1 = "   " NUM2 = "   " NUM3 = "   " NUM4 = "   " NUM5 = "   " NUM6 = "   " @ 10, 5 SAY "ENTER LOTTERY NUMBERS" @ 10, 50 SAY NUM1 PICTURE "XXX" @ 10, 50 GET NUM1 PICTURE "XXX" @ ...Show All

• Fulano editbox programmatic change

  I am looking for an easy way to determine if I've made interactive change in an editor box. The issue is that there are about 16 controls on a container, they are initialized from a table record thus their values at activate time generally are not trivial default. I have to save the changes with a SAVE button if I made any but I want this button's click method to quickly determine which control values have been changed. I do not want to do REPLA ...Show All

• Part Time Australian Help: I want my Grid to act like Excel

  Help me, I would like my Grid to act like Excel where it should move downward after entering data from the field not to the right. Foxpro enters by record but I would like it to act like the way Excel does. Because my would be users would enter it by batch and it would be faster entering data by column not by record. Hope you could help me with these. Thanks Well it doesn't lack for me.    ...Show All

• Ramniklal25 EDSETENV

  I want to set up runtime environment as far as the way memo fields are displayed in the editor. I tried to use the code I found in Help: SET LIBRARY TO EDSETENV = EDSETENV("x") First, there is no library file by this name, at least I could not find it. Second, the whole thing is not recognizable by the compiler. How do I define string "x " Do I have to write a C++ module to do it But my first concern is to make the f ...Show All

• dmj1 Index does not match the table. Delete the index file and re-create the index (Error 114)

  How do I recreate an index file for a table after the table has been recovered   Thanks! There are a couple of options.. REINDEX is the easiest, but if the key information stored in the CDX is corrupt, it will create corrupt indeces. The best way is to DELETE TAG <tag>, then do an INDEX ON <key> TAG <tag>. However, if you are using persistent relations, they will be removed with ...Show All

• Dragomir MSDE Connection problem

  Hi guys! ^_^ i am trying to connect to MSDE database using vb6 to another computer but i always received this error: [DBNETLIB][ConnectionOpen(Connect().] SQL Server does not exist or access denied. i've use the ff: connection string to connect: con.connectionstring = "Provider=SQLOLEDB; Data ource=110.20.50.99;Trusted_Connection=YES" con.open unfortunately it doesnt work. BTW i have test it in xp os and win2k os but i recei ...Show All

• extraT cannot generate an exec file

  I just finished a large project and tried to generate an .exe file from it. I encountered the following problems. BUILD EXE FROM ..... issued from the Command Window gives me a series of errors. The first one is entirely unexpected. It claims that a file "inpARR" could not be found. When I click on "locate' it offers me a file dialog box to find it. I definitely do not have any reference to a file by this name anywhere in my pr ...Show All

• Robert Franks Line Printer Font (16.66cpi)

  I have a lot of old DOS reports I am converting to Visual FoxPro. Most of them are using the "Line Printer" font with 16.66cpi. If I continue to use the "Line Printer" font in Windows the reports will print fine to the printer but will not print to the screen properly. I believe this is because the "Line Printer" font is not a TrueType font, but I can not find a true 16.66cpi TrueType font. Does anyone know how I ca ...Show All

• vbvan sys(2015) Conversion back to System Date Time

  I'm working on a project to do some analysis, and difference between versions of ClassLibraries (VCX/VCT), Screens (SCX/SCT), Projects (PJX/PJT), Etc... I'm looking at the Uniqueid field which is a sys(2015) type of value, which is based on a given system date time.  I've seen an article that explains how to reverse the value back to the date time, but I just can't find it anymore. Can anyone help me with a sample of what I need for this co ...Show All

• Frederic Goulet RICHTEXT.RichtextCtrl

  Hi Guys Please point me in the right direction.... I retrieve RTF from SQL via ADO into Excel. I need to strip the RTF, within VBA, to show only the text, before pushing it to excel. Would the following be the right way: Dim objRTF As Object Set objRTF = CreateObject("RICHTEXT.RichtextCtrl") And where do I go to from here Please, please, please HELP!!! This RTF is killing me!!!! Hi Ce ...Show All

• kaffeeschluerfer Deleted records still getting fetched

  ok so I have deleted records in a VFP 6.0 table, and when I query anything the deleted rows still get pulled up, what am I doing wrong yes that worked, thanks very much! hmm, I get a syntax error when I do "SET DELETED = ON". That's because the actual syntax does not use a "=" ( I was saying that the return value of the function& ...Show All

• Aussie_Bluey FoxPro character fields in .Net showing as blank strings.

  Not sure if this should be in the FoxPro forum, or the C# forum. I have a dBase database, with a table (table1). table1 contains a field (myField) which is a fixed length, 4-character field. With each record this field contains 4 ASCII characters (which were created by converting decimal values into ASCII). Now ... I think that the first 2 or 3 characters are ASCII value 0 (null). Also, some of them contain Extended ASCII codes. My problem ...Show All

• Oberon huella digital

  como le puedo hacer para integrar un lector de huella digital a mi aplicacion, el lector es digitalpersona(marca), requiero hacer una base de datos de las mismas y poder consultarlas Please keep posts on this site English only . It's in your own interest, because more people will be able to help you. si trae manual, pero solo es la instalacion personal o sea en la misma computadora y requiero de hacer una base de datos con las huell ...Show All

• Marcus Ogden How using barcode in VFP?

  Hi! Help me use barcode in VFP use ActiveX controls Where download it Thanks! Hi, This is true, but most of us don't like the tedious task of hitting the 'enter' key. Is there a way to scan a product and have it come up without further user input required Steve   Hi, The barcode scanner returns a series of integers following an enterkey. So, you can do t ...Show All

• Lagear cannot open up a form-- BIG TROUBLE

  I have been working on this form for about two months adding new objects and manipulating databases. The last save I did was about 4 days ago. I have a few grids in it on different pages of pageframe and everything worked fine. I never added any columns to any grid at design time. At runtime VFP determines the column layout after a grid is given an alias as a record source. Today, just a few minutes ago I decided to add three columns to a ...Show All