The app is a jungle of unrelated (to FKV writes) code. It also has a sub for getting data from a 3rd party db via odbc that will fail if someone else tries to use at their site. We've moved that data to a ud table so I'm scheduled to revise the app anyway.Â
I'll strip out the non-essential stuff (to FKV data writes) & share.
Rob
________________________________
From: Steven Gotschall <sgotschall@...>
To: vantage@yahoogroups.com
Sent: Friday, May 22, 2009 8:52:53 AM
Subject: Re: [Vantage] Question on Data Fields
Hey Rob, how about uploading your app to the files area of this users group? I know I would be interested in seeing your solution and I'd bet there are a lot of others who would also like to know how its done.
____________ _________ _________ __
From: Robert Brown <robertb_versa@ yahoo.com>
To: vantage@yahoogroups .com
Sent: Thursday, May 21, 2009 6:37:52 PM
Subject: Re: [Vantage] Question on Data Fields
Ping away :)
Rob
____________ _________ _________ __
From: Vic Drecchio <vic.drecchio@ timco.aero>
To: vantage@yahoogroups .com
Sent: Thursday, May 21, 2009 3:33:41 PM
Subject: RE: [Vantage] Question on Data Fields
Wow, really? Slick. I thought they were always read only, hence the
name Foreign Key *View*.
I'll keep that in mind and if I ever need to do that I'll ping you.
Thanks a lot.
Vic
-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Robert Brown
Sent: Thursday, May 21, 2009 12:10 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Question on Data Fields
Vic, If you add the necessary assemblies (and support code for the
adapter), you can write to FKVs. I've got an app doing this now.
Rob
____________ _________ _________ __
From: Vic Drecchio <vic.drecchio@ timco.aero>
To: vantage@yahoogroups .com
Sent: Thursday, May 21, 2009 8:19:28 AM
Subject: RE: [Vantage] Question on Data Fields
There is no way to write to a FKV. All FKV's are read only.
I've never heard of it not working in a calc, though.
-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of gmack110256
Sent: Thursday, May 21, 2009 8:16 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Question on Data Fields
I have set up a FKV in the Sales Order Form to bring in the Part's Net
Weight. When I look at any of the fields brought in FKV (including the
number fields) they are all marked set as Read Only. Is there any way
to change them to not be read only?
It appears that if the field is Read Only it will not work if you try to
use it in a calculation.
Thank You
Gene Mack
Johnson Systems Inc.
------------ --------- --------- ------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
[Non-text portions of this message have been removed]
------------ --------- --------- ------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
I have set up a FKV in the Sales Order Form to bring in the Part's Net Weight. When I look at any of the fields brought in FKV (including the number fields) they are all marked set as Read Only. Is there any way to change them to not be read only?
It appears that if the field is Read Only it will not work if you try to use it in a calculation.
I have set up a FKV in the Sales Order Form to bring in the Part's Net
Weight. When I look at any of the fields brought in FKV (including the
number fields) they are all marked set as Read Only. Is there any way
to change them to not be read only?
It appears that if the field is Read Only it will not work if you try to
use it in a calculation.
Thank Vic, My Bad I had it set up wrong when I tried it.
Thank You
Gene
--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> There is no way to write to a FKV. All FKV's are read only.
>
> I've never heard of it not working in a calc, though.
>
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of gmack110256
> Sent: Thursday, May 21, 2009 8:16 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Question on Data Fields
>
> I have set up a FKV in the Sales Order Form to bring in the Part's Net
> Weight. When I look at any of the fields brought in FKV (including the
> number fields) they are all marked set as Read Only. Is there any way
> to change them to not be read only?
>
> It appears that if the field is Read Only it will not work if you try to
> use it in a calculation.
>
> Thank You
>
> Gene Mack
> Johnson Systems Inc.
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
There is (as long as you haven't set up security roles for these users that strictly prevent them from editing the data - or accessing the BO methods to do so), but do you really want sales people editing part (material planning/engineering/inventory control and cost) related data from sales entry?
If you think it is appropriate, email me and I'll give you some code that will execute on application start up to make specific fields read/write. (You will be changing the default properties of these data fields via a pretty simple & handy SetExtendedProperties subroutine...)
Rob
________________________________
From: gmack110256 <genemack@...>
To: vantage@yahoogroups.com
Sent: Thursday, May 21, 2009 8:15:45 AM
Subject: [Vantage] Question on Data Fields
I have set up a FKV in the Sales Order Form to bring in the Part's Net Weight. When I look at any of the fields brought in FKV (including the number fields) they are all marked set as Read Only. Is there any way to change them to not be read only?
It appears that if the field is Read Only it will not work if you try to use it in a calculation.
Thank You
Gene Mack
Johnson Systems Inc.
[Non-text portions of this message have been removed]
Vic, If you add the necessary assemblies (and support code for the adapter), you can write to FKVs. I've got an app doing this now.
Rob
________________________________
From: Vic Drecchio <vic.drecchio@...>
To: vantage@yahoogroups.com
Sent: Thursday, May 21, 2009 8:19:28 AM
Subject: RE: [Vantage] Question on Data Fields
There is no way to write to a FKV. All FKV's are read only.
I've never heard of it not working in a calc, though.
-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of gmack110256
Sent: Thursday, May 21, 2009 8:16 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Question on Data Fields
I have set up a FKV in the Sales Order Form to bring in the Part's Net
Weight. When I look at any of the fields brought in FKV (including the
number fields) they are all marked set as Read Only. Is there any way
to change them to not be read only?
It appears that if the field is Read Only it will not work if you try to
use it in a calculation.
Thank You
Gene Mack
Johnson Systems Inc.
------------ --------- --------- ------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
[Non-text portions of this message have been removed]
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Thursday, May 21, 2009 11:10 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Question on Data Fields
Vic, If you add the necessary assemblies (and support code for the
adapter), you can write to FKVs. I've got an app doing this now.
Rob
________________________________
From: Vic Drecchio <vic.drecchio@...
<mailto:vic.drecchio%40timco.aero> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, May 21, 2009 8:19:28 AM
Subject: RE: [Vantage] Question on Data Fields
There is no way to write to a FKV. All FKV's are read only.
I've never heard of it not working in a calc, though.
-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of gmack110256
Sent: Thursday, May 21, 2009 8:16 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Question on Data Fields
I have set up a FKV in the Sales Order Form to bring in the Part's Net
Weight. When I look at any of the fields brought in FKV (including the
number fields) they are all marked set as Read Only. Is there any way
to change them to not be read only?
It appears that if the field is Read Only it will not work if you try to
use it in a calculation.
Thank You
Gene Mack
Johnson Systems Inc.
------------ --------- --------- ------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Wow, really? Slick. I thought they were always read only, hence the
name Foreign Key *View*.
I'll keep that in mind and if I ever need to do that I'll ping you.
Thanks a lot.
Vic
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Thursday, May 21, 2009 12:10 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Question on Data Fields
Vic, If you add the necessary assemblies (and support code for the
adapter), you can write to FKVs. I've got an app doing this now.
Rob
________________________________
From: Vic Drecchio <vic.drecchio@...>
To: vantage@yahoogroups.com
Sent: Thursday, May 21, 2009 8:19:28 AM
Subject: RE: [Vantage] Question on Data Fields
There is no way to write to a FKV. All FKV's are read only.
I've never heard of it not working in a calc, though.
-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of gmack110256
Sent: Thursday, May 21, 2009 8:16 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Question on Data Fields
I have set up a FKV in the Sales Order Form to bring in the Part's Net
Weight. When I look at any of the fields brought in FKV (including the
number fields) they are all marked set as Read Only. Is there any way
to change them to not be read only?
It appears that if the field is Read Only it will not work if you try to
use it in a calculation.
Thank You
Gene Mack
Johnson Systems Inc.
------------ --------- --------- ------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
________________________________
From: Vic Drecchio <vic.drecchio@...>
To: vantage@yahoogroups.com
Sent: Thursday, May 21, 2009 3:33:41 PM
Subject: RE: [Vantage] Question on Data Fields
Wow, really? Slick. I thought they were always read only, hence the
name Foreign Key *View*.
I'll keep that in mind and if I ever need to do that I'll ping you.
Thanks a lot.
Vic
-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Robert Brown
Sent: Thursday, May 21, 2009 12:10 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Question on Data Fields
Vic, If you add the necessary assemblies (and support code for the
adapter), you can write to FKVs. I've got an app doing this now.
Rob
____________ _________ _________ __
From: Vic Drecchio <vic.drecchio@ timco.aero>
To: vantage@yahoogroups .com
Sent: Thursday, May 21, 2009 8:19:28 AM
Subject: RE: [Vantage] Question on Data Fields
There is no way to write to a FKV. All FKV's are read only.
I've never heard of it not working in a calc, though.
-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of gmack110256
Sent: Thursday, May 21, 2009 8:16 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Question on Data Fields
I have set up a FKV in the Sales Order Form to bring in the Part's Net
Weight. When I look at any of the fields brought in FKV (including the
number fields) they are all marked set as Read Only. Is there any way
to change them to not be read only?
It appears that if the field is Read Only it will not work if you try to
use it in a calculation.
Thank You
Gene Mack
Johnson Systems Inc.
------------ --------- --------- ------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
[Non-text portions of this message have been removed]
------------ --------- --------- ------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
[Non-text portions of this message have been removed]
Hey Rob, how about uploading your app to the files area of this users group? I know I would be interested in seeing your solution and I'd bet there are a lot of others who would also like to know how its done.
________________________________
From: Robert Brown <robertb_versa@...>
To: vantage@yahoogroups.com
Sent: Thursday, May 21, 2009 6:37:52 PM
Subject: Re: [Vantage] Question on Data Fields
Ping away :)
Rob
____________ _________ _________ __
From: Vic Drecchio <vic.drecchio@ timco.aero>
To: vantage@yahoogroups .com
Sent: Thursday, May 21, 2009 3:33:41 PM
Subject: RE: [Vantage] Question on Data Fields
Wow, really? Slick. I thought they were always read only, hence the
name Foreign Key *View*.
I'll keep that in mind and if I ever need to do that I'll ping you.
Thanks a lot.
Vic
-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of Robert Brown
Sent: Thursday, May 21, 2009 12:10 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Question on Data Fields
Vic, If you add the necessary assemblies (and support code for the
adapter), you can write to FKVs. I've got an app doing this now.
Rob
____________ _________ _________ __
From: Vic Drecchio <vic.drecchio@ timco.aero>
To: vantage@yahoogroups .com
Sent: Thursday, May 21, 2009 8:19:28 AM
Subject: RE: [Vantage] Question on Data Fields
There is no way to write to a FKV. All FKV's are read only.
I've never heard of it not working in a calc, though.
-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of gmack110256
Sent: Thursday, May 21, 2009 8:16 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Question on Data Fields
I have set up a FKV in the Sales Order Form to bring in the Part's Net
Weight. When I look at any of the fields brought in FKV (including the
number fields) they are all marked set as Read Only. Is there any way
to change them to not be read only?
It appears that if the field is Read Only it will not work if you try to
use it in a calculation.
Thank You
Gene Mack
Johnson Systems Inc.
------------ --------- --------- ------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
[Non-text portions of this message have been removed]
------------ --------- --------- ------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups. yahoo.com/ group/vantage/ files/.
(2) To search through old msg's goto:
http://groups. yahoo.com/ group/vantage/ messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]