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

On Tue, 19 Feb 2008 10:53:31 -0500, Dennis Santoro
<RDAPres@[EMAIL PROTECTED]
> wrote:

Hi Denn,

Please see my comments inline below...

>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.

I just tried the wantinmemorytcursor approach, but still get
the GPF on that one machine.

> 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

My present DM will not allow that approach...

>
>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.

I'll try the setRange approach...

Thanks!

>
>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,
-- 
Kenneth

If you email... Please remove the "SPAMLESS."