Visual FoxPro

Page 106




  • Topics
    Replies
    Last post
  • do form and wait
    by VFPNewbie
    6 Replies
    Last post by AndyKr
      • I have a program that scans through a table and when it hits a condition will call a form. The problem is that it runs the form and then continues scanning when I need it to wait for the user to complete the form before moving on. I'm calling it with the DO FORM method and can't find anything on it, please help.
  • Copy to delimited
    by BigFoz
    4 Replies
    Last post by BigFoz
      • Hi, I need to be able to create a standard ASCII file delimited with tabs. However the default for the command: COPY TO file .txt DELIMITED WITH TAB produces the character " wrapped around all fields. Does anyone know a way of producing a standard tab delimited file without the " characters Cheers, Paul.
  • Upgrading to Foxpro 9 SP2 causes Interop errors
    by Atish R Chandra
    10 Replies
    Last post by Atish R Chandra
      • I've been working on some custom software which uses a multi-threaded COM server which is called through VB.net. Before upgrading to SP2 I have had no issues, however now that I have upgraded my system to SP2 I can't get the VB.net code to create the foxpro COM object correctly. I keep getting the following error System.Runtime.InteropServices.COMException 0x80010105 I haven't been able to isolate
  • Memo file is missing or invalid
    by Selim Yucel
    6 Replies
    Last post by Mark Milan
      • Hello, I have a DBF file an I need to open it. I have VFP9.0 and when I try to open it I get a message suc as: "Memo file C:\....\myfile.fpt is missing or is invalid." Is there a way to open this file I will deeply appreciate advices or ideas.. Thanks.
  • Microsoft Visual FoxPro
    by tqlashot_kk
    5 Replies
    Last post by Claude Fox
      • Hi all, Can anyone tell me if i can use the above on sql server standard 2005 edition...im building a window application (.exe), a costing system for our account dept here... I've done lots of research on which languages to use, but i find foxpro match my description as it is more to client-server solution...any opinions / ideas would be really great. really appreciate the hel
  • Export a Fixed Length ASCII text format file
    by WinnieX45
    3 Replies
    Last post by WinnieX45
      • Does anyone know how to export a DBF file in 'fixed length ASCII text format' using FoxPro The exported file must be in the standard layout with 454 bytes of data. I can modify the structure of the file in FoxPro to comply with all the positions/ length spects for each field, however, does FoxPro even allow users to output the file in a fixed length format If anyone does kn
  • Best way to assign default value to combo
    by Aleniko29139
    5 Replies
    Last post by CetinBasoz
      • Hi all; Back to the stupid simple questions: What's the best way to make one of the items in a combo show as default, and make the coltrol source affected accordingly Currently I assign this.value in the init and also assign a value to what the control source is. I have a hunch there's a better way. Thanks.
  • Locking VFP rows from C#
    by 5p1d3r
    11 Replies
    Last post by Naomi Nosonovsky
      • We are wanting to create new records in a FoxPro database from c#. The database in question does not have autoinc, but has a 'sequence' table instead. The 'sequence' table has two columns 'file' and 'next_val'. To get the next primary key for the CUST table, simply: SELECT next_val FROM sequence WHERE file = 'CUST'; UPDATE sequence SET next_val = next_val + 1 WHERE file =
  • Locate Command
    by Ahsan Amin
    2 Replies
    Last post by CetinBasoz
      • In have 2 tables in my form data envoirnment. Courses Subjects ------------ ------------- CourseID SubjectID CourseName SubjectName SubjectID i am trying to LOCATE FOR a_Subjects.SubID = a_Courses.Sub1. I checked in debuger window by pointing red dot on this line that a_Subjects.SubID value is 32 and a_Course
  • Copying a numeric value with decimals from a cursor into excel without rounding up
    by mrfitness
    14 Replies
    Last post by Naomi Nosonovsky
      • I am having trouble with copying numeric values with decimal places into excel. I have a select statement (some being sums of numeric fields with 2 decimal places) with a group by function and I place these results in cursor c1. When it tries to enter this value into excel, it rounds all values up. (eg 309.66 becomes 310) I tried changing the format of the excel file to numeric with 2 decimal plac
  • Help With Earlier Verison of FoxPro
    by DJL2000
    8 Replies
    Last post by Alex Feldstein
      • I had a application builted for me in 2002-2003 timeframe. I believe I have the source code but I cannot view it. The file types I have are - DBF, CDX, FPT, FRT, FRX, PJT, PJX, PRG, SCX, and SCT. Is there a environment that still is avialable that I can use to see the code so that I can port it over to a more modern IDE Any assistance is appreciated. Thanks
  • importing from excel
    by JonathanVickers
    11 Replies
    Last post by Naomi Nosonovsky
      • Hi, I'm struggling to import from an excel spreadsheet into foxpro. The problem is there's a "remarks" column in the xls which may contain more than 255 characters, so I want to import that column as a memo field. I've tried using APPEND FROM, but that's just putting nulls in the field. I've also tried IMPORT, but that just gives me a character field. I've tried setting up an ODBC connec
  • mysql
    by markk1979
    3 Replies
    Last post by AndyKr
      • Can anyone give me advice on setting up mysql. I have windows vista and I have 2 problems. I can't seem to open the right ports, even though Im doing the right thing ( I think ). I cant get it running properly. My password doesn't work. I used a php interface to create one database. However I couldn't acess mysql direct and connecting it with coldfusion is something I am not familiar with. Please
  • Primary Key Set up
    by AlexBB
    10 Replies
    Last post by AlexBB
      • I have a very pessimistic view on the FoxPro prospects in Vista. Nothing is working and it does not seem to make any sense even trying to fix it. Just too many things are screwed up. So I've decided to use my VFPOLEDB databases, write completely new C# ADO .NET code for handling all operations that before in XP were done by FoxPro Code. In order to do it I have to set up primary keys on my tables.
  • CursorAdapters and UDF in FoxPro 9
    by IvanVC
    9 Replies
    Last post by IvanVC
      • Hi, I like to know if is possible to create a Cursoradapter (ADO) with a select CMD using a function. For example if I have a function concat(par1,par2) that returns par1+par2. I like to use as select command something like select concat(lastname,firstname) as name from personal Thanks Ivan
  • Textbox value does not seem to change
    by Hans L
    13 Replies
    Last post by Naomi Nosonovsky
      • I am in a form which shows, i.a., an address and a billing address (in textboxes; record A). I skip down a few records (to record F), and the "skip" buttons (Previous, Next) have ThisForm.Refresh in them. So I figured that the textbox Value property would be updated. And the address textbox surely shows the correct address from record F. But, when I click on a checkbox that moves the add
  • change name in kit
    by drvsrs
    2 Replies
    Last post by RAJA RAM LUNA
      • *=====================================  In the following module Item code entered in the "Datafile"  is checked with codes in stock master in the order of codes. The code exists in the Stock master, and the Return 1 is effective. But the cursor is not moving to enter the next  Name field.   *========================== SELE 1 USE STKMAST ORDE CODE SELE 2 DATAFILE *----
  • search with option
    by NILKAMAL
    14 Replies
    Last post by NILKAMAL
      • hi! can some one help me for this i want to creat search form as below 1) option button - fielda 2) option button- fieldb 3) option button - field c here is i place one textbox for user can put value and search button to search and if record found then go to my my form with this value thanks
  • Printing is causing computer reboot!
    by Richard1_1970
    11 Replies
    Last post by Vladimir Zografski
      • Lately I have had many of my customers reporting to me that when ever they try to print using my software written in VFP 9 it is causing there computers to reboot. One thing in common with everyone is they all have different types HP LaserJet printers! Can anybody help me with this Here is the code I am using for printing.... loListener = .NULL. do (_reportoutput) WITH 3, loListener loL
  • Create Foreign Key Index programmatically
    by Gary Demi
    6 Replies
    Last post by Gary Demi
      • I am trying to add an index expression to a table from a program. I Create the table/database with CREATE DATABASE d1 CREATE TABLE t1 (field1 c(10), field2 c(10)) Then I try to add indices ALTER TABLE T1 ADD FOREIGN KEY Field2 TAG f2idx (I get syntax error) yet ALTER TABLE T1 ADD PRIMARY KEY Field1 TAG f1idx (works ok) I can also use MODIFY STRUCTURE to create a regular index on field2 All the doc
  • LITTLE DOUBTS WITH DATE & TIME PICKER .....
    by Paramu
    4 Replies
    Last post by Paramu
      • Hi There, Thanks in Advance. Iam facing little error....Really I don't know the exact mistake...where I did... Iam getting the error like... OLE IDispatch exception code 0 from DTPicker: Invalid property value... ************************************************************* My requirement is to set the Todays-Date for DT-Picker..... My codings in the
  • How to use the session object.
    by Aleniko
    9 Replies
    Last post by Naomi Nosonovsky
      • Hi; I'm calling an older foxpro prg from a VFP9 form. The prg has a bunch of use commands which will inhterfere with the form, so I'd like to make sure I'm restoring the form's environment when I return from the prg. - I'm not sure if I should use the session object for this purpose I've tried to test this but I'm doing something wrong. I'm opening a different table and then calling this, but aft
  • fast / draft mode printing in vfp
    by RavindraPatil
    14 Replies
    Last post by CetinBasoz
      • Dear friends, can we print in draft mode as in DOS by using vfp report writer -Ravi
  • How can I make a Singleton (i.e. can create only a Single Instance at a time) application in VFP 6.0 ?
    by nrpanda
    7 Replies
    Last post by nrpanda
      • Hi, How can I make a Singleton application in VFP 6.0. A Singleton application means only one instance can be created at a time of an .exe from its source folder. I have tried to make it through checking the flag value stored in dbf field. If True, then exe is running, else not. It is working fine. But when I am running the myapp.exe file second time, it is flashing its background scr
  • What comand to clear content of General field?
    by AnnyJacky
    6 Replies
    Last post by CetinBasoz
      • - What comand to clear content of General field Now I only use menu Edit/Clear to clear content of General. I want use commad in program to clear it. - Why when cleaned content genefield but size of file .FPT too large ! Thanks!