Mailing List Archive: Just a Small Question?!?! (I hope)

Just a Small Question?!?! (I hope)

Jan 10, 2001, 11:20 PM

Post #1 of 5 (1073 views)

Hi,

I have been working with the demo of Interchange and I absolutely love it.
I can't believe that a great product such as this is free (ok - I think that
it's free), especially since something similar to this, using Windows, would
cost literally thousands!!!

But anyway, the reason that I'm writing is to see if any of you have a
solution to my situation. In the Access area, it allows you to set
permissions. That's great! But, I have tried many different settings but I
can't seem to land on the correct way to accomplish what I'd like to.

So, here it is: I would like to have an employee be able to add a product,
but not be able to edit the product after it has been added. I have removed
the edit check mark and left the Create checked, but obviously it needs the
edit (due to the error message presented) to Create a product. I have
worked with both the Products table, and the options at the top, but to no
success. I have also removed the View check so that perhaps it will let me
just add a product, and not show a product, therefore (in my hopes) not
allowing the employee to edit the product since they can't see it. However,
this too returns an error message.

Do any of you have any great suggestions as to how I could go about
accomplishing the above? Your help would be greatly appreciated.

Thanks!!!

Justin Bonds
Hyper Tech, Inc.

Just a Small Question?!?! (I hope) [ In reply to ]

steveandpatti at wubs

Jan 11, 2001, 6:18 AM

Post #2 of 5 (1069 views)

Permalink

I'm not positive on this but I don't think you can. You have 3 groupings of
permission settings. The first is owner, then group, then world. For each you
have read, write, and execute. To write (add) to a file also gives edit (write)
to that particular person. You are actually editing when you add. THat's initial
thought less than 5 minutes out of bed :)

Steve

Justin Bonds - Hyper Tech wrote:

> Hi,
>
> I have been working with the demo of Interchange and I absolutely love it.
> I can't believe that a great product such as this is free (ok - I think that
> it's free), especially since something similar to this, using Windows, would
> cost literally thousands!!!
>
> But anyway, the reason that I'm writing is to see if any of you have a
> solution to my situation. In the Access area, it allows you to set
> permissions. That's great! But, I have tried many different settings but I
> can't seem to land on the correct way to accomplish what I'd like to.
>
> So, here it is: I would like to have an employee be able to add a product,
> but not be able to edit the product after it has been added. I have removed
> the edit check mark and left the Create checked, but obviously it needs the
> edit (due to the error message presented) to Create a product. I have
> worked with both the Products table, and the options at the top, but to no
> success. I have also removed the View check so that perhaps it will let me
> just add a product, and not show a product, therefore (in my hopes) not
> allowing the employee to edit the product since they can't see it. However,
> this too returns an error message.
>
> Do any of you have any great suggestions as to how I could go about
> accomplishing the above? Your help would be greatly appreciated.
>
> Thanks!!!
>
> Justin Bonds
> Hyper Tech, Inc.
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users

--
=========================================================
WDI Steve & Patti Getzinger
702 Lincolnway West steveandpatti@wubs.org
South Bend, IN 46616 http://www.wubs.org/
219-287-4700 (Main Office) 317-535-0239 (Direct Line)
=========================================================

Just a Small Question?!?! (I hope) [ In reply to ]

mikeh at minivend

Jan 11, 2001, 1:17 PM

Post #3 of 5 (1065 views)

Permalink

Quoting Justin Bonds - Hyper Tech (justin@hypertech.net):
> Hi,
>
> I have been working with the demo of Interchange and I absolutely love it.
> I can't believe that a great product such as this is free (ok - I think that
> it's free), especially since something similar to this, using Windows, would
> cost literally thousands!!!
>
> But anyway, the reason that I'm writing is to see if any of you have a
> solution to my situation. In the Access area, it allows you to set
> permissions. That's great! But, I have tried many different settings but I
> can't seem to land on the correct way to accomplish what I'd like to.
>
> So, here it is: I would like to have an employee be able to add a product,
> but not be able to edit the product after it has been added. I have removed
> the edit check mark and left the Create checked, but obviously it needs the
> edit (due to the error message presented) to Create a product. I have
> worked with both the Products table, and the options at the top, but to no
> success. I have also removed the View check so that perhaps it will let me
> just add a product, and not show a product, therefore (in my hopes) not
> allowing the employee to edit the product since they can't see it. However,
> this too returns an error message.
>
> Do any of you have any great suggestions as to how I could go about
> accomplishing the above? Your help would be greatly appreciated.
>

