Hi, I have a problem with the function RecordCount. Do not work property where I activated the Joined Fields. I have for example 5 Record, and the function return 2 as show here.

Mastersource Table tableEditorial
Editorial Name
1 Anaya multimedia
2 Mcgraw-Hill
3 Ra-Ma

Joined by tableEditoria.Editoria->book.Editoria

Detail Table book
Id Editorial title author
122 1 xxxx any
123 1 tttt any
123 2 other fff
322 3 Another fff
456 3 tyyytt ffff

We are in record 1 of Table Editorial, the grid shown record is 122,123 in table Book. I used the recordcount,but it result 2.
I need the total of record, that is 5. What is up?
THANK. Armando Blanco

: Hi, I have a problem with the function RecordCount. Do not work property where I activated the Joined Fields. I have for example 5 Record, and the function return 2 as show here.
:
: Mastersource Table tableEditorial
: Editorial Name
: 1 Anaya multimedia
: 2 Mcgraw-Hill
: 3 Ra-Ma
:
: Joined by tableEditoria.Editoria->book.Editoria
:
: Detail Table book
: Id Editorial title author
: 122 1 xxxx any
: 123 1 tttt any
: 123 2 other fff
: 322 3 Another fff
: 456 3 tyyytt ffff
:
: We are in record 1 of Table Editorial, the grid shown record is 122,123 in table Book. I used the recordcount,but it result 2.
: I need the total of record, that is 5. What is up?
: THANK. Armando Blanco
:
:

Hi!

If you set your master-detail relationship, the recordcount in the detail table result the number of the matching records. It is proper,so you can handle the resultset this way properly... If you wanna get the real recordcount, turn off the relationsip for a short while, and check the recorncount, then reset the relationsip. If you call the master table disablecontrols, and then check the recornumbers, then call the table enablecontrols function, you will get the same result, and the user wont notice anything at all.
Maybe someone could came up with better ideas, but thats what I could figure out right now.


\\///
/O O\
| | |
| _ |
\___/
SoftMan

: : Hi, I have a problem with the function RecordCount. Do not work property where I activated the Joined Fields. I have for example 5 Record, and the function return 2 as show here.
: :
: : Mastersource Table tableEditorial
: : Editorial Name
: : 1 Anaya multimedia
: : 2 Mcgraw-Hill
: : 3 Ra-Ma
: :
: : Joined by tableEditoria.Editoria->book.Editoria
: :
: : Detail Table book
: : Id Editorial title author
: : 122 1 xxxx any
: : 123 1 tttt any
: : 123 2 other fff
: : 322 3 Another fff
: : 456 3 tyyytt ffff
: :
: : We are in record 1 of Table Editorial, the grid shown record is 122,123 in table Book. I used the recordcount,but it result 2.
: : I need the total of record, that is 5. What is up?
: : THANK. Armando Blanco
: :
: :
:
: Hi!
:
: If you set your master-detail relationship, the recordcount in the detail table result the number of the matching records. It is proper,so you can handle the resultset this way properly... If you wanna get the real recordcount, turn off the relationsip for a short while, and check the recorncount, then reset the relationsip. If you call the master table disablecontrols, and then check the recornumbers, then call the table enablecontrols function, you will get the same result, and the user wont notice anything at all.
: Maybe someone could came up with better ideas, but thats what I could figure out right now.
:
:
: \\///
: /O O\
: | | |
: | _ |
: \___/
: SoftMan
:
:

: : : Hi, I have a problem with the function RecordCount. Do not work property where I activated the Joined Fields. I have for example 5 Record, and the function return 2 as show here.
: : :
: : : Mastersource Table tableEditorial
: : : Editorial Name
: : : 1 Anaya multimedia
: : : 2 Mcgraw-Hill
: : : 3 Ra-Ma
: : :
: : : Joined by tableEditoria.Editoria->book.Editoria
: : :
: : : Detail Table book
: : : Id Editorial title author
: : : 122 1 xxxx any
: : : 123 1 tttt any
: : : 123 2 other fff
: : : 322 3 Another fff
: : : 456 3 tyyytt ffff
: : :
: : : We are in record 1 of Table Editorial, the grid shown record is 122,123 in table Book. I used the recordcount,but it result 2.
: : : I need the total of record, that is 5. What is up?
: : : THANK. Armando Blanco
: : :
: : :
: :
: : Hi!
: :
: : If you set your master-detail relationship, the recordcount in the detail table result the number of the matching records. It is proper,so you can handle the resultset this way properly... If you wanna get the real recordcount, turn off the relationsip for a short while, and check the recorncount, then reset the relationsip. If you call the master table disablecontrols, and then check the recornumbers, then call the table enablecontrols function, you will get the same result, and the user wont notice anything at all.
: : Maybe someone could came up with better ideas, but thats what I could figure out right now.
: :
: :
: : \\///
: : /O O\
: : | | |
: : | _ |
: : \___/
: : SoftMan
: :
: :
:
:
It's working greate, a lot of thank.
Sincearly
Armando Blanco C.
I learned another thing of delphi.