Select Multiple tables insert
From: Adrian Billingham (adrian_at_bill5.com)
Date: 01/17/05
- Next message: danny heijl: "Re: question to Bill Todd and community / ADODB Unit in D7 Enterprise"
- Previous message: Del M: "Re: BeginTrans"
- Next in thread: Brian Bushay TeamB: "Re: Select Multiple tables insert"
- Reply: Brian Bushay TeamB: "Re: Select Multiple tables insert"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Mon, 17 Jan 2005 12:58:06 -0000
I have a select statement with Multiple joins but i want to insert ointo the
primary table! When i call insert / post it inserts the main record then
gives an error aboutr faiking to insert into one of the other tables ...
This was solved in teh delete statment using Properties['Unique
Table'].Value := 'Detail'
What is the equivalent for inserts
- Next message: danny heijl: "Re: question to Bill Todd and community / ADODB Unit in D7 Enterprise"
- Previous message: Del M: "Re: BeginTrans"
- Next in thread: Brian Bushay TeamB: "Re: Select Multiple tables insert"
- Reply: Brian Bushay TeamB: "Re: Select Multiple tables insert"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]