Triggers and Defaults


Author
Message
Matt Tabone
Matt Tabone
StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)StrataFrame Beginner (32 reputation)
Group: Forum Members
Posts: 16, Visits: 102
I've been experimenting with the DDT. I've imported an existing database but none of the defaults or triggers are brought in.

A brief history...

The database in SQL was created with the VFP upsizing wizard which created triggers for data validation and default value functions that were then used in the appropriate default value box for each field.

I should mention that I'm not sure if we will keep the triggers or look into constraints as a way of validating and the default value functions seem like overkill to me anyways so I'd like to do away with those as well.

I guess I'm more curious if triggers are supposed to come in during an import though DDT or is that not supported yet?

Any feedback would be greatly appreciated.

Matt
Attachments
12-03-2010 3-37-31 PM.png (89 views, 137.00 KB)
12-03-2010 3-39-12 PM.png (96 views, 131.00 KB)
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (2.8K reputation)Strategic Support Team Member (2.8K reputation)Strategic Support Team Member (2.8K reputation)Strategic Support Team Member (2.8K reputation)Strategic Support Team Member (2.8K reputation)Strategic Support Team Member (2.8K reputation)Strategic Support Team Member (2.8K reputation)Strategic Support Team Member (2.8K reputation)Strategic Support Team Member (2.8K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi Matt.

Welcome to the forum.

The support to triggers was added after some of the original imports, so it is possible it was missed. This is on the table to be checked.

But you can deploy your triggers using the DDT, this should be working just fine.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search