Página 1 de 1

Tbrowse Question

Publicado: Mié May 31, 2006 7:42 am
por Dionisis Divaris
Hi All
Is there any way to determine how many records (or rows) are visible in a
browser in a specific time (i.e after aplying a filter on a database to
limit records to a specific condition) ?
Thanks in advance
Dionisis

Tbrowse Question

Publicado: Mié May 31, 2006 8:46 am
por ignacio
Dionisis,
oBrowse:KeyCount()
Regards,
"Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
news:[email=447d2cc9@ozsrvnegro.ozlan.local...]447d2cc9@ozsrvnegro.ozlan.local...[/email]
> Hi All
>
> Is there any way to determine how many records (or rows) are visible in a
> browser in a specific time (i.e after aplying a filter on a database to
> limit records to a specific condition) ?
>
> Thanks in advance
> Dionisis
>

Tbrowse Question

Publicado: Mié May 31, 2006 8:46 am
por NoName
Dionisis,
oBrowse:KeyCount()
Regards,
"Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
news:[email=447d2cc9@ozsrvnegro.ozlan.local...]447d2cc9@ozsrvnegro.ozlan.local...[/email]
> Hi All
>
> Is there any way to determine how many records (or rows) are visible in a
> browser in a specific time (i.e after aplying a filter on a database to
> limit records to a specific condition) ?
>
> Thanks in advance
> Dionisis
>

Tbrowse Question

Publicado: Jue Jun 01, 2006 7:46 am
por Dionisis Divaris
Hello Ignacio
Thank's for your answer but this is not what i'm looking for.
:oBrowse:KeyCount() shows all the records in a browser
not those are in view in a specific time.
Trying this i get a number of 3664 records (which means all the database
recond , applying a filter condition browser shows only 4 records matching
the filter condition, but when i issue a MsgInfo(Str(:oBrowse:Keycount())) ,
this still shows 3664 and not 4 records)
Any ideas on this
Thanks for your quick reply
Trully your's
Dionisis
Ï "Ignacio Ortiz de Zúñiga" <NoName@xailer.com> Ýãñáøå óôï ìÞíõìá
news:447d3be0$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Dionisis,
>
> oBrowse:KeyCount()
>
> Regards,
>
> "Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
> news:[email=447d2cc9@ozsrvnegro.ozlan.local...]447d2cc9@ozsrvnegro.ozlan.local...[/email]
>> Hi All
>>
>> Is there any way to determine how many records (or rows) are visible in a
>> browser in a specific time (i.e after aplying a filter on a database to
>> limit records to a specific condition) ?
>>
>> Thanks in advance
>> Dionisis
>>
>
>

Tbrowse Question

Publicado: Jue Jun 01, 2006 7:46 am
por Dionisis Divaris
Hello Ignacio
Thank's for your answer but this is not what i'm looking for.
:oBrowse:KeyCount() shows all the records in a browser
not those are in view in a specific time.
Trying this i get a number of 3664 records (which means all the database
recond , applying a filter condition browser shows only 4 records matching
the filter condition, but when i issue a MsgInfo(Str(:oBrowse:Keycount())) ,
this still shows 3664 and not 4 records)
Any ideas on this
Thanks for your quick reply
Trully your's
Dionisis
Ï "Ignacio Ortiz de Zúñiga" <NoName@xailer.com> Ýãñáøå óôï ìÞíõìá
news:447d3be0$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Dionisis,
>
> oBrowse:KeyCount()
>
> Regards,
>
> "Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
> news:[email=447d2cc9@ozsrvnegro.ozlan.local...]447d2cc9@ozsrvnegro.ozlan.local...[/email]
>> Hi All
>>
>> Is there any way to determine how many records (or rows) are visible in a
>> browser in a specific time (i.e after aplying a filter on a database to
>> limit records to a specific condition) ?
>>
>> Thanks in advance
>> Dionisis
>>
>
>

Tbrowse Question

