Recent content by acorbally

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