IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
harrymossman
harrymossman
Parent Co: harrymossman
Search harrymossman:

Advanced
-Collapse +Expand More Board Options
MOREINFO...
-Collapse +Expand My Moderator Settings
MODERATOROPTONS

BOARDSTATS
Posts: 16051
Threads: 4728
Topics: 95
Boards: 34
Groups: 34
 
   ► MB Lobby ► This Topic!  Print This     

harrymossman Message Board Activity

  


25 Message Board Posts:


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

harrymossman
Re: Make workload list for each employee
Thanks. The following works:, , method pushButton(var eventInfo Event), var, q1 query, tc1 tcursor, qAssigned string, spreadSheetName string, endVar, , tc1.open("log.DB"), Scan tc1:, , qAssigned= "\"" + tc1."assigned to" + "\"", spreadSheetName = "WorkLoad_" + tc1."assigned to" + ".xls", , Q1 = Query, ANSWER: :PRIV:ANSWER.DB, :LOG:log.db | Date Received | Year | Number |, | Check as recd | Check | Check as Lognum |, :LOG:log.db | Branch | Assigned To |, | Check | ~qAssigned |, :LOG:log.db | Project Name | Date Completed |, | Check | blank |, EndQuery, , If not(executeQBE(Q1)) then, errorShow(), msginfo("Error","Unable to run query"), endIf, , exportSpreadsheet ( ":PRIV:ANSWER.db", spreadSheetName, True ), , endScan, endMethod
Posted to MB Topic: ObjectPAL « Paradox Board
17 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
Make workload list for each employee
{Too Long!}
Posted to MB Topic: ObjectPAL « Paradox Board
17 years ago

harrymossman
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
3115
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
No such interface supported
{Too Long!}
Posted to MB Topic: Paradox Forms « Paradox Board
17 years ago

