Search found 2 matches
- 27.09.2005, 11:45
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: select ... where MasterLink=:MasterLink
- Replies: 1
- Views: 1046
select ... where MasterLink=:MasterLink
Hi, i use Zeos 6.5.1 with BCB6 & mysql 4.1.15. I have a simple project for testing master/detail functionality! My master table has a column "MasterLink" wich is filled by a "select UUID()" statement. Column type is varchar(36). The detail table has a equivalent column. The v...
- 22.09.2005, 13:00
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: TZQuery & LAST_INSERT_ID()
- Replies: 1
- Views: 1471
TZQuery & LAST_INSERT_ID()
Hi, i am new to ZEOS components. I use TZQuery with TDatasetProvider & TClientDataset to access a mysql-server 4.1.15 from BCB 6! My test app is a simple master-detail-relation. How can i get the autogenerated id after inserting the master record. A simple "select LAST_INSERT_ID()" in ...