RE: [RBASE-L] - RE: PROJECT Puzzle

2017-06-29 Thread Claudine Robbins
Razzak, Very interesting... Indeed I knew nothing of this. Review of all code, some written--should I more accurately say slapped together--in DOS days, shows how willy-nilly my naming conventions were. I'm currently--may take a long time, I'm so slow these days--closely reviewing all aspect

Re: [RBASE-L] - RE: PROJECT Puzzle

2017-06-29 Thread A. Razzak Memon
Claudine, Using R:BASE X and R:BASE X Enterprise (Version 10) ... Did you know that you can define a table of all controlled column names and data types, that will be enforced when using those columns in a VIEW? By default when an alias column name is used in a view, R:BASE makes the best g

RE: [RBASE-L] - Loading hh:mm:ss durations for computation (not the Time of Day)

2017-06-29 Thread Dan Goldberg
Usually in databases durations is stored as an integer if the minimum to store is seconds. Easy to calculate anything from there. If you need to store partial seconds then use a real. Dan Goldberg From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Stephen Markson Sen

RE: [RBASE-L] - Loading hh:mm:ss durations for computation (not the Time of Day)

2017-06-29 Thread Stephen Markson
Hi, You can get the duration by subtracting midnight from the imported times. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of lwilson Sent: June-28-17 10:28 PM To: RBASE-L Cc: raz..

RE: [RBASE-L] - suppressing blank pages on sub reports

2017-06-29 Thread Dan Goldberg
Thx I will give it a go! Dan -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Wednesday, June 28, 2017 9:01 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - suppressing blank pages on sub reports Dan, Here's