Search results for query: *

I Have a table with the following fields: (in PIPE delimited test) EPIC |NDC |Brand |Generic |Price |FIELD006 3697646|378061401| | | |Tot $: 5.52 3697646|378061401| | | |Tot Vol: 1 3697646|378061401| | |Curr $: 5.52|...

Worked very well ("instantly")-thanks

I am importing an Excel spreadsheet (from ASCII) where every "record" incorporates 5 lines. This results in a table where there is a 1 lines with a desciption including an item number followed by 5 line where that field is empty. Where table is open, I "shift-control-z" (find and...

I am running this query: Query ANSWER: :PRIV:ANSWER.DB T_Data_0507_ASC.DB | ID | Station | | CALC COUNT | Check CALC OPEN as PHARMACY HOURS | | CALC COUNT | Check CALC CLOSED as PHARMACY HOURS | |...

I am tracking workload statistics. I receive an ascii file with a timestamp date. I want to parse the days of week from this information, and count the number of transactions per day of week (Sunday, Monday, etc.).

Is there a way to write a query so create a calc field with the day of day, based in Julian dates. I can set P7 to display windows long-date ("Monday, November 21, 2005"), but QBE won't allow "Monday.." Or is there a better way?

Greetings I have a project where I import large ASCII files with many fields, 1 of which is an account number. The application which generates the ASCII file allows some duplicate named records with the same acct number, replacing the last charactor with a letter based on the its value (A=0...

I realize that too, but it's FYI info not discussed originally

I am querying a rather large DB file with a series of queries, the first 2 of which have "calc count" fields. It runs very long (210 seconds). The query is coded as follows: Query ANSWER: :work:withdawn.DB pyx6002.DB | Station | PaType | GenMedName | Amt | Month | Index |...

I have found that saved PdoxDos queries ("*.sc") file can be recycled into Paradox for windows queries by changing the extension from "sc" to "qbe". This only applies to the saved queries, NOT scripts, and also assumes that the other conditions for the query still...

The code display the information in an array (works well), but I need to apply the change (viz. restructure table to eliminate blank fields). How do I do it, either the restructure or printing the array contents?

I have been importing a text file which yields a table with 64 fields. Many of these fields are blank, and I can change the source generator to eliminate these fields, but I need to find which fields are absolutely blank so that I can redo the source material & restructure the resulting table...

I am managing a project where have to find out the number of occurances of an activity during our non-business hours. I am using imported text where one field list the times of occurences in 24hr time. The range is 00:00:01 to 23:59:59. The operational hours are 07:00 to 18:00. I can query all...