Electronic filing

[Larry Gordon]

As an Alpha rookie, I'm always concerned as to the sensibility of my queries... I would like to put a column in a browse that would display a Word or Excel or tiff icon etc. Clicking on the icon would then open a specific file, relevant to that particular browse row. Can I easily do this? Thanks in advance, Larry Gordon

[jkletrovets]

Re: Electronic filing

Larry

Yep, that is easily done. Check out this from the help file.

http://support.alphasoftware.com/alp...SYS_OPEN().htm

Regards,

Jeff

[Larry Gordon]

Re: Electronic filing

Jeff
Many thanks - it works fine. I used the new V9 Form Browse controls to create a Generic Action button and then entered the SYS_OPEN command and appropriate path and file name.

What I should also have asked in my original question, is how do I allow the end user to upload his chosen path and file name into the button's script?

Kind regards
Larry

[Stan Mathews]

Re: Electronic filing

What I should also have asked in my original question, is how do I allow the end user to upload his chosen path and file name into the button's script?

Store the path and file name in table fields. Allow the user to modify them. Make the script reference the table fields' contents.

[jkletrovets]

Re: Electronic filing

Right along with what Stan said.....this is a snippet of code I use to get part way there. After this you can just set the field contents to vsourcefilename and you should be set.

Dim vsourcefilename as C
vsourceFileName = ui_get_file("Pick a file to load.", "*.*",alltrim(gvrefdocsrcdir)+"*.*", "X")
'If Source is blank then end
if (sourceFileName = "") then
    end
end if

[Larry Gordon]

Re: Electronic filing

Once again I am overawed by the level of help and support that I receive from the Alpha world. I sincerely hope that by the time my own posts get into three figures that I too will be able to help some other unfortunate alpha rookie in the manner in which I have been helped.
Kind regards
Larry Gordon

[jkletrovets]

Re: Electronic filing

Hi Larry

Glad I could help.

I agree with you......this board in unbelievable in how much help is available here and the willingness at which it is given! Just look at the number of posts by Stan Mathews and Tom Cone!

Regards,

Jeff

[Larry Gordon]

Re: Electronic filing

Hi Jeff - I'm partway there! I now have a button in a browse which references a field in an adjacent column in the same row, which contains a path and filename. On pushing the button the appropriate file is opened.

I think that your code is going to allow me to select the file and path to display in that field, but I'm not cetain - this would be excellent! But I have so far failed to get it working. Can you please advise me as to where I should place your code, as I think this may be my problem. I was thinking of adding another button which would allow selection of the appropriate path and file.

Kind regards

Larry

[MikeC]

Re: Electronic filing

Hi Larry,
Your problem with Jeff's script could be what I have in red.

 
Dim vsourcefilename as C
vsourceFileName = ui_get_file("Pick a file to load.", "*.*",alltrim(gvrefdocsrcdir)+"*.*", "X")
'If Source is blank then end
[COLOR=red]if (sourceFileName = "")[/COLOR] then
    end
end if

I think it maybe should be

 
Dim vsourcefilename as C
vsourceFileName = ui_get_file("Pick a file to load.", "*.*",alltrim(gvrefdocsrcdir)+"*.*", "X")
'If Source is blank then end
if [COLOR=red]v[/COLOR][COLOR=blue]sourceFileName = ""[/COLOR] then
    end
end if

Add the "v" in front and take out parenthesis.

Hope I'm right!