Too many errors

[Alton]

I am encountering error after error when I try to use software I build. Everything from inability to connect with database errors, errors telling me that some "other user" is has entered conflicting data to this latest one when I try to enter a new record in one of my softwares...

.................................................. .........................................
The following error occurred:

Error 204 (Provider v. 3.2.1.43):Relationship with same name exists:
FK_Vehicles_Oid
Error 200 (Provider v. 3.2.1.43): Cannot set foreign key constraint:
FK_Vehicles_Oid

.................................................. ...........................................

I have tried two different products that I made. Both have errors; not neccessarily the same ones. I am using software installed from setups in most cases rather than the software obtained from running the software from the TSB.

I'm getting a lot of time invested and can't quite get a working product. Is anyone else having similar problems? My suspicion is that these problems have to do with databases. I have tried deleting the whole program from Program Files and reinstalling. No luck yet.

Thanks,
Alton

[MikeM]

Did you check to see you aren't using the same name for the object and the caption and the editor?

[TigerSoftware]

I am encountering error after error when I try to use software I build. Everything from inability to connect with database errors, errors telling me that some "other user" is has entered conflicting data to this latest one when I try to enter a new record in one of my softwares...

.................................................. .........................................
The following error occurred:

Error 204 (Provider v. 3.2.1.43):Relationship with same name exists:
FK_Vehicles_Oid
Error 200 (Provider v. 3.2.1.43): Cannot set foreign key constraint:
FK_Vehicles_Oid

.................................................. ...........................................

I have tried two different products that I made. Both have errors; not neccessarily the same ones. I am using software installed from setups in most cases rather than the software obtained from running the software from the TSB.

I'm getting a lot of time invested and can't quite get a working product. Is anyone else having similar problems? My suspicion is that these problems have to do with databases. I have tried deleting the whole program from Program Files and reinstalling. No luck yet.

Thanks,
Alton


Hi Alton,


Mike might be right that it could be a naming problem.

If you uninstall, you have to delete the directory because it leaves a database behind.

List your object names and editor names here and let me take a look at it. If you don't want pm me the details.


Thomas

[Alton]

I always name the object and the caption the same thing. And, I always name the editor and the caption the same thing. If that is a bad thing...it sounds like I have been very, very bad! :eek: No problem, I will redo things in the morning and let you know. :D

What are the rules regarding uniqueness? Must all editors differ from all other editors or does the uniqueness only pertain to the particular object they belong to? And, may we have objects with same named editors residing on the same software?

Thanks for the help.
Alton

[MikeM]

I did run into this problem before, and then I started naming my objects as below:

Object: Word Processor Object
Caption: Word Processor

When creating an editor in the object, I seem to be able to get away with the same name for both the Property Name and the Caption name, and in this case I was able to use Word Processor and Word Processor.

NOW, this doesn't mean it's the right way, but it seems to work for me. :rolleyes:

Only Thomas can tell us a good naming convention. It just seems that as long as the Object name and the Caption (in the object) are different, I haven't had any more trouble.

[TigerSoftware]

I did run into this problem before, and then I started naming my objects as below:

Object: Word Processor Object
Caption: Word Processor

When creating an editor in the object, I seem to be able to get away with the same name for both the Property Name and the Caption name, and in this case I was able to use Word Processor and Word Processor.

NOW, this doesn't mean it's the right way, but it seems to work for me. :rolleyes:

Only Thomas can tell us a good naming convention. It just seems that as long as the Object name and the Caption (in the object) are different, I haven't had any more trouble.


Very good rule of thumb Mike.

There are some words that would screw things up. I need to put a check on it to not allow you to save if they contain those words.


The captions are not a problem, it is the object name you need to be careful.

If you do like Mike does, you shouldn't have any problems.

Alton, it seems almost like you had two objects with the same name. Could that have happened. I hope not because I thought I put in a check to stop that.



Thomas

[Alton]

I didn't have two objects with the same name, but I did use the same name for objects that I used for captions for objects. I will repair that. I did have several objects that had same-named editors such as "Notes" and "Image" I didn't use these objects together on the same software projects, but they did coexist within the TSB.

I guess I failed software skool.

Thanks,
Alton

[TigerSoftware]

I didn't have two objects with the same name, but I did use the same name for objects that I used for captions for objects. I will repair that. I did have several objects that had same-named editors such as "Notes" and "Image" I didn't use these objects together on the same software projects, but they did coexist within the TSB.

I guess I failed software skool.

Thanks,
Alton

Note and Image wouldn't be good names. hehe

If you want to start over, you can delete the builder.tsb file. That is your database. It will build a new database when the software starts.


I failed as well, looks like we should all make good money then. ;)



Thomas

[Alton]

I am trying to identify the database file you mentioned. Is it /TigerSoftware.Builder.Core/ or is it one of the two or three others entitiled /TigerSoftware.Builder.Client.UI/ or maybe /TigerSoftware.Builder.Images/

Maybe, I should delete all the above files. I am just trying to understand the database setup. And, I think we need a way of providing a complete database backup on our software.

In the case of the software above, Client and Images were two of the fields within my software.

Thanks,
Alton

[Alton]

I rebuilt one of my products this morning and so far...no problems. Thanks for the advice, guys.
Alton

[TigerSoftware]

I am trying to identify the database file you mentioned. Is it /TigerSoftware.Builder.Core/ or is it one of the two or three others entitiled /TigerSoftware.Builder.Client.UI/ or maybe /TigerSoftware.Builder.Images/

Maybe, I should delete all the above files. I am just trying to understand the database setup. And, I think we need a way of providing a complete database backup on our software.

In the case of the software above, Client and Images were two of the fields within my software.

Thanks,
Alton

It is called Builder.TSB. I will be implementing a database back up for the next release.



Thomas