Tony.M80
Duplicate., , Can someone please delete?, , The system gave a 'flood' message, made me wait, then posted the same thing twice., , And now says, basically, that I can't delete.
17 years ago
Nothing New Since Your Last Visit
2890
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
Paradox fun
A while back I was thinking about the old Paradox icons - pair of ducks, pair of docks. For fun, I tacked 2 ducks and 2 docks outside my cube. (We are currently working on having more fun at work. It was management's idea, really.), , So people started putting up more Paradox pictures. I was surprised how many., , Pair of doctors, Pair of Dockers, Pair of Doc Martins, Pair of dachshunds, Pair of dogs with docked tails, Pair of Dax (StarTrek), Pair of dorks (nerds), Pair of (card) decks, Richard Nixon + Dick Tracy, Pair of (air conditioning) ducts, Parrot + ox, Parrot + auks, Parade + ox, Pear + ox, Pare doc's (paper cutter), Amazon.com + Yahoo.com or .., Cross between great Pyrenees & dachshund (a puzzling breed)
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
20 years ago

mprestwood
How fun. How many Paradox programmers are at your work? Or, are others just participating.
18 years ago
Nothing New Since Your Last Visit
1540
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
timesheet form
We need to create a timesheet. It needs to be like ones used by lawyers etc. who break their time down by case., , We have a table of employee names and a table of cases. What stumps me is how to create a form that an employee could use to fill in their weekly times. And also a form where the supervisor could review weekly and summary totals by employee and by case. (Of course, this could be 2 separate forms.), , The employee form would be something like:, , Employee 1, Week of 8/10/2003, , MON TUES WED THUR FRI, CASE1 2.5 3.75 4.0, CASE2, ETC.All of this data would go into one big table. Should I put that table on the form and filter it? Or use an undefined tableframe and then upload to the main table? Or something else?, , This must be a common task but Search didn't produce any results for "timesheet.", , Harry
Posted to MB Topic: ObjectPAL « Paradox Board
19 years ago

harrymossman
[QUOTE], My wife has a timesheet in Paradox she wrote in 1996, if you'd like it to use as a skeleton., [/QUOTE]Thanks. I may. It occured to me that I don't really have to make it look like a timesheet. I can just have fields for data entry, with a crosstabs to give an overview.
19 years ago
Nothing New Since Your Last Visit
2072
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
Re: timesheet form
[QUOTE], My wife has a timesheet in Paradox she wrote in 1996, if you'd like it to use as a skeleton., [/QUOTE]Thanks. I may. It occured to me that I don't really have to make it look like a timesheet. I can just have fields for data entry, with a crosstabs to give an overview.
Posted to MB Topic: ObjectPAL « Paradox Board
19 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
SetGenFilter
We have a form with a tableframe on it. People scroll or search through the tableframe until they come to the project they are looking for. Then, in a separate tableframe, they enter data., , I would like to filter the first table on the basis of one of two key fields - Year. Bad choice of field name, made long before I arrived. It is actually in the form YR-X, where YR is a 2-digit fiscal year and X is project type., , I want to show only projects that match YR-F. I.e., year doesn't matter, only project type. The records are not contiguous, so can't use SetRange., , Should I somehow use an array to get only the project type? Not sure where to begin. I'm open to completely different solutions, however this seems like the format that people doing the data entry can handle., , Harry
Posted to MB Topic: ObjectPAL « Paradox Board
19 years ago

harrymossman
{Too Long!}
19 years ago
Nothing New Since Your Last Visit
2084
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
Re: SetGenFilter
Thanks Rick. Redesigning the database is only in the talk stages and this is a govt agency. Roll Eyes So, it's probably years away. The reason we might use Delphi is that we have an experienced programmer here. We also might get something else imposed on us from above., , Adding two fields to the table really isn't an option. Filtering this tableframe is in the "wish list" category, not a critical need. So if there's a quick fix, great, if not, oh well.
Posted to MB Topic: ObjectPAL « Paradox Board
19 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
Re: One for the technocrats
Clearly a job for Harry Potter. Boxed In , , Another Harry
Posted to MB Topic: Just Conversation « PrestwoodBoards Board
19 years ago
Nothing New Since Your Last Visit
2
Hits

PrestwoodBoards

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

harrymossman
Re: breakapart?
"That, or Paradox is *amazingly* casting the second array element as a number or int.", , It's a paradox., , Not thinking today. Thanks
Posted to MB Topic: ObjectPAL « Paradox Board
19 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
breakapart?
I have a button people can use to determine the next file number to use. Numbers are like MB-006., , (I didn't create this database! I would have used an autonumbering system.) Right now, the button brings up an array view of the last number in use., , The ideal would be to break apart the last number, add 1, and display it to the user., , My experience with arrays is minimal. Maybe there is a better way to do the whole process. Any ideas?, , Harry, , method pushButton(var eventInfo Event), var, q query, tc tCursor, ar array[] anyType, endVar, , q = Query, ANSWER: :WORK:get_last_MB_no.db, cb-bank.DB | MB File No | , | calc max as last | , EndQuery, , executeQBE(q), , , tc.open("get_last_MB_no.db"), tc.locate("last"), tc.copyToArray(ar), ar.view(), , endMethod
Posted to MB Topic: ObjectPAL « Paradox Board
19 years ago

harrymossman
"That, or Paradox is *amazingly* casting the second array element as a number or int.", , It's a paradox., , Not thinking today. Thanks
19 years ago
Nothing New Since Your Last Visit
1886
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
Re: Table Frame
Do you know about the object explorer? Tools|Object Explorer - or right click on the table frame (or form). You can then click on objects in the explorer and they will be selected on the form., , Harry
Posted to MB Topic: Paradox Forms « Paradox Board
19 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

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

emmonsc
Table Frame
I have a report with a table frame that has a mind of its own. The last column in my table frame is trying to be about 5 times longer than necessary and therefore does not fit on the report. The field contained in this column is a calculated one. In the report, it shows as thought the table is chopped off. Please tell me why the last field tries to be longer than I want? I understand the problem is my ignorance, but I can't figure out what my problem relates to. Thanks for any help. I am not referring to a data table but a report table frame to be clear.
Posted to MB Topic: Paradox Forms « Paradox Board
19 years ago

harrymossman
Do you know about the object explorer? Tools|Object Explorer - or right click on the table frame (or form). You can then click on objects in the explorer and they will be selected on the form., , Harry
19 years ago
Nothing New Since Your Last Visit
2344
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
Re: Livin' This place up
What is this field? How does it become negative? Is it calculated? Entered directly via data entry? Imported? Updated by a program?, , Harry
Posted to MB Topic: ObjectPAL « Paradox Board
19 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
Microsoft buys Paradox
April Fools! Big Grin!
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
19 years ago
Nothing New Since Your Last Visit
1520
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
Re: create report with varying number of fields
{Too Long!}
Posted to MB Topic: ObjectPAL « Paradox Board
19 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

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

harrymossman
create report with varying number of fields
I have a "queries for dummies" form that allows Paradox-illiterate users to build queries by entering a key word, pushing buttons, and clicking boxes to limit what fields appear in the result table. This all works well., , I can't create a report for every possible set of selections. That would be hundreds of reports., , I'd like to do something like the quick report button, only with the report style specified. (If the user clicks all of the fields, the result is too wide to display as a table. So a single or multi-record layout would be best.), , A form with the table on it would be fine too. Maybe better. It would automatically be in a single-record format., , Can someone push me in the right direction? I know I can use create() and run() to make a form. Not sure how to get the table-frame (and maybe other objects like a close button) on it. Or is there another approach?, , Harry Coffee!!!!!
Posted to MB Topic: ObjectPAL « Paradox Board
19 years ago

harrymossman
{Too Long!}
19 years ago
Nothing New Since Your Last Visit
2850
Hits

Corel Paradox / ObjectPAL Coding
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2022 Prestwood IT Solutions.   [Security & Privacy]