Search found 6 matches

by Andrew Turner
Sun Sep 12, 2004 9:10 pm
Forum: Other Modules
Topic: Database file access
Replies: 15
Views: 19535

When you created the linked table in Access, it comes up with a dialog box asking you to select the unique record identifier, what fields did you select? DBF files are unique that you don't necesarily have a primary key for each record. For AtData you would use Mail_No, Pers_No, Date, Skill_No as t...
by Andrew Turner
Fri Sep 10, 2004 3:22 pm
Forum: Other Modules
Topic: Database file access
Replies: 15
Views: 19535

Neil, thanks for the explanation of how you do things. We ARE interested in closing the back door. Certainly we have more to learn about the package. Your example is helpful. We've been through a difficult pastoral transition over the last three years. We are now recovering and growing again under a...
by Andrew Turner
Fri Sep 10, 2004 1:03 pm
Forum: Other Modules
Topic: Database file access
Replies: 15
Views: 19535

Re: Is Foxpro ODBC driver read only?

Each member must have the activity 500 added through the activity function. This initial setup is time consuming, but then as new names are added, this becomes a matter of course. I'm not sure, but if they are not setup for that entry, I don't think you could even add attendence, which may have bee...
by Andrew Turner
Fri Sep 10, 2004 11:41 am
Forum: Other Modules
Topic: Database file access
Replies: 15
Views: 19535

Re: Is Foxpro ODBC driver read only?

But you have missed something on the the Attendance fast updating. We use something like the cards to track attendence of all visitors and members. The name appears, I hit the space bar to change the A to a B and then start entering the last name of the next person on the list. If its the person's ...
by Andrew Turner
Thu Sep 09, 2004 11:51 pm
Forum: Other Modules
Topic: Database file access
Replies: 15
Views: 19535

Re: Is Foxpro ODBC driver read only?

Just wondering ... why are you doing this when this function is already available in PC+ under the Mass Update Attendance module ?? This question from a someone who was (at one time) a IBM certified DB2 developer, and a 20 year programmer. Incidently, I mentioned my experience only to point out tha...
by Andrew Turner
Wed Sep 08, 2004 2:50 pm
Forum: Other Modules
Topic: Database file access
Replies: 15
Views: 19535

Is Foxpro ODBC driver read only?

Here's a scary user for you. :-) I'm an experienced developer of 20+ years at a large Christian ministry trying to add effeciency to the things we do at my church with Power Church. I fully understand the consequences of breaking data and would never call tech support for a problem I created. I symp...