[ic] Just a Small Question?!?! (I hope)

Justin Bonds - Hyper Tech justin@hypertech.net
Fri, 12 Jan 2001 19:22:40 -0600


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


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