Rudi,

Would you please download this file, which is a little project using your
two queries in a master-detail configuration. You will need to change the
Server and Path properties before you run it.

File : /Demo Apps/rudy_josic.zip
Uploaded by : helebor <helebor@...>
Description : IBO 4.5B Master-detail demo for Rudi Josic

You can access the file at the URL:
http://groups.yahoo.com/group/IBObjects/files/Demo%20Apps/rudy_josic.zip

Look carefully at the KeyLinks of BOTH datasets and the MasterLinks of the
qRequiere dataset.

Helen

++++++++++++++++++++++++++++++++++
At 03:21 PM 19/06/2005 +0000, you wrote:

> >1. What exception messages do you see?
>
>when tring to prepare the detil query the error raised is:
>
>Exception class EIB_ISCError with message 'ISC ERROR CODE:335544569
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 5, char 47
> "_0"
>'
>(i open the master query before the detail one)
>
> >2. Do make sure NOT to place blanks at the left and right sides of
>the "="
>sign.
>
>(i cut and paste from query editor, and there is no blanks)
>
>**in the master query:
>
>SELECT "Id"
> , "Nombre"
>FROM "Muebles"
>
>keylinks:"Muebles"."Id"
>
>**in the detail query
>
>SELECT "Id_Mueble"
> , "Id_Material"
> , "Cantidad"
>FROM "Requiere"
>
>keyliks:"Requiere"."Id_Mueble"
> "Requiere"."Id_Material"
>
>masterliks:"Requiere"."Id_Mueble" = "Muebles"."Id"
>
>and, off course, mastersource is the Datasourse of the master query :)
>
>in the db declaration: SET SQL DIALECT 3;
>in the tib_connection: SQLDialect 3
>
>i put a ib_monitor, i hope this information helps:
>
>/*---
>START TRANSACTION
>DB HANDLE COUNT 1
>TR_HANDLE = 3829940
>----*/
>/*---
>PREPARE STATEMENT
>TR_HANDLE = 3829940
>STMT_HANDLE = 3830036
>
>SELECT "Id"
> , "Nombre"
>FROM "Muebles"
>ORDER BY "Nombre" ASC
>
>PLAN SORT ((Muebles NATURAL))
>
>FIELDS = [ Version 1 SQLd 2 SQLn 30
> MUEBLES.ID = <NIL>
> MUEBLES.NOMBRE = <NIL> ]
>----*/
>/*---
>EXECUTE STATEMENT
>TR_HANDLE = 3829940
>STMT_HANDLE = 3830036
>PARAMS = [ ]
>----*/
>/*---
>PREPARE STATEMENT
>TR_HANDLE = 3829940
>STMT_HANDLE = 3829604
>
>
>SELECT "Id_Mueble"
> , "Id_Material"
> , "Cantidad"
>FROM "Requiere"
>WHERE "Requiere"."Id_Mueble" =? /* "MLNK_Id_Mueble" */ "_0"
>
>FIELDS = [ Version 1 SQLd 2 SQLn 30
> MUEBLES.ID = <NIL>
> MUEBLES.NOMBRE = <NIL> ]
>
>ERRCODE = 335544569
>----*/
>/*---
>PREPARE STATEMENT
>TR_HANDLE = 3829940
>STMT_HANDLE = 3829604
>
>SELECT "Id_Mueble"
> , "Id_Material"
> , "Cantidad"
>FROM "Requiere"
>WHERE "Requiere"."Id_Mueble" =? /* PRM_0 */ "_0"
>
>FIELDS = [ Version 1 SQLd 2 SQLn 30
> MUEBLES.ID = <NIL>
> MUEBLES.NOMBRE = <NIL> ]
>
>ERRCODE = 335544569
>----*/
>/*---
>INTERPRET BUFFER =
>
>ERRCODE = 17
>----*/
>/*---
>INTERPRET BUFFER = Dynamic SQL Error
>
>ERRCODE = 21
>----*/
>/*---
>INTERPRET BUFFER = SQL error code = -104
>
>ERRCODE = 31
>----*/
>/*---
>INTERPRET BUFFER = Token unknown - line 5, char 47
>
>ERRCODE = 4
>----*/
>/*---
>INTERPRET BUFFER = "_0"
>
>ERRCODE = -1
>----*/
>/*---
>COMMIT
>TR_HANDLE = 3830280
>----*/
>/*---
>COMMIT
>TR_HANDLE = 3830224
>----*/
>/*---
>COMMIT
>TR_HANDLE = 3829940
>----*/
>
>
> >3. Please do not requote old messages.
>
>Sorry
>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Yahoo! Groups Links
>
>
>
>