Publicado: Jue Jun 01, 2006 9:44 am
por ignacio
Dionisis,
Be aware that KeyCount() by default returns the value of the RDD function
OrdKeyCount(). This function normally only takes care of index scopes,
except in Advantage that can also be aware of some filters.
If you need an accurate KeyCount() and KeyNo() value you can set the
property lKeyExact to .T. In that case the Browse really counts the existing
records with a DbEval() call. But use it with care and small sets of records
because is really slooooow.
Regards,
"Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
news:447e7f3f$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Hello Ignacio
>
> Thank's for your answer but this is not what i'm looking for.
> :oBrowse:KeyCount() shows all the records in a browser
> not those are in view in a specific time.
> Trying this i get a number of 3664 records (which means all the database
> recond , applying a filter condition browser shows only 4 records matching
> the filter condition, but when i issue a MsgInfo(Str(:oBrowse:Keycount()))
> , this still shows 3664 and not 4 records)
>
> Any ideas on this
>
> Thanks for your quick reply
>
> Trully your's
> Dionisis
>
> Ï "Ignacio Ortiz de Zúñiga" <NoName@xailer.com> Ýãñáøå óôï ìÞíõìá
> news:447d3be0$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
>> Dionisis,
>>
>> oBrowse:KeyCount()
>>
>> Regards,
>>
>> "Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
>> news:[email=447d2cc9@ozsrvnegro.ozlan.local...]447d2cc9@ozsrvnegro.ozlan.local...[/email]
>>> Hi All
>>>
>>> Is there any way to determine how many records (or rows) are visible in
>>> a browser in a specific time (i.e after aplying a filter on a database
>>> to limit records to a specific condition) ?
>>>
>>> Thanks in advance
>>> Dionisis
>>>
>>
>>
>
>

Tbrowse Question

Publicado: Jue Jun 01, 2006 9:44 am
por NoName
Dionisis,
Be aware that KeyCount() by default returns the value of the RDD function
OrdKeyCount(). This function normally only takes care of index scopes,
except in Advantage that can also be aware of some filters.
If you need an accurate KeyCount() and KeyNo() value you can set the
property lKeyExact to .T. In that case the Browse really counts the existing
records with a DbEval() call. But use it with care and small sets of records
because is really slooooow.
Regards,
"Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
news:447e7f3f$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Hello Ignacio
>
> Thank's for your answer but this is not what i'm looking for.
> :oBrowse:KeyCount() shows all the records in a browser
> not those are in view in a specific time.
> Trying this i get a number of 3664 records (which means all the database
> recond , applying a filter condition browser shows only 4 records matching
> the filter condition, but when i issue a MsgInfo(Str(:oBrowse:Keycount()))
> , this still shows 3664 and not 4 records)
>
> Any ideas on this
>
> Thanks for your quick reply
>
> Trully your's
> Dionisis
>
> Ï "Ignacio Ortiz de Zúñiga" <NoName@xailer.com> Ýãñáøå óôï ìÞíõìá
> news:447d3be0$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
>> Dionisis,
>>
>> oBrowse:KeyCount()
>>
>> Regards,
>>
>> "Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
>> news:[email=447d2cc9@ozsrvnegro.ozlan.local...]447d2cc9@ozsrvnegro.ozlan.local...[/email]
>>> Hi All
>>>
>>> Is there any way to determine how many records (or rows) are visible in
>>> a browser in a specific time (i.e after aplying a filter on a database
>>> to limit records to a specific condition) ?
>>>
>>> Thanks in advance
>>> Dionisis
>>>
>>
>>
>
>

Tbrowse Question

