Página 1 de 1

DataSets combining

Publicado: Vie Nov 25, 2005 10:09 am
por Ingo
Hello,
Usind 2 DbfDataSets (for example 'order' and 'person') standing in relation
e.g. over a recordpointer.
Can I show fields from both DataSets together in one TDBBrowse or have I to
do it in the "nostalgic" way?
Is the AddCalcField method appropriate to get a fieldvalue from an other
DataSet?
Thanks in advance
Ingo

DataSets combining

Publicado: Vie Nov 25, 2005 10:18 am
por ignacio
Ingo,
You can make a calculated field on master table, but is even easier, just
use the event OnGetData of the detail column with something like this:
METHOD DBBrowse1Column1GetData( oSender, cText, nImage ) CLASS TForm1
cText := oDetailDataSet:oFieldByName( "fieldname" ):FieldGet()
RETURN Nil
Regards,
"Ingo" <ingo.jh@web.de> escribió en el mensaje
news:[email=4386d4e9@ozsrvnegro.ozlan.local...]4386d4e9@ozsrvnegro.ozlan.local...[/email]
> Hello,
>
> Usind 2 DbfDataSets (for example 'order' and 'person') standing in
> relation e.g. over a recordpointer.
>
> Can I show fields from both DataSets together in one TDBBrowse or have I
> to do it in the "nostalgic" way?
>
> Is the AddCalcField method appropriate to get a fieldvalue from an other
> DataSet?
>
> Thanks in advance
>
> Ingo
>

DataSets combining

Publicado: Vie Nov 25, 2005 11:25 am
por Ingo
Ignacio,
I have to thank you one more time again.
DBBrowse1Column1GetData isn't working I get the error:
TForm1:DBBrowse1Column1GetData(70)
Fehler BASE/1004 Class: 'NIL' has no exported method: FIELDGET
Argumente: ()
but using the event OnDrawCell it works
Regards
Ingo
"Ignacio Ortiz de Zúñiga" <InvalidAccount@ozs.com> schrieb im Newsbeitrag
news:4386d6fb$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Ingo,
>
> You can make a calculated field on master table, but is even easier, just
> use the event OnGetData of the detail column with something like this:
>
> METHOD DBBrowse1Column1GetData( oSender, cText, nImage ) CLASS TForm1
>
> cText := oDetailDataSet:oFieldByName( "fieldname" ):FieldGet()
>
> RETURN Nil
>
> Regards,
>
> "Ingo" <ingo.jh@web.de> escribió en el mensaje
> news:[email=4386d4e9@ozsrvnegro.ozlan.local...]4386d4e9@ozsrvnegro.ozlan.local...[/email]
>> Hello,
>>
>> Usind 2 DbfDataSets (for example 'order' and 'person') standing in
>> relation e.g. over a recordpointer.
>>
>> Can I show fields from both DataSets together in one TDBBrowse or have I
>> to do it in the "nostalgic" way?
>>
>> Is the AddCalcField method appropriate to get a fieldvalue from an other
>> DataSet?
>>
>> Thanks in advance
>>
>> Ingo
>>
>
>

DataSets combining

Publicado: Vie Nov 25, 2005 12:46 pm
por ignacio
Ingo,
Then, oDetailDataSet:oFieldByName( "fieldname" ) is returning NIL and should
return a TDataField object. Check the 'fieldname'.
Regards,
"Ingo" <ingo.jh@web.de> escribió en el mensaje
news:4386e6b1$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Ignacio,
>
> I have to thank you one more time again.
>
> DBBrowse1Column1GetData isn't working I get the error:
>
> TForm1:DBBrowse1Column1GetData(70)
> Fehler BASE/1004 Class: 'NIL' has no exported method: FIELDGET
> Argumente: ()
>
> but using the event OnDrawCell it works
>
> Regards
>
> Ingo
>
> "Ignacio Ortiz de Zúñiga" <InvalidAccount@ozs.com> schrieb im Newsbeitrag
> news:4386d6fb$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
>> Ingo,
>>
>> You can make a calculated field on master table, but is even easier, just
>> use the event OnGetData of the detail column with something like this:
>>
>> METHOD DBBrowse1Column1GetData( oSender, cText, nImage ) CLASS TForm1
>>
>> cText := oDetailDataSet:oFieldByName( "fieldname" ):FieldGet()
>>
>> RETURN Nil
>>
>> Regards,
>>
>> "Ingo" <ingo.jh@web.de> escribió en el mensaje
>> news:[email=4386d4e9@ozsrvnegro.ozlan.local...]4386d4e9@ozsrvnegro.ozlan.local...[/email]
>>> Hello,
>>>
>>> Usind 2 DbfDataSets (for example 'order' and 'person') standing in
>>> relation e.g. over a recordpointer.
>>>
>>> Can I show fields from both DataSets together in one TDBBrowse or have I
>>> to do it in the "nostalgic" way?
>>>
>>> Is the AddCalcField method appropriate to get a fieldvalue from an other
>>> DataSet?
>>>
>>> Thanks in advance
>>>
>>> Ingo
>>>
>>
>>
>
>

DataSets combining

Publicado: Sab Nov 26, 2005 9:01 am
por Ingo
Ignacio,
I used for the OnGetData event the same code like for the OnDrawCell event
because I copied the line from the GetData method to the DrawCell method.
Regards
Ingo
"Ignacio Ortiz de Zúñiga" <InvalidAccount@ozs.com> schrieb im Newsbeitrag
news:4386f988$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
> Ingo,
>
> Then, oDetailDataSet:oFieldByName( "fieldname" ) is returning NIL and
> should return a TDataField object. Check the 'fieldname'.
>
> Regards,
>
> "Ingo" <ingo.jh@web.de> escribió en el mensaje
> news:4386e6b1$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
>> Ignacio,
>>
>> I have to thank you one more time again.
>>
>> DBBrowse1Column1GetData isn't working I get the error:
>>
>> TForm1:DBBrowse1Column1GetData(70)
>> Fehler BASE/1004 Class: 'NIL' has no exported method: FIELDGET
>> Argumente: ()
>>
>> but using the event OnDrawCell it works
>>
>> Regards
>>
>> Ingo
>>
>> "Ignacio Ortiz de Zúñiga" <InvalidAccount@ozs.com> schrieb im Newsbeitrag
>> news:4386d6fb$[email=1@ozsrvnegro.ozlan.local...]1@ozsrvnegro.ozlan.local...[/email]
>>> Ingo,
>>>
>>> You can make a calculated field on master table, but is even easier,
>>> just use the event OnGetData of the detail column with something like
>>> this:
>>>
>>> METHOD DBBrowse1Column1GetData( oSender, cText, nImage ) CLASS TForm1
>>>
>>> cText := oDetailDataSet:oFieldByName( "fieldname" ):FieldGet()
>>>
>>> RETURN Nil
>>>
>>> Regards,
>>>
>>> "Ingo" <ingo.jh@web.de> escribió en el mensaje
>>> news:[email=4386d4e9@ozsrvnegro.ozlan.local...]4386d4e9@ozsrvnegro.ozlan.local...[/email]
>>>> Hello,
>>>>
>>>> Usind 2 DbfDataSets (for example 'order' and 'person') standing in
>>>> relation e.g. over a recordpointer.
>>>>
>>>> Can I show fields from both DataSets together in one TDBBrowse or have
>>>> I to do it in the "nostalgic" way?
>>>>
>>>> Is the AddCalcField method appropriate to get a fieldvalue from an
>>>> other DataSet?
>>>>
>>>> Thanks in advance
>>>>
>>>> Ingo
>>>>
>>>
>>>
>>
>>
>
>