In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

Tbrowse Question

Xailer professional forum in English
Responder
Avatar de Usuario
Dionisis Divaris
Mensajes: 485
Registrado: Jue Jul 12, 2007 8:48 pm
Ubicación: Athens Greece

Tbrowse Question

Mensaje 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
T.I.A
Dionisis
SGS-soft
support.sgs@gmail.com
Arriba
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9440
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:
Contactar ignacio

Tbrowse Question

Mensaje 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
>
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Arriba
NoName
Mensajes: 531
Registrado: Vie Feb 03, 2006 7:27 pm

Tbrowse Question

Mensaje 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
>
Arriba
Avatar de Usuario
Dionisis Divaris
Mensajes: 485
Registrado: Jue Jul 12, 2007 8:48 pm
Ubicación: Athens Greece

Tbrowse Question

Mensaje 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
>>
>
>
T.I.A
Dionisis
SGS-soft
support.sgs@gmail.com
Arriba
Avatar de Usuario
Dionisis Divaris
Mensajes: 485
Registrado: Jue Jul 12, 2007 8:48 pm
Ubicación: Athens Greece

Tbrowse Question

Mensaje 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
>>
>
>
T.I.A
Dionisis
SGS-soft
support.sgs@gmail.com
Arriba
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9440
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:
Contactar ignacio

Tbrowse Question

Mensaje 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
>>>
>>
>>
>
>
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Arriba
NoName
Mensajes: 531
Registrado: Vie Feb 03, 2006 7:27 pm

Tbrowse Question

Mensaje 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
>>>
>>
>>
>
>
Arriba
Avatar de Usuario
Dionisis Divaris
Mensajes: 485
Registrado: Jue Jul 12, 2007 8:48 pm
Ubicación: Athens Greece

Tbrowse Question

Mensaje 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
>>>>
>>>
>>>
>>
>>
>
>
T.I.A
Dionisis
SGS-soft
support.sgs@gmail.com
Arriba
Avatar de Usuario
Dionisis Divaris
Mensajes: 485
Registrado: Jue Jul 12, 2007 8:48 pm
Ubicación: Athens Greece

Tbrowse Question

Mensaje 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
>>>>
>>>
>>>
>>
>>
>
>
T.I.A
Dionisis
SGS-soft
support.sgs@gmail.com
Arriba
Responder

Volver a “Xailer Pro English”