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

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

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?

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

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

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

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

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 want to extract text from a field up to a comma and then extract what is left. Any suggestions? Data sample From this format into this............. Field1 Field 1 Field 2 Jones, Dave Jones Dave Peterson, Julia...

I am having difficulties running this query. Can you see my problem? INSERT INTO tblFootExam (PatientID, DateTested, FootExamTypeID, FootExamResultID, ActiveProblem) SELECT tblPatients.PatientID, CDMS_MPF_DATE_OF_SERVICE.DATE_OF_SERVICE, 2 AS ExamTypeID...

I have a screen which has a button that pops up a second screen for entry. In the second screen you enter dates, names and check some checkboxes and then press save. Save returns to the previous calling function and continutes to process in the original screen. My problem is that in the...

Is it possible to do a modify memo with out a record being created. My problem is I have a screen in which I am entering a new record. I need to add comments while I am doing initial entry and it occurs before I save the entire record into the database. I have tried the modify memo and it...

I have a unique problem and am unable to find a fix. I have found that I have a table that has a cdx associated with it that seems to be corrupt. When I try to set the order on the table, it is appearing to be a bad index. I see this because I am doing an set order to name and the index is...

I am manually formatting inside a memo field. Prior to inserting into the memo, I create a string of data to insert. The string is manually formatted. Below is an example: m.svngs = m.svngs+padr(rpt.pat_id,15,' ')+chr(9)+chr(9)+padr(rpt.name,40,' ')+chr(9)+chr(9)+padr(rpt.critsel,50,'...

How can I find out what the 0-255 character codes are for the CHR() function. I am trying to build a make-shift multiple detail line report by reporting the data to a memo field with formatting. I want each record to be on it's own line. So I am looking for a carriage return. I want the memo...

I am wanting to print one report but display the contents of two tables. Each table can vary in it's row count. So let's say table one has 12 rows and table two has 22 rows. But next time table one may have 40 rows and table two may only have 9 rows. How can I do this. Along with that I...

I am using FoxPro 2.6a for Windows and have used the command: copy to array arpt I now want to print a report using the following elements from the array: arpt(2,10) arpt(2,11) etc. I am finding problems when I build. I get an error stating "unable to find unknown arpt". If I...