StrataFrame Forum » StrataFrame Database Deployment Toolkit » Enhancement Requests » Setting Table Properties

Setting Table Properties

Howard Bennett — Mon, 11 Jun 2007 09:56:18 GMT

Maybe I'm missing something...but...I'm setting up a new table. If I haven't set the table structure yet, how can I set the concurrency to "Optimistic Row Version" as it requires a version field?

Would it be possible to add that to the row setup dialog - where there would be a checkbox that says something like "Use this field for optimistic row version?" Maybe over there where the "Primary Key" and "Allow Null" are...

Thanks.

P.S. I'm just starting out here - so - bear with me. You'll probably be tired of hearing from me before I get this first little project done. I'm working on a small app that will read our phone system call log and generate reports - seemed like a simple app to get my feet wet w/SQL, VB.Net and StrataFrame.

RE: Setting Table Properties

Howard Bennett — Mon, 11 Jun 2007 09:56:18 GMT

Okay - that was simple. I should have tried that before posting here.

Thanks for the tip!

RE: Setting Table Properties

Ivan George Borges — Fri, 08 Jun 2007 16:40:34 GMT

Hi Howard.

[quote][b]Howard Bennett (06/08/2007)[/b][hr]Maybe I'm missing something...but...I'm setting up a new table. If I haven't set the table structure yet, how can I set the concurrency to "Optimistic Row Version" as it requires a version field?[/quote]

When I know the name of the field I'm going to use... usually xxxx_version, I just put it there ahead of creating the structure. Otherwise, I just go back afterwards.

[quote]P.S. I'm just starting out here - so - bear with me. You'll probably be tired of hearing from me before I get this first little project done.[/quote]

Hey, never worry about that. Once you get to see all the questions we shoot at the SF team, you will find yourself an angel. :Whistling:

[quote]I'm working on a small app that will read our phone system call log and generate reports - seemed like a simple app to get my feet wet w/SQL, VB.Net and StrataFrame.[/quote]

Good. This sounds like fun. Welcome to the gang. :smooooth: