Re: Same form, but one system GPFs...?

If you do the query to an in memory tcursor (see wantinmemorytcursor in 
the opal help) then the c functions should be fine as you are now 
completely local. It is using cfunctions against shared tables that is 
the problem. But if you want to display a total why not just put a 
sumarry field on the form? Of course it will depend a little on your 
data model but if all the items are related to one check then it would 
seem you would have a structure like

Check.db-->>Detail.db so placing a filed for the detail amount and 
making it a sum would show you the total for that check. Also you can 
likely avoid the query by using the index field for your link from check 
to detail and a setrange which will be light years faster than a query 
if you can't do it with just placing a field.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and 
non-profits since 1982

Kenneth wrote:
> On Tue, 19 Feb 2008 19:40:46 +1100, Tom Krieg
> <user@[EMAIL PROTECTED]
> wrote:
> 
>> IIRC, c-functions place a table lock on the table. Maybe the crash has 
>> to do with the way the BDE is set up on that computer? (Local share, 
>> path to the net directory) or oplocks or write-cacheing or max file 
>> handles or buffer sizes. Maybe there is a lock issue, or the lock files

>> have maxed-out.
>>
>> Doing a registry clean-up with a commercial registry cleaner has 
>> sometimes fixed inexplicable problems and crashes for me (not with 
>> Paradox but Windows and other software).
>>
>> Just thinking out loud.
>>
>> TomK
>>
>> Anders Jonsson wrote:
>>> using cMax in a multi-user environment is a bad idea but it 
>>> shouldn't bring Paradox down.
>>>
> 
> Hello to all,
> 
> I have the form working well, but have a question:
> 
> I wanted to add a button that would display the sum of all
> entries written on a particular check.
> 
> The code runs a query, then a tCursor cSum to get the total.
> 
> But, as is now familiar, on all machines but one, this works
> fine, but that one machine GPFs when the button is clicked.
> 
> Based on the other problems I have had, it would appear that
> the difficulty is in my using cSum to get the total.
> 
> That surprised me because, (though I am accessing the form
> over our Lan) the cSum process itself would seem to be local
> to each machine, that is, it evaluates the cSum on the
> ANSWER.DB that is in the :PRIV: local to each machine.
> 
> Why might that be causing the GPF?
> 
> Also, what is another (better) way for me to get the sum?
> 
> Sincere thanks,