Re: Difference between H and T table on SQL 2005

2008-04-14 Thread Rick Cook
t; *Sent:* Monday, April 14, 2008 11:23 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Difference between H and T table on SQL 2005 > > ** One way would be to create a view of that form and give them access to > just the view. That way, you don't have to mess with the perms on the m

Re: Difference between H and T table on SQL 2005

2008-04-14 Thread tricky maybe
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Monday, April 14, 2008 11:23 AM To: arslist@ARSLIST.ORG Subject: Re: Difference between H and T table on SQL 2005 ** One way would be to create a view of that form and give them access to just the

Re: Difference between H and T table on SQL 2005

2008-04-14 Thread Rick Cook
02 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Difference between H and T table on SQL 2005 > > ** > Thanks Rick for clearing that out. I didn't really paid attention to the > data on the table and I was just looking at the number of rows. My mistake. > > *From:* Action R

Re: Difference between H and T table on SQL 2005

2008-04-14 Thread tricky maybe
AM To: arslist@ARSLIST.ORG Subject: Re: Difference between H and T table on SQL 2005 ** Thanks Rick for clearing that out. I didn't really paid attention to the data on the table and I was just looking at the number of rows. My mistake. From: Action Request System discussion li

Re: Difference between H and T table on SQL 2005

2008-04-14 Thread tricky maybe
46 AM To: arslist@ARSLIST.ORG Subject: Re: Difference between H and T table on SQL 2005 ** The H tables store Status History. As such, they've been around for a VERY long time. Not all forms contain an H table, but all Regular forms do - basically any form that contains the core fi

Re: Difference between H and T table on SQL 2005

2008-04-14 Thread Rick Cook
The H tables store Status History. As such, they've been around for a VERY long time. Not all forms contain an H table, but all Regular forms do - basically any form that contains the core field Status (Field ID 7). Rick On Mon, Apr 14, 2008 at 10:37 AM, tricky maybe <[EMAIL PROTECTED]> wrote:

Difference between H and T table on SQL 2005

2008-04-14 Thread tricky maybe
I'm just curious what the difference is between the T table and the H table on SQL 2005. I don't think the H table existed before we upgraded from SQL 2000. They sure look the same for me but I'm not a SQL guy so I'm not sure why there's an H table now. They both look the same with the same