novi
Posts: 8
|
| Posted: 03/23/2006, 1:51 AM |
|
Hi,
I'm working with CCS for a short period. I often use "dictionaries" (tables storing data for listboxes). And whenever I create another form, I have to manually connect this kind of dictionary to id field in main table.
Is there a way to somehow simplify that operation? Is CCS capable to automaticly recognize this kind of relations and do it for me?
Pawel
|
 |
 |
peterr
Posts: 5971
|
| Posted: 03/23/2006, 2:29 PM |
|
CodeCharge Studio is able to recognize relationships configured in MS Access database, when connecting to MS Access via JET driver (not ODBC). Not sure about other databases, but you could check with the support.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
novi
Posts: 8
|
| Posted: 03/28/2006, 8:45 AM |
|
OK, I asked support and get info that: Quote :Visual Query Builder automatic detection on table's relationship depends on database provider
I asked which database providers support it, but get answer they don't hav a list. Does anybody have a clue about it? Which database providers support it. They mentioned OLEDB & JET. I tested OLEDB for MySQL and it didn't work. If I have 20-30 ralations which I have to "click-out" manually it's a lot of clicking  And if you multiply it by the number of pages ...
If anybody could put some light on that I would apreciate that.
Pawel
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/28/2006, 1:56 PM |
|
Possibly there is no such provider for MySQL 5. I also recommend that you make sure that you properly store your relationship definition in MySQL 5. I think that only MySQL 5 with InnoDB supports this, and don't know how well. Couldn't find too much information about defining relationships in MySQL and I'm also not sure how you do this.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
novi
Posts: 8
|
| Posted: 03/28/2006, 3:32 PM |
|
I work with MySQL 4.0.26. Here is an example of two tables with relation:
create table Answers
(
answer_id smallint unsigned not null AUTO_INCREMENT,
question_id smallint unsigned not null,
answer char(100) not null,
primary key (answer_id)
);
create table Questions
(
question_id smallint unsigned not null AUTO_INCREMENT,
question char(255) not null,
primary key (question_id)
);
alter table Answers add constraint FK_Reference_25 foreign key (question_id)
references Questions (question_id) on delete restrict on update restrict;
|
|
|
|
|
