Re: MS ACCES DELPHIE MASTER/SLAVE PROBLEM
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Tue, 27 Sep 2005 20:07:00 -0500
>Well I miss something So I make indexes but it is still the same.
>So that is what I have
>
>I have two tables
>1rst table call 'group' has two field (table1)
>that is the master table with the name of the different School levels
>
>1rst field = code groupe (ex gr300)
>(primary key no double)
>
>2nd field name of the group (ex 2nd level high chool classe A)
>indexed no double
>
>2nd table cal F-books has two fields (table2)
>That is the slave table with all the books used in each specifique level
>sorted by code level
>
>1rst field code level (take the value of the code groupe) (ex gr300)
>indexed with double
>
>2nd field has the barre code of the book
>indexed with double
>
>On my form, I have 3 grids
>grid1-group (group)
>grid2-books (f-books)
>grid3-table with all my books (table3)
>
>By cliking on the row of the book I choose on the grid3,
>I copy the code barre into the
>F-books table and the code level is put through the relation
>
>relation from table1.1rst field to table2 1rst field
>one to many relation type.
>I think I mist something on that level.
>
>In fact that is the same as having a master table with order
>and a slave table with the items/product indexed on the order number
>But I couldn't find an exemple with MS access.
If you have a TadoDataset for orders and one for Items
The SQL for Orders would be
Select * from Orders
The SQL for Items would be
Select * from Items where OrderNumber =:OrderNumber.
Set the Datasource property of the TadoDataset for Items to a datasource hooked
to Orders. Delphi will propagate the value of OrderNumber in Orders to the
:OrderNumber parameter in the Items SQL. Note that the parameter needs to have
the same name as a field in the dataset the Datasource property points to.
That's all it takes for a master detail link.
>
>I am not realy sure I explained properly my system.
>Sorry for the lenght of my 'report'
>See I you understand and thank anyway for having had a try
You are right you message is very difficult to decipher.
>claude
>"Claude" <livresplus@xxxxxxxx> a écrit dans le message de
>news:43384dcc@xxxxxxxxxxxxxxxxxxxxxxxxx
>> I use ms access tables with not indexes just a jointrelation between to
>> table. In my case a school classe code as master and a list of books for
>> the slave table so when on one gride I click the classe I get all the book
>> needed for that class
>> In the slave grid (table) itis not probleme to delete a book. But when I
>put
>> twice the same book in the table and want to delete one of them I get an
>> EOle Exception with the message "information about the column is not
>> suficient or incorrect. Too many ligne are affected.
>> When I carry on with the step by step commande I come to a message teeling
>> me that the lign doesn 't exist.
>> As anyone a clue why I cannot delete this ligne double.
>> thanks
>> claude
>>
>>
>
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- References:
- MS ACCES DELPHIE MASTER/SLAVE PROBLEM
- From: Claude
- Re: MS ACCES DELPHIE MASTER/SLAVE PROBLEM
- From: Claude
- MS ACCES DELPHIE MASTER/SLAVE PROBLEM
- Prev by Date: Re: Field DisplayFormat
- Next by Date: Re: Select Max(col name) Expr1000
- Previous by thread: Re: MS ACCES DELPHIE MASTER/SLAVE PROBLEM
- Next by thread: DBF to ADO
- Index(es):
Relevant Pages
|
