RE: Checking for All-Different Characters

2016-07-17 Thread Darren
This will give you all the dates that have a unique set of digits 1900 to - probably more efficient ways to do it but this runs sub second on my machine and spits out 44,640 values. Have not done any testing or checking but it'll give you at least an idea. CREATE CURSOR w_dates (uniquedate

RE: Checking for All-Different Characters

2016-07-17 Thread Darren
Maybe something like .. STORE CAST(0 AS I) TO lnCheck lcDtString = STRCONV(DTOS(DATE()), 12) =ALINES(laValues, m.lcDtString, 0, CHR(0)) FOR lnPosn = 1 TO 8 STORE VAL(laValues(m.lnPosn)) TO lnVal ? lnVal IF BITTEST(m.lnCheck, m.lnVal) *- Have a duplicate number - do what

Grid scrollbars

2016-07-17 Thread Sytze de Boer
Well, I have this small package working on a tablet, almost. (And I shouldn't say this without mentioning the great help from Bernard Bout) One aspect is annoying me though. It's almost impossible to scroll my grid. For the moment I've placed 2 big arrows/Command buttons on the Form The width of

Re: Checking for All-Different Characters

2016-07-17 Thread Charlie
I may not be on-target with what you want but If you just want to increment increase/decrease dates by 1 I would suggest doing date math. dDateVal = dDaveVal + 1 If you have to work with a string as a source, you could convert it to date first. For example cteststr = "2019-12-31"

RE: Generate a report in local language (India)

2016-07-17 Thread José Enrique Llopis
My Real Estate CRM prints reports in Russian and chinese, it works printing a RTF with a general field, you can find a lot of samples of how to print RTF content in a report in foxite. To save the rtf data I use the richtext activeX and content is stored in a general field. You can download a

Re: Mscomm32.ocx on Windows 7?

2016-07-17 Thread joceravolo
Thanks Tracy and Ted, The link Ted provided was enough to register the ocx. Now I'll test the program. Cheers! Jose. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post

Checking for All-Different Characters

2016-07-17 Thread Gene Wirchenko
Hello: I write a logic/math puzzle each week. They appear in my blog (http://genew.ca/) and two local newspapers. Here is the latest problem: "Consider a date in -MM-DD format. What is the next date where all eight digits will be different?" I solved this by

Re: Mscomm32.ocx on Windows 7?

2016-07-17 Thread Ted Roche
On Sun, Jul 17, 2016 at 10:12 AM, wrote: > Hi All, > Did you ever use the Mscomm32.ocx that ships with VFP9 on Windows 7?I wonder > if that's possible. > Thanks, > Jose. > It is possible. Of course, it depends on what it is you're trying to accomplish. There are some

Re: Mscomm32.ocx on Windows 7?

2016-07-17 Thread Tracy Pearson
If memory serves, I used it to mock an SMTP server for testing. Works in Windows 7 and 8. I've not tested it in Windows 10. On July 17, 2016 10:12:55 AM EDT, jocerav...@yahoo.com wrote: >Hi All, >Did you ever use the Mscomm32.ocx that ships with VFP9 on Windows 7?I >wonder if that's possible.

Re: Generate a report in local language (India)

2016-07-17 Thread Ted Roche
VFP was one of the first MS apps to support internationalization, but it was designed to work with the multi-byte character set (MBCS) and Code Pages that were the Microsoft solution, instead of the then-nascent Unicode efforts. Consequently, Unicode support in VFP is difficult and not the native

Mscomm32.ocx on Windows 7?

2016-07-17 Thread joceravolo
Hi All, Did you ever use the Mscomm32.ocx that ships with VFP9 on Windows 7?I wonder if that's possible. Thanks, Jose. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post

Re: Generate a report in local language (India)

2016-07-17 Thread Man-wai Chang
Unicode? Um... Crystal Report? On Sun, Jul 17, 2016 at 7:18 PM, Ajoy Khaund wrote: > Not sure about it. > I think I will need a field which will be able to store the data in the > format > which the local font will be able to read (in unicode in a blog field > maybe). --

Re: Generate a report in local language (India)

2016-07-17 Thread Ajoy Khaund
Not sure about it. I think I will need a field which will be able to store the data in the format which the local font will be able to read (in unicode in a blog field maybe). On Sun, Jul 17, 2016 at 4:40 PM, Man-wai Chang wrote: > You can use IIF(m.language="E", "English",

Re: Generate a report in local language (India)

2016-07-17 Thread Man-wai Chang
You can use IIF(m.language="E", "English", :"Assamese") where m.language is a global variable. On Sat, Jul 16, 2016 at 11:26 PM, Ajoy Khaund wrote: > Fonts for this local language are available. Is it possible to change > say the Gross Salary from English to another language