I.T. Discussion Community!
marcus welby
-Collapse +Expand
Terms:
Not a client.
-Collapse +Expand
csgPdx
-Collapse +Expand Profile◄╣
      Print This  
Personal Account . . .
csgPdx
-- USA
Rank: Cadet 2nd Year
Send New Private Message Send Message   Add ContactAdd To Friend List Block Member Block Member
Real Name:  marcus welby
Joined: Sep 2007 (8 years ago)
Visits: 6
Member Points14
Primary Role:  Coder
Location:  -- USA

Highlights

Posted within the last 90 days.
New?   Title Created By For...
Nothing New Since Your Last Visit
9
Hits
1. creating flat file from a normalized table w/ QBE
Some years ago I saw a query of a single normaiized table that gave a flat file answer table. Presently, I have file that tracks payments and adjustments to outstanding receivables. A single claim may have many payments (either from insurance companies or patients) and/or adjustments (from contract write-offs to collection write-off). I am needing to show for each claim, in a single row, amounts for each type of payment and adjustments. Of course, I can produce this result in a series of queries. And fortunately, there is a relatively small number of payment and adjustment categories, so this is entirely doable. However, I am interested in the technique, as such, that used a "self-join." I've had no success in searching on the internet, in part, perhaps, because I am not even using the right terminology. Thanks, NK
Posted to MB Topic: QBE & SQL  « Paradox Board
73 hours ago

csgPdx

Updated 90 Day Posts: All Types

Updated within last 90 days and not in the new 90 day posts list above.
New?   Title Created By For...
Nothing New Since Your Last Visit
9
Hits
1. creating flat file from a normalized table w/ QBE
Some years ago I saw a query of a single normaiized table that gave a flat file answer table. Presently, I have file that tracks payments and adjustments to outstanding receivables. A single claim may have many payments (either from insurance companies or patients) and/or adjustments (from contract write-offs to collection write-off). I am needing to show for each claim, in a single row, amounts for each type of payment and adjustments. Of course, I can produce this result in a series of queries. And fortunately, there is a relatively small number of payment and adjustment categories, so this is entirely doable. However, I am interested in the technique, as such, that used a "self-join." I've had no success in searching on the internet, in part, perhaps, because I am not even using the right terminology. Thanks, NK
Posted to MB Topic: QBE & SQL  « Paradox Board
73 hours ago

csgPdx

Message Boards Activity

2 posts.
More...

Thread 2 of 2
Thread Starter or a Reply (but not last)  Group

csgPdx
creating flat file from a normalized table w/ QBE
Some years ago I saw a query of a single normaiized table that gave a flat file answer table. Presently, I have file that tracks payments and adjustments to outstanding receivables. A single claim may have many payments (either from insurance companies or patients) and/or adjustments (from contract write-offs to collection write-off). I am needing to show for each claim, in a single row, amounts for each type of payment and adjustments. Of course, I can produce this result in a series of queries. And fortunately, there is a relatively small number of payment and adjustment categories, so this is entirely doable. However, I am interested in the technique, as such, that used a "self-join." I've had no success in searching on the internet, in part, perhaps, because I am not even using the right terminology. Thanks, NK
Posted to MB Topic: QBE & SQL « Paradox Board
73 hours ago
Nothing New Since Your Last Visit
9
Hits

Corel Paradox / ObjectPAL Coding

Thread 1 of 2
Thread Starter or a Reply (but not last)  Group

csgPdx
Paradox 10 on Windows 7
I seems to have successfully loaded Paradox 10 (from WPO 2002). However, I am having problems in the data model. 1.) The table lables are not entirely readable 2.) Linking tables is doable, except that te screen gets "smudgy." If I drag the DM window down and back up, the image is clear. Loading the windows help program from MS did not work, but I haven't given this much energy and am not sure that I was doing it properly.
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
42 months ago
Nothing New Since Your Last Visit
1270
Hits

Corel Paradox / ObjectPAL Coding
-
  Load Time=less than 1 second.
 
Print This


-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


702 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...
Follow PrestwoodBoards on: 


©1995-2015 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech