Hi,

Is it possible for me to convert all the database derived relations to "custom relations" in an lgp?

How would I go about it? Manually?

Cheers Andrew

Why do you want to do that?

Many reasons...

One being a client with no control over schema.

I'm afraid I don't understand. Would you please elaborate in more details?

It's not really important why... I just need to do it.

Basically though, the schema we are using is not necessarily going to be consistent. With custom relations, we can ensure the consistency (to a degree).

Cheers Andrew

Can only be done by a plugin which first removes the original relation, then adds the custom one. Or you could try to flag all relations as 'IsCustomRelation' (using the property IsCustomRelation) on the EntityRelation objects with a plugin, though I wouldn't advice it.

Our advice: Use FKs when possible. Try to use a schema which is as perfect as possible, and use that for development. If in production FKs are missing, thats not important.

I have a client that insists on not using a schema (nor FKs).......

bugger eh?

looks like a smart client?

Why does he need a relational database in the first place?

If the discussion is: the client doesn't want FK constraints in the schema, that's not important: you can develop the application with a schema WITH FK constraints, and it is perfectly usable on a schema where all FK constraints are removed: llblgen pro doesn't use meta-data from the schema at runtime, that's all generated into the code.

Thats why it would be handy to be able to save the generated relations as custom relations....

That's not needed at all, coz at runtime the appropriate joins is generated as per the schema defined at design time.

So if the actual production database is missing the FK relations, this won't cause any problem, as the joins will still be created adn executed as they should be. And the queries will be executed successfully.