I've got a database that I've been mucking about with, trying to set
up Crystal Re****ts X.
Actually, I've got three separate databases, that are related to each
other. However, Crystal is giving me grief about having tables from
three separate databases. As these are all btrieve databases at their
heart, I though I would simply create a new ODBC/SQL database,
combining the btrieve files I needed into one database. As all of the
btrieve files are managed by the same application and related to each
other, I didn't figure this would be a problem.
So, I took the field definitions from the DDFs for the existing
databases, and started combining them as necessary to create the new
DDF for the new database. Everything seemed to be going swimingly.
I set up some relations among these databases within Crystal (you know
the drill, this field in this table relates to that field in that
table). Somewhere along the line, things got all pukey and btrieve
started spitting out this error. Problem is, when I look at the
databases involved using PCC, there are no RI constraints shown on ANY
of the databases. I even deleted the new databases I created,
thinking that maybe there was something going on there. No dice, same
issue.
I'm running P.SQL 2000i SP4 with hotfixes, on WinXP SP2 on my
development box. Anyone got any ideas what I've gone and messed up,
and how to get it unmessed?
|