Publicado: Jue Jun 01, 2006 3:16 pm
por Dionisis Divaris
Hello again Ignatio
I solve my problem using the COUNT TO command with
the FOR clause as exactly the same as my filter condition.
Works perfect
Thanks in Advance
Dionisis
Ï "Ignacio Ortiz de Zúñiga" <NoName@xailer.com> Ýãñáøå óôï ìÞíõìá
news:447e9ae9$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Dionisis,
>
> Be aware that KeyCount() by default returns the value of the RDD function
> OrdKeyCount(). This function normally only takes care of index scopes,
> except in Advantage that can also be aware of some filters.
>
> If you need an accurate KeyCount() and KeyNo() value you can set the
> property lKeyExact to .T. In that case the Browse really counts the
> existing records with a DbEval() call. But use it with care and small sets
> of records because is really slooooow.
>
> Regards,
>
> "Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
> news:447e7f3f$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
>> Hello Ignacio
>>
>> Thank's for your answer but this is not what i'm looking for.
>> :oBrowse:KeyCount() shows all the records in a browser
>> not those are in view in a specific time.
>> Trying this i get a number of 3664 records (which means all the database
>> recond , applying a filter condition browser shows only 4 records
>> matching the filter condition, but when i issue a
>> MsgInfo(Str(:oBrowse:Keycount())) , this still shows 3664 and not 4
>> records)
>>
>> Any ideas on this
>>
>> Thanks for your quick reply
>>
>> Trully your's
>> Dionisis
>>
>> Ï "Ignacio Ortiz de Zúñiga" <NoName@xailer.com> Ýãñáøå óôï ìÞíõìá
>> news:447d3be0$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
>>> Dionisis,
>>>
>>> oBrowse:KeyCount()
>>>
>>> Regards,
>>>
>>> "Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
>>> news:[email=447d2cc9@ozsrvnegro.ozlan.local...]447d2cc9@ozsrvnegro.ozlan.local...[/email]
>>>> Hi All
>>>>
>>>> Is there any way to determine how many records (or rows) are visible in
>>>> a browser in a specific time (i.e after aplying a filter on a database
>>>> to limit records to a specific condition) ?
>>>>
>>>> Thanks in advance
>>>> Dionisis
>>>>
>>>
>>>
>>
>>
>
>

Tbrowse Question

Publicado: Jue Jun 01, 2006 3:16 pm
por Dionisis Divaris
Hello again Ignatio
I solve my problem using the COUNT TO command with
the FOR clause as exactly the same as my filter condition.
Works perfect
Thanks in Advance
Dionisis
Ï "Ignacio Ortiz de Zúñiga" <NoName@xailer.com> Ýãñáøå óôï ìÞíõìá
news:447e9ae9$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Dionisis,
>
> Be aware that KeyCount() by default returns the value of the RDD function
> OrdKeyCount(). This function normally only takes care of index scopes,
> except in Advantage that can also be aware of some filters.
>
> If you need an accurate KeyCount() and KeyNo() value you can set the
> property lKeyExact to .T. In that case the Browse really counts the
> existing records with a DbEval() call. But use it with care and small sets
> of records because is really slooooow.
>
> Regards,
>
> "Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
> news:447e7f3f$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
>> Hello Ignacio
>>
>> Thank's for your answer but this is not what i'm looking for.
>> :oBrowse:KeyCount() shows all the records in a browser
>> not those are in view in a specific time.
>> Trying this i get a number of 3664 records (which means all the database
>> recond , applying a filter condition browser shows only 4 records
>> matching the filter condition, but when i issue a
>> MsgInfo(Str(:oBrowse:Keycount())) , this still shows 3664 and not 4
>> records)
>>
>> Any ideas on this
>>
>> Thanks for your quick reply
>>
>> Trully your's
>> Dionisis
>>
>> Ï "Ignacio Ortiz de Zúñiga" <NoName@xailer.com> Ýãñáøå óôï ìÞíõìá
>> news:447d3be0$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
>>> Dionisis,
>>>
>>> oBrowse:KeyCount()
>>>
>>> Regards,
>>>
>>> "Dionisis Divaris" <sv1fkk@hol.gr> escribió en el mensaje
>>> news:[email=447d2cc9@ozsrvnegro.ozlan.local...]447d2cc9@ozsrvnegro.ozlan.local...[/email]
>>>> Hi All
>>>>
>>>> Is there any way to determine how many records (or rows) are visible in
>>>> a browser in a specific time (i.e after aplying a filter on a database
>>>> to limit records to a specific condition) ?
>>>>
>>>> Thanks in advance
>>>> Dionisis
>>>>
>>>
>>>
>>
>>
>
>