Topic: Using Master/Detail with Midas
|
|
Rodrigo M S Miguel
User
Fresh Boarder
| Posts: 4 |   |
Karma: 0
|
|
Using Master/Detail with Midas
|
|
Posted: 2001/02/12 08:01 |
|
|
|
|
Hi Dmitry
I'd like to use master/detail relationship over midas.
Doing this on BDE/DOA is simple, but I don´t know how do it on NOCI. I must use Datasource on Server ? Is there some properties on TOCIQuery to link both Master and Detail ? Please give a clue.
Another question, I found on TOCIQuery theses properties: OBoolFalse, OBoolSize, OBoolTrue, OBooltype, How is it works ?
I'm using 1 and 0 to supply my boolean fields on Oracle, it´s possible convert this values on TDataSet to Boolean, but without critical changes ?
Thanks a Lot
Rodrigo M.S. Miguel
|
|
Diman
Admin
Admin
| Posts: 1509 | |
Karma: 20
|
|
RE: Using Master/Detail with Midas
|
|
Posted: 2001/02/13 04:49 |
|
|
|
|
Hello Rodrigo !
Master/detail is implemented in NCOCI8 in the same way as in standard Delphi BDE components. So, set TOCIQuery.DataSource property to point to any other master dataset. TOCIQuery will substitute parameters with the same names as a fields from master dataset with they values.
OBoolFalse, OBoolSize, OBoolTrue, OBooltype this properties are using for TOCIParam property AsBoolean. NCOCI8 will automatically convert parameter value to Boolean type using mentioned above properties. By default:
OBoolFalse = 1
OBoolTrue = 0
OBooltype = otSmallInt
Regards,
Dmitry
|
|
Rodrigo M S Miguel
User
Fresh Boarder
| Posts: 4 | |
Karma: 0
|
|
RE: Using Master/Detail with Midas
|
|
Posted: 2001/02/15 03:34 |
|
|
|
|
Thanks Dmitry,
But, Datasource propertie will accept other TOCIQuery ?
I try, but, this only accept TDataSource?
Is this correct ?
Regards,
Rodrigo M.S. Miguel
|
|
Diman
Admin
Admin
| Posts: 1509 | |
Karma: 20
|
|
RE: Using Master/Detail with Midas
|
|
Posted: 2001/02/15 10:19 |
|
|
|
|
Hi Rodrigo !
Yes, exactly TOCIQuery.DataSource is of type TDataSource. The same way as in TQuery. It is little excuse for missing documentation - just read TQuery help <g>.
Regards,
Dmitry
|
|
Diman
Admin
Admin
| Posts: 1509 | |
Karma: 20
|
|
RE: Using Master/Detail with Midas
|
|
Posted: 2001/02/15 10:20 |
|
|
|
|
Forget to say ...
TOCIQuery.DataSource -> TDataSource.DataSet -> <any TDataSet descendant, for example another TOCIQuery>
|
|
Rodrigo M S Miguel
User
Fresh Boarder
| Posts: 4 | |
Karma: 0
|
|
RE: Using Master/Detail with Midas
|
|
Posted: 2001/02/16 00:19 |
|
|
|
|
|
Thanks, It´s works now
|
|
|