There isn't a standard way. With 4.7.x and the autonumbering setup,
it will be possible, but in 4.6 you cannot.

It would be possible to do with a bit of custom code on a custom
entry screen, of course. Don't have time to show exactly how, but
it would involve setting the table_control hash in the access database
to pre-assign a key to the user. For instance, if you did:

[data
table=userdb
col=table_control
key="[data session username]"
value="{ products => { yes_keys => '00001' } }"
]

The user would be able to add 00001 (and edit it). If you then reset the
value of table_control to remove that, they couldn't edit anything.

In 4.7.x we will have the ability to allow an insert when the key field
is autonumbered, without the ability to edit an existing record. I will look
at allowing this with a preset key as well, though the way to do that doesn't
come readily to mind.

--
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>

Being against torture ought to be sort of a bipartisan thing.
-- Karl Lehenbauer

Just a Small Question?!?! (I hope) [ In reply to ]

justin at hypertech

Jan 12, 2001, 11:05 AM

Post #4 of 5 (1065 views)

Permalink

Hi Mike,

Thank you very much for the reply to my inquiry. I have been a Windows user
for many years, but I'm happy to see what great software is available on the
Linux OS. In addition, it is also nice to see a company that actually
provides a little insight into accomplishing a desired task . . .

Thanks!!!

Justin
Hyper Tech, Inc.

HA HA HA HA - Hilarious -> -> -> Being against torture ought to be sort of a
bipartisan thing. -- Karl Lehenbauer

-----Original Message-----
From: interchange-users-admin@lists.akopia.com
[mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Mike Heins
Sent: Thursday, January 11, 2001 2:18 PM
To: interchange-users@minivend.akopia.com
Subject: Re: [ic] Just a Small Question?!?! (I hope)

Quoting Justin Bonds - Hyper Tech (justin@hypertech.net):
> Hi,
>
> I have been working with the demo of Interchange and I absolutely love it.
> I can't believe that a great product such as this is free (ok - I think
that
> it's free), especially since something similar to this, using Windows,
would
> cost literally thousands!!!
>
> But anyway, the reason that I'm writing is to see if any of you have a
> solution to my situation. In the Access area, it allows you to set
> permissions. That's great! But, I have tried many different settings but
I
> can't seem to land on the correct way to accomplish what I'd like to.
>
> So, here it is: I would like to have an employee be able to add a
product,
> but not be able to edit the product after it has been added. I have
removed
> the edit check mark and left the Create checked, but obviously it needs
the
> edit (due to the error message presented) to Create a product. I have
> worked with both the Products table, and the options at the top, but to no
> success. I have also removed the View check so that perhaps it will let
me
> just add a product, and not show a product, therefore (in my hopes) not
> allowing the employee to edit the product since they can't see it.
However,
> this too returns an error message.
>
> Do any of you have any great suggestions as to how I could go about
> accomplishing the above? Your help would be greatly appreciated.
>

There isn't a standard way. With 4.7.x and the autonumbering setup,
it will be possible, but in 4.6 you cannot.

It would be possible to do with a bit of custom code on a custom
entry screen, of course. Don't have time to show exactly how, but
it would involve setting the table_control hash in the access database
to pre-assign a key to the user. For instance, if you did:

[data
table=userdb
col=table_control
key="[data session username]"
value="{ products => { yes_keys => '00001' } }"
]

The user would be able to add 00001 (and edit it). If you then reset the
value of table_control to remove that, they couldn't edit anything.

In 4.7.x we will have the ability to allow an insert when the key field
is autonumbered, without the ability to edit an existing record. I will look
at allowing this with a preset key as well, though the way to do that
doesn't
come readily to mind.

--
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>

Being against torture ought to be sort of a bipartisan thing.
-- Karl Lehenbauer

_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users