Re: TADOQuery - using 2 detail parameters for same master field

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 02/29/04 

Date: Sun, 29 Feb 2004 09:18:17 -0600

>Of course, you can name a parameter whatever you want, but for TADOQuery, it must be the master
>table's fieldname. How else would it know what field to get the value from? Try it out and
>you'll see what I mean.

The SQL passed to ADO can't have parameters of the same name.
Borlands ADO components are not going to maintain master/Detail with your SQL.
You will need to change the name of one of the parameters then write code for
the master tables AfterScroll event to handle setting the detail table
parameters and then REQUERY 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • RE: pdf file per record creation from form
    ... I am printing a record, ... >> I am trying to save each record in a form, call it frmData, as a separate pdf ... >> From the master form- I rename frmData to match field on master, say FieldName ...
    (microsoft.public.access.formscoding)
  • RE: pdf file per record creation from form
    ... By printing it to the PDF Writer e.g. for adobe you can print automatically ... > From the master form- I rename frmData to match field on master, say FieldName ... > Close form FieldName ...
    (microsoft.public.access.formscoding)
  • Re: TADOQuery - using 2 detail parameters for same master field
    ... Of course, you can name a parameter whatever you want, but for TADOQuery, it must be the master ... >>there a way to make this work using TADOQuery or another ADO descendant component? ... > ADO doesn't support parameters of the same name in a query. ...
    (borland.public.delphi.database.ado)