Guidance
指路人
g.yi.org
Guidance Forums / wxWidgets (wxWindows) in C++ / relational database with wxODBC

Register 
注册
Search 搜索
首页 
Home Home
Software
Upload

  
Forum List • Thread List • Reply • Refresh • New Topic • Search • Previous • Next First 1 Last
Message1. relational database with wxODBC
#2575
Posted by: 2003-08-29 19:51:33
hi! i'm writing my first wxWindows application.
i use wxDb & wxDbTable classes to connect to my MySQL database and create some tables. but i don't know how to connect this tables into relational database. i couldn't find in documentation functions to create relations between  tables.... wxDbTable::SetColDefs() & wxDbTable::CreateTable() seems to be insufficient...
i know how to write it SQL but i want to use wxODBC...
(sorry for my english...)
Message2. Re: relational database with wxODBC
#2614
Posted by: 2003-09-09 22:16:28
Hi,
I'm not very expert however I'm using

wxDbTable::QueryBySqlStmt

to join more that one table using standard SQL.
The pointer to the wxDbTable class is releted to one only
table (to insert/delete/update records) but you can read
with wxDbTable::SetColDefs from other tables, selected
from your query.

Andrea
Message3. Re: relational database with wxODBC
#2615
Posted by: 2003-09-10 21:37:49
Just a guess: Can wxODBC classes deal with views? In that case you could "connect" the tables as a view and then use wxDbTable to work with it.

upcase
Forum List • Thread List • Reply • Refresh • New Topic • Search • Previous • Next First 1 Last
掌柜推荐
 
 
 
 
 
 
 
 
 
 
 
 
© Sun 2022-12-4  Guidance Laboratory Inc.
Email:webmaster1g.yi.org Hits:0