Search found 16 matches

by bagbyci408
Wed Aug 19, 2009 8:42 pm
Forum: General Questions and Discussion
Topic: Unable to write to PCUINFO
Replies: 0
Views: 934

Unable to write to PCUINFO

I have PowerChurch Plus 10 installed on a READYNAS DUO network drive at my church. I often work at home and backup certain data files from my MyBook World network drive to a flash drive and restore them to the ReadyNAS drive. I discovered early on that some of the files caused problems when trying t...
by bagbyci408
Mon Jun 08, 2009 9:15 pm
Forum: Custom Reports
Topic: Notes Field
Replies: 1
Views: 1202

Re: Notes Field

My apologies. Apparently I have a security with my NAS server. I copied the install to a local drive and installed the latest update pt PChurch Plus 10.4 and recopied the updated system files to the server and NAS server and the report displayed the notes field properly.

Carl
by bagbyci408
Mon Jun 08, 2009 8:19 pm
Forum: Custom Reports
Topic: Notes Field
Replies: 1
Views: 1202

Notes Field

I am using Powerchurch Plus 10 with the March 30, 2009 update. I am attempting to display data from the Personal Profiles Notes field in a custom report.The field always displays empty in the report but using the database manager it displays the word "Memo" for notes containing text and "memo" for n...
by bagbyci408
Sat May 02, 2009 10:43 pm
Forum: Custom Reports
Topic: Report birthdays for a given month
Replies: 6
Views: 2293

Re: Report birthdays for a given month

Marvelous, apparently I had the date components in the wrong order and had to handle the nulls. Thanks for your help.

Carl
by bagbyci408
Fri May 01, 2009 11:01 am
Forum: Custom Reports
Topic: Report birthdays for a given month
Replies: 6
Views: 2293

Re: Report birthdays for a given month

Thanks, I stated that very poorly. I had created a new date field that can be sorted and copied the birthdays to that field to include in reports. I was trying to use the update command to set the year to a fixed value like 1900 so that birthdays would sort in the proper order. The problem is that u...
by bagbyci408
Fri May 01, 2009 10:31 am
Forum: General Questions and Discussion
Topic: Error:111 when I try to log in
Replies: 8
Views: 2101

Re: Error:111 when I try to log in

Thanks,

Carl
by bagbyci408
Fri May 01, 2009 10:11 am
Forum: General Questions and Discussion
Topic: Error:111 when I try to log in
Replies: 8
Views: 2101

Re: Error:111 when I try to log in

Thanks for your reply. Is this something in PCPlus10 or perhaps with the ReadyNASDuo share? I am using the same login on both wired and wireless platforms. I also tried logging in as administrator and got the same result. I had successfully logged in on one of the wireless systems before. I recently...
by bagbyci408
Fri May 01, 2009 9:56 am
Forum: Custom Reports
Topic: Report birthdays for a given month
Replies: 6
Views: 2293

Re: Report birthdays for a given month

Thanks,

This gets me out of the woods. I would still like to know the SQL syntax so that I could include birthday/month in a larger report if possible.

Carl
by bagbyci408
Thu Apr 30, 2009 11:03 pm
Forum: Custom Reports
Topic: Report birthdays for a given month
Replies: 6
Views: 2293

Report birthdays for a given month

I am using PCPlus 10.4 on WIndows XP. I am trying to find a way to report birthdays without considering the year. I have tried a number of SQL statements but I either get a null date returned or a type mismatch error. I did this years ago in MS Access by creating a SQL text string and executing it b...
by bagbyci408
Thu Apr 30, 2009 10:51 pm
Forum: General Questions and Discussion
Topic: Error:111 when I try to log in
Replies: 8
Views: 2101

Error:111 when I try to log in

I currently have PowerChurch Plus 10.4 installed on a Netgear NAS Duo drive. The maintenance release was installed by copying the updated files to the drive. There are currently four Windows XP PCs connected to the server to access PChurch Plus.Two are hardwired ethernet and the can access the share...
by bagbyci408
Tue Apr 14, 2009 9:53 pm
Forum: Custom Reports
Topic: Sort by memory variable
Replies: 1
Views: 1278

Sort by memory variable

I am trying to sort birthdays where the year has been truncated. The memory variable is as follows:

m.short_Bday = SUBSTR(DTOC(born),1,5)

Is it possible to sort by this variable?

Thanks,

Carl
by bagbyci408
Sun Apr 12, 2009 11:44 pm
Forum: General Questions and Discussion
Topic: Custom reports not searchable
Replies: 0
Views: 981

Custom reports not searchable

The FIND command seems to be disabled in custom reports. Is there a way to make them searchable?

Carl
by bagbyci408
Tue Feb 10, 2009 3:46 pm
Forum: Membership
Topic: Database Manager SQL commands
Replies: 8
Views: 3088

Jeff,

Thanks. The code works like a charm. I don't know how I overlooked the numerics. Also, I was aware of the caps and can live with them.

Again, thanks.

Carl
by bagbyci408
Mon Feb 09, 2009 10:03 am
Forum: Membership
Topic: Database Manager SQL commands
Replies: 8
Views: 3088

I tried several variations of the following syntax INSERT INTO ME (Mail_no,Pers_no,Status,Lastname,Firstname,Title,Mephn1_typ,Mephn2_typ,Mephn3_typ,Mephn4_typ,Mephn5_typ,E_mailbulk,E_mailstmt,Adult,Env_no,Marital,Meid) VALUES (3,"1","MA","Bagby",”Carl”,"Mr.",1,2,3,4,5,T,T,Y,101,”MM”,0) I also tried ...
by bagbyci408
Sun Feb 08, 2009 4:40 pm
Forum: Membership
Topic: Database Manager SQL commands
Replies: 8
Views: 3088

Thanks Neil. I can modify the table data using SQL but have not been able to append records.

Carl