FTP | CCD | Buscar | Trucos | Trabajo | Foros |
|
Registrarse | FAQ | Miembros | Calendario | Guía de estilo | Temas de Hoy |
|
Herramientas | Buscar en Tema | Desplegado |
#1
|
|||
|
|||
Programacion en 3 capas usando zeos components
Habra por aqui algun experto sobre programacion en 3 capas q use la combinacion d delphi 7 + zeos components + postgresql 8.2.
Cuando hablo d 3 capas me refiero a usar componentes: zquerys, datasetproviders, clientdataset, datasource y dbgrids. Yo me he guiado del siguiente ejemplo: - Create a Form and a DataModule; - Change the creation order (Project/Options menu, Auto-create forms). Datamodule must be created first; - Add one ZConection, two ZQuerys, two Clientdatasets, one Datasource and one DatasetProvider on the Datamodule; - Set following propertys: - Configure ZConnection; - DataSource1: DataSet: ZQuery1 - ZQuery1: - Set Connection property; SQL: select fields from master_table - Double click on ZQuery1, right mouse button click, option Add All fields; - ZQuery2: - Set Connection property; SQL: select fields from detail_table - Double click on ZQuery2, right mouse button click, option Add All fields; MasterSource: DataSource1 MasterField: Master field IndexFieldNames: Detail field - DatasetProvider: Dataset: ZQuery1 - ClientdataSet1: ProviderName: DataSetProvider1 - Double click on ClientdataSet1, right mouse button click, option Add All fields; - ClientdataSet2: DatasetField: ClientdataSet1ZQuery2 //Yes, this is the name of the TDataSetField created by ClientDataSet1 - Double click on ClientdataSet2, right mouse button click, option Add All fields; The relationship is ready. File/Use Unit menu: DataModule2. To see the results, on Form1, put two dbnavigators, two dbgrids and two datasources. Configure following propertys: - DataSource1: DataSet: Datamodule2.ClientDataSet1 - DataSource2: DataSet: Datamodule2.ClientDataSet2 Link dbnavigators and dbgrids properly and write following OnCreate's Form1 event: DataModule1.ClientDataSet1.Close; DataModule1.ClientDataSet1.Open; Pero a la hora d probar el programa me doy cuenta d q en la parte d detalles todo sale NULL y no he encontrado la forma d resolver este problema. Habrá algun gurú q me ayude con este problema?? |
|
|
Temas Similares | ||||
Tema | Autor | Foro | Respuestas | Último mensaje |
No me conecto con el servidor web , con delphi usando zeos | David | MySQL | 6 | 15-03-2007 20:33:40 |
Programacion en capas | @le | OOP | 0 | 23-12-2004 16:38:04 |
Usar Components de Delphi en C++Builder | Halfo | C++ Builder | 1 | 10-09-2004 11:35:24 |
UIB Components | TJose | Firebird e Interbase | 12 | 10-02-2004 12:43:10 |
Usando componentes Zeos | JorgeBec | Conexión con bases de datos | 0 | 24-11-2003 19:53:54 |
|