-
- 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!