Ask Your Question

Joe Castor's profile - activity

2019-06-14 01:36:58 +0100 received badge  Famous Question (source)
2019-06-14 01:35:58 +0100 received badge  Famous Question (source)
2019-06-14 01:34:55 +0100 received badge  Famous Question (source)
2019-06-14 01:30:44 +0100 received badge  Notable Question (source)
2019-06-14 01:29:45 +0100 received badge  Famous Question (source)
2019-03-29 16:47:00 +0100 received badge  Famous Question (source)
2018-12-31 18:54:51 +0100 received badge  Famous Question (source)
2018-07-30 09:43:16 +0100 received badge  Famous Question (source)
2018-07-29 17:05:30 +0100 received badge  Popular Question (source)
2018-07-29 16:36:36 +0100 received badge  Notable Question (source)
2018-07-27 04:53:21 +0100 marked best answer Split DB setup instructions

It appears that the best way to continue to develop and update an active DB (1 or 2 users, a separate developer) is with a split DB. Can you please direct me to some literature/manual that explains how it works and how to set it up? Thank you in advance, Joe

2018-07-09 08:14:36 +0100 received badge  Famous Question (source)
2018-06-26 12:57:53 +0100 received badge  Famous Question (source)
2018-06-05 19:32:13 +0100 received badge  Famous Question (source)
2018-05-26 01:37:56 +0100 received badge  Famous Question (source)
2018-03-19 21:26:19 +0100 received badge  Notable Question (source)
2018-03-19 21:24:32 +0100 received badge  Famous Question (source)
2018-03-19 21:24:32 +0100 received badge  Notable Question (source)
2018-03-19 21:19:17 +0100 received badge  Popular Question (source)
2018-03-19 21:16:01 +0100 received badge  Famous Question (source)
2018-03-15 01:15:40 +0100 received badge  Popular Question (source)
2018-03-15 00:33:52 +0100 commented answer Query, add 30 days to date, then compare

Thanks so much. Yes, a split DB. I read in the Query manual that there was no DATEADD function. It obviously refers to t

2018-03-14 20:43:32 +0100 asked a question Query, add 30 days to date, then compare

Query, add 30 days to date, then compare The goal is to test two date, reporting when the first date + 30 days is greate

2018-03-09 14:06:22 +0100 received badge  Famous Question (source)
2018-03-01 15:30:59 +0100 received badge  Notable Question (source)
2018-02-21 13:17:22 +0100 received badge  Famous Question (source)
2018-01-10 02:40:40 +0100 received badge  Famous Question (source)
2018-01-07 12:53:31 +0100 received badge  Famous Question (source)
2017-12-28 12:36:18 +0100 received badge  Famous Question (source)
2017-12-13 13:28:57 +0100 received badge  Notable Question (source)
2017-12-13 13:28:57 +0100 received badge  Popular Question (source)
2017-12-12 16:52:35 +0100 received badge  Notable Question (source)
2017-12-03 16:49:19 +0100 received badge  Famous Question (source)
2017-11-13 22:13:35 +0100 received badge  Popular Question (source)
2017-11-13 16:34:17 +0100 commented answer Base query name/address list exclude optional data

Thank you again. I'll go to work on Jaspersoft to see how I do.

2017-11-13 00:58:28 +0100 marked best answer Base query name/address list exclude optional data

I am trying to create a query to use for a name and address Report. My issue is that there are several fields that are optional and therefore NULL. I'm not having any luck with how to code these fields to be skipped if they are NULL and also not have the line feed occur if they are NULL. I've searched various resources and tried several ways without luck. I've removed them all from my current version for a fresh start. Any suggestions to make this work? The fields include Address2, and all the Alternate address fields. Below is my code. Thank you in advance for any help.

SELECT "MemberMaster"."FirstName" || ' ' || RTRIM( "MemberMaster"."LastName" ) || '   Bdg# ' || "MemberMaster"."MemberID" || CHAR( 13 ) || "MemberMaster"."Address" || CHAR( 13 ) || "MemberMaster"."Address2" || CHAR( 13 ) || "MemberMaster"."City" || ', ' || "MemberMaster"."StateOrProvince" || '  ' || "MemberMaster"."PostalCode" || CHAR( 13 ) || "MemberMaster"."SecondaryAddress" || CHAR( 13 ) || "MemberMaster"."AltAddress2" || CHAR( 13 ) || "MemberMaster"."SecondaryCity" || ' ,' || "MemberMaster"."SecondaryStateProvince" || '  ' || "MemberMaster"."SecondaryPostalCode" || CHAR( 13 ) || "MemberMaster"."EmailAddress" || CHAR( 13 ) || "View_Phones_Combined"."PhoneNumbers" || CHAR( 13 ) || CHAR( 13 ) "directory" FROM "MemberMaster", "View_Phones_Combined" WHERE "MemberMaster"."MemberID" = "View_Phones_Combined"."PhoneID" AND "MemberMaster"."NotActive" <> 1 AND "MemberMaster"."FirstName" != '|' ORDER BY "MemberMaster"."LastName" ASC, "MemberMaster"."MemberID" ASC, "MemberMaster"."FirstName" ASC
2017-11-13 00:58:27 +0100 commented answer Base query name/address list exclude optional data

Thank you so much. That did it. I'm going to brand CASEWHEN on the back of my hand so it'll stick. :-( You couldn't gue

2017-11-12 23:13:13 +0100 asked a question Base query name/address list exclude optional data

Base query name/address list exclude optional data I am trying to create a query to use for a name and address Report. M

2017-11-12 22:50:58 +0100 received badge  Notable Question (source)
2017-11-11 20:18:38 +0100 received badge  Notable Question (source)
2017-11-09 00:12:45 +0100 commented answer Base connection to data source could not be established

Yes, you're correct. I confused/mixed up .tmp and .log. Too much reading from too many different places. I compared the

2017-11-08 14:32:09 +0100 commented answer Base connection to data source could not be established

Thank you for the additional information. In looking through your .tmp reasoning, I read that it is possible to actually

2017-11-07 20:11:49 +0100 marked best answer Base connection to data source could not be established

When trying to open the database, an error is displayed stating "the connection to the data source could not be established. Error in Script File line: etc. The error box is below. In addition, there are two extra files in the Database subfolder; a .data and .properties file both with "conflicted copy" and the user's name added to the file name. Finally, there was a new subfolder named SAS Members.tmp which was empty. Other than the '59' following the path in the error box, I see little to go on to find the problem, nor do I see a place to repair/change it. Thank you in advance for any help. Joe image description