How do I make a summary field on a browse listbox refresh the totals? 1

[rleiman]

Hi Everyone.

I have a browse listbox with a 3 summary total fields along with a droplist that has several choices that are applied to a dynamic filter.

Can you tell me how to refresh the totals?

Thanks.

Emad-ud-deen Richard Leiman

 

[ShankarJ]

Hi Emad,

Have you tried BRWn.ResetSort(True)?

Regards

 

[rleiman]

Hi ShankarJ,

I try it, thanks.

Truly,
Emad

 

[rleiman]

Hi. ShankarJ,

I tried it but it didn't refresh the totals.

Could I be setting up the totals incorrectly?

Thanks.

Emad

 

[ShankarJ]

Hi Emad,

Try BRWn.ResetFromView() or BRWn.ResetFromFile().

Regards

 

[rleiman]

Hi ShankarJ,

Thanks, I will try it.

Truly,

Emad

 

[rleiman]

Oh, I forgot to ask if the Topspeed odbc driver comes with the Professional version of Clarion 6.3. That is the version I currently have.

Thanks.

 

[ShankarJ]

Hi Emad,

Check your \Clarion6\Bin and see is there is C4OTSDX.dll.

You may need to buy the TS-ODBC v5.

Regards

 

[rleiman]

Hi ShankarJ,

I will look for it.

Thanks.

Truly,
Emad

 

[rleiman]

Hi ShankarJ,

I found the dll file. Does that mean I can do SQL queries on the TopSpeed files?

Truly,
Emad

 

[ShankarJ]

Hi Emad,

That means it ships with C6PE. You have the DLL. How are you going to register it as an ODBC driver? You better ask SV about it.

Regards

 

[rleiman]

Hi ShankarJ,

I will do that thanks.

Truly,
Emad