I.T. Discussion Community!
marcus welby
-Collapse +Expand
Not a client.
Authorize New Devices Directive:
-Collapse +Expand
-Collapse +Expand Profile◄╣
      Print This  
Personal Account . . .
-- 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 (9 years ago)
Visits: 10
Member Points16
Primary Role:  Coder
Location:  -- USA

Message Boards Activity

2 posts.

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

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
12 months ago
Nothing New Since Your Last Visit

Corel Paradox / ObjectPAL Coding

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

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
54 months ago
Nothing New Since Your Last Visit

Corel Paradox / ObjectPAL Coding
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com

736 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-2016 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech