Search results for query: *

I have seen randomly throught my program on various cases that some will display as though they have a blank record. When you look in the db I don't see the blank record. I create a relationship then do a BROWSE NORMAL NODELETE TITLE "Case List by Patient ID" ; NOAPPEND NOMENU NOEDIT FONT...

I need to delete all the files from a directory and I find that unless I know the entire name, I am unable to delet or erase by using wild card characters. Any thoughts on how I can delete all files containing FTSC in the beginning of their name? Or how to format the A drive would also work...

No I do not have Foxpro installed on the solaris machine. I am running Oracle 10g AS on the Solaris box but need to run a foxpro 2.6a exe from that AS. Somehow I need to do it from within a procedure, is that what you mean by host?

It would need to run from the AS which is a Sun Solaris machine.

I need to be able to run a program developed in Foxpro 2.6a from within a procedure in Oracle 10g. Any thoughts on how to do that?

I am trying to load text that is delimted with ***. I don't fully understand the following items for loader, perhaps if I understood them better I could answer my own question: fields terminated by '***', optionally enclosed by ';' and trailing nullcols. Any suggestions on how I can...

Unfortunately the delimited characters I am using are exacly (*) not just *. I think FoxPro is thinking it is a function. Any thoughts on a work around?

I have a file delimited with (*) I want to import or append the data from the text file into a foxpro database. I see plenty of ways how to do it but they require types I am not using. Any thoughts?

I have changed it to the following: Almost exactly like it examples in help and still nothing. Interesting enough feof(ofile) returns .T. store fopen('cvtoracl.txt') to ofile store fseek(ofile,0,2) to eof && end of file store fseek(ofile,0) to bof && beginning of file gettxt =...

This file has 15559 bytes in but is not showing anything in the gettxt. It has a len of 0. Can you see what I am doing wrong to see what is in the file? if file ('cvtoracl.txt') file = fopen('cvtoracl.txt') endif store fopen('cvtoracl.txt') to ofile store fseek(ofile,0) to bof &&beginning...

Thanks. The help reads: Import Command: Imports data from an external file format to create a new FoxPro table. That sounds like to me that is was creating the table for me. As for your second option, I would like to keep this as independent from the user as possible. Can you do it all...

I have looked over other posts and don't find my answer. I am trying to take a csv file and create a foxpro 2.6a dbf file from it. I tried the following and am getting an error. I don't see what I am missing Command: IMPORT FROM MODE_CD Error: Required clause not present in command. Any...

Sure it would but I commonly have to loop through records and do validation. My exact scenario is this: Data example: MODE START_DATE STOP_DATE aaf 01/01/2004 / / aaf 01/01/2003 12/31/2003 aaf 01/01/2001 12/31/2002 aar 01/01/2004 / / aar...

I always struggle with looping to see when a value changes. Does anyone have a good sample I can copy for future reference? I want to loop through a set of records that are ordered by let's say automobile make. The records are ordered and I want to count how many chevys vs how many fords...

A bit more history... I have program A which is written in FoxPro 2.6a, we are re-developing it in Oracle 10g Using Forms 9.04 The process of events which leads me to the question above is as follows. Program A has a function that creates a FoxPro 2.6a database and it is saved on a floppy...

I am trying to interface with a legacy system. I am currently working with Oracle 10g and need to send a data file from the Oracle 10g database to teh Foxpro 2.6a system. My problem is the Foxpro system is expecting the data file in a Foxpro 2.6a database format. Can I convert the database...

Worked Great! Not sure how I missed it, I tried something similar and no luck. Thanks for your tip.

I want to do a simple statment but it is not working. I am trying to do a "set order to mode, eff_date" for a table that has the following indexes: INDEX ON eff_date TAG eff_date ADDITIVE INDEX ON mode TAG mode ADDITIVE When I do the set order to, it only orders mode not the mode and then...

I have tried to convert my Access 2000 database back to Access 97. It was successful but the size is significantly less. The Access 2000 table before conversion was 20mb and after conversion it was only 4mb. What did I lose? Is that common???

I used your tips and set my size to 1400x1200 and it worked great. It did however, only maximize the whole browser window the first time I ran my form. If I try to run the form a second time it does not maximize. If I close forms and re-open, it will run maximized the first time and from then...