Re: SET DECIMALS Gotcha

SET DECIMALS TO n only works when SET FIXED is ON. Laurie On 30 July 2017 at 23:38, Gene Wirchenko wrote: > Hello: > > I have just been bitten by SET DECIMALS. (Is there really any use > for this besides making programming just a bit more difficult?) > > I have a

Re: SET DECIMALS Gotcha

This works: x = 1.2345 SET DECIMALS TO 4 SET FIXED ON ? TRANSFORM(x, "999.") Laurie On 31 July 2017 at 11:34, Laurie Alvey wrote: > SET DECIMALS TO n only works when SET FIXED is ON. > > Laurie > > On 30 July 2017 at 23:38, Gene Wirchenko wrote: > >>

Re: SET DECIMALS Gotcha

> > I have just been bitten by SET DECIMALS. (Is there really any use for > this besides making programming just a bit more difficult?) > There may have been, when it was invented in the dBASE days. I believe it does not affect values, only their display. > I have a table with values

RE: SET DECIMALS Gotcha

It makes a difference to the calculated value Only difference between two functions below is one sets decimal to 2 and other to 16. The 16 version produces expected results. ? DectoBase36_2(2176782335), DectoBase36(2176782335), "Expecting ZZ" && Returns "10", "ZZ" ?

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

Hi Mike, Is the application you're referring to Sage PRO ERP (Accpac Pro Series, SBT Pro Series?) If so, we ran into this same problem here with some installations of Outlook 2016. i simply changed the automatically send SMTP commands to prompt for the mail and it worked.

Re: GETFILE() Returns Empty String in Some Cases

Are you declaring your variable as PRIVATE right before you run the GETFILE() command? PRIVATE mypath mypath = GETFILE("csv","Spreadsheet","Open",0,"Open Spreadsheet") Just curious if that is affecting it. -Philip On 7/31/2017 2:19 PM, Ken Dibble wrote: Permissions issue on the folder

Re: GETFILE() Returns Empty String in Some Cases

Are you declaring your variable as PRIVATE right before you run the GETFILE() command? PRIVATE mypath mypath = GETFILE("csv","Spreadsheet","Open",0,"Open Spreadsheet") Just curious if that is affecting it. GAHHH!!! That's it!! Not a PRIVATE declaration, the variable is declared

Re: GETFILE() Returns Empty String in Some Cases

You are welcome Ken, I had the same thing happen to me awhile back that had me stumped! ... sometimes it's the last thing we would consider being the problem. :-) On 7/31/2017 4:04 PM, Ken Dibble wrote: Are you declaring your variable as PRIVATE right before you run the GETFILE() command?

Re: GETFILE() Returns Empty String in Some Cases

Hi All, I think that mypath (or whatever variable you are expecting to contain the returned path) needs to be initialized prior to the GETFILE call... In the code below, make it look like: private mypath mypath= '' mypath = GETFILE(...) Perhaps your standalone application

GETFILE() Returns Empty String in Some Cases

Hi folks, VFP 9 SP1 on Windows 7 Ultimate. I have a process to let the user choose a file. The user opens a .scx form, presses a button to run some code that calls GETFILE(), and when the user has done so, the path and file name are displayed on the form. When I run this form in stand-alone

RE: GETFILE() Returns Empty String in Some Cases

What kind of value does "parms" contain? The actual code is: mypath = GETFILE("csv","Spreadsheet","Open",0,"Open Spreadsheet") In both stand-alone and application mode, this displays the file dialog correctly and pointing to the location that I expect. However, I have also tried it as:

Re: [NF] are you considering Python?

On Jul 31, 2017, at 12:12 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > So a static set of data, then? Like USPS zip codes? Well, not exactly. It could be anything that only makes sense as a complete set. Like parameters to a function, or small data collections. Assume that in your

Re: [NF] are you considering Python?

On 2017-07-29 16:12, Ed Leafe wrote: On Jul 29, 2017, at 8:10 AM, Alan Bourke wrote: Sort of like an immutable collection of objects or primitive types then? Sort of, but there is also the concept that it makes no sense to add or remove an item from that

Re: Outlook 2016 security no longer allowing VFP app to send emails as it did in the past

On 2017-07-31 10:41, Philip Borkholder wrote: Hi Mike, Is the application you're referring to Sage PRO ERP (Accpac Pro Series, SBT Pro Series?) If so, we ran into this same problem here with some installations of Outlook 2016. i simply changed the automatically send SMTP commands to prompt

Re: GETFILE() Returns Empty String in Some Cases

Permissions issue on the folder or on the selected file? I don't see how. In both cases it's me doing the test, on the same computer, with the same folder and file, with the same domain administrator account. Ken Dibble www.stic-cil.org ___

RE: GETFILE() Returns Empty String in Some Cases

What kind of value does "parms" contain? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Dibble Sent: Monday, July 31, 2017 1:27 PM To: profoxt...@leafe.com Subject: GETFILE() Returns Empty String in Some Cases Hi folks, VFP 9 SP1 on

Re: GETFILE() Returns Empty String in Some Cases

Permissions issue on the folder or on the selected file? Fred On Mon, Jul 31, 2017 at 11:03 AM, Ken Dibble wrote: > > What kind of value does "parms" contain? >> > > The actual code is: > > mypath = GETFILE("csv","Spreadsheet","Open",0,"Open Spreadsheet") > > In both

Re: GETFILE() Returns Empty String in Some Cases

On 2017-07-31 16:04, Ken Dibble wrote: GAHHH!!! That's it!! Not a PRIVATE declaration, the variable is declared LOCAL. But in application mode there is a field in an open table with the same name as the variable. I applied the "essential m-dot" to the variable, and that fixed it. That

Re: [NF] are you considering Python?

On 2017-07-31 16:29, Ed Leafe wrote: On Jul 31, 2017, at 12:12 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: So a static set of data, then? Like USPS zip codes? Well, not exactly. It could be anything that only makes sense as a complete set. Like parameters to a function, or small

[NF] FileMaker Pro

A colleague of mine was telling me about how FileMaker Pro can create apps for multiple platforms. From their website (http://www.filemaker.com/products/starter-solutions.html): "Manage tasks on iPad, iPhone, desktop, and the web" Just wanted to poll the ProFox community on their thoughts

Re: SET DECIMALS Gotcha

At 03:34 2017-07-31, Laurie Alvey wrote: SET DECIMALS TO n only works when SET FIXED is ON. I just tried it. It works regardless of the setting of SET FIXED. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: