Re: v13+ - method comments (the Explorer Pane)

2018-05-07 Thread Wayne Stewart via 4D_Tech
Chip, I wrote some code to do that for Foundation it relies on some discipline in creating your header comments of course. // // Project Method: --> ReturnType // Description // Access: Shared // Parameters: // $1 : Type : Description //

Re: v13+ - method comments (the Explorer Pane)

2018-05-07 Thread Dani Beaubien via 4D_Tech
Hi Chip, You can use "METHOD SET COMMENTS” to set the method comments using code. I actually use that call in my Code Analysis component. I have a feature that will look at each method, grab the comment lines at the top of the method until it hits a line that is not a comment, and then put

v13+ - method comments (the Explorer Pane)

2018-05-07 Thread Chip Scheide via 4D_Tech
I have not looked into this much... Is there a way in code to access the method comments (form the Explorer Pane)? I would like to be able to, as a start, copy the actual method header comments into this area. any info appreciated. Thanks Chip --- Gas is for washing parts Alcohol

Re: SQL Date Math

2018-05-07 Thread Richard Wright via 4D_Tech
So it would seem that while there are numerous functions to extract parts of a timestamp into it’s component parts, there is no function to create a date from a piece of text, no date operators nor any date functions by which you can add or subtract days or other component parts of a time

FN call issues

2018-05-07 Thread Chuck Miller via 4D_Tech
Hi all, Environment 4D 15.6 windows server running 32 bit mac 4D running 32 bit version of 4D I log into server using sql and run code that looks like text_txt:=select {fn MethodName() as text from [tablename] into :global variable;” sql login begin sql execute immediate : text_txt; end

Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-07 Thread Nigel Greenlee via 4D_Tech
Allan I think I have the code you refer to. if it is the component that uses vbs scripts(such as application_arrange_windows.vbs)..this might have been something other than Miyakos’ code.. contact me off list and i can put a copy of this on a drop box for you. C_TEXT($1) C_TEXT($2) C_TEXT($3)

Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-07 Thread James Wright via 4D_Tech
Alan, Could you not look at a PHP/Command line solution and script it with LEP? https://phpspreadsheet.readthedocs.io/en/develop/ James. On 7 May 2018 at 09:44, Allan Udy via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi All, > > I'm up the proverbial creek without a paddle... > > Years ago

Options To Put Data Into Existing Excel Spreadsheets?

2018-05-07 Thread Allan Udy via 4D_Tech
Hi All, I'm up the proverbial creek without a paddle... Years ago (v11) we started using the 'Excel Library' component put together (I think) by Keisuke. For the life of me I can no longer find a source version of this (if there ever was one), and it appears that any online link to the