Re: AW: Custom Scrollbar
Hmm, OK. :( Frank. Frank Cazabon On 22/03/2019 04:54 PM, Gene Wirchenko wrote: At 10:21 2019-03-22, Frank Cazabon wrote: Gene, did you ever give this a good testing? Nope. Got onto other things. [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/72b05437-a9f2-6833-49e3-76c889b9d...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
If you are looping for a qualified good working scrollbar go for Carlos Aloitti’s class. Koen Op vr 22 mrt. 2019 om 16:55 schreef Gene Wirchenko > At 10:21 2019-03-22, Frank Cazabon wrote: > >Gene, did you ever give this a good testing? > > Nope. Got onto other things. > > [snip] > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACUu1SvVSoa3Ys9QK+HzyrJiiAcq4P_fCa6sLuT0Wo=euvd...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 10:21 2019-03-22, Frank Cazabon wrote: Gene, did you ever give this a good testing? Nope. Got onto other things. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f91bbbd668c5f1b2eea9e9a4da87ecd9@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
Gene, did you ever give this a good testing? Frank. Frank Cazabon On 14/01/2019 07:56 PM, Frank Cazabon wrote: On 14/01/2019 07:27 PM, Gene Wirchenko wrote: At 06:06 2019-01-10, Frank Cazabon wrote: Gene, I've knocked up a quick demo which I hope meets your requirements and emailed you the link to the download on google drive. I was beat last week, and did not get to it. I have a couple days off (today and tomorrow) and am digging into it. Preliminary: I should have stated code only. Never mind. Converting it to code only will help me learn. You did state code only but as I said in my email, I think using code only in VFP doesn't make the best use of the tool and you may be able to find something to convert it if you really want to. To each his own. I do not use database containers. I hope this does not break your solution. I was concerned because of the validation rules, but this, at least, does not appear to be an issue. The database container is not important to the solution. FWIW I don't use dbfs any more as sql server and other databases are so much more powerful and stable. Focus should be set on a control in the grid at the start. I assume that there is a simple statement to do that. Yes, just setfocus() to the column in the grid. Validation of each column is not done at the start of row-level validation. This is important. What if the data displayed is invalid? I may be able to get this myself. You gave very limited specs, I assumed that the data can only be entered using this screen so it is impossible to get invalid data in :) You can move the individual column validations from the textbox.valid() and put them in their own methods so you can call them from multiple places and call when you see fit. I have not done much yet, but this looks as if it works. So how did I miss it? I think bad documentation is to blame, but while converting it to code, I ought to find out. I think I probably got snookered by Before/AfterRowColChange(). [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/dc8346ef-99e4-509e-ec04-4ff0ce45c...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
On 14/01/2019 07:27 PM, Gene Wirchenko wrote: At 06:06 2019-01-10, Frank Cazabon wrote: Gene, I've knocked up a quick demo which I hope meets your requirements and emailed you the link to the download on google drive. I was beat last week, and did not get to it. I have a couple days off (today and tomorrow) and am digging into it. Preliminary: I should have stated code only. Never mind. Converting it to code only will help me learn. You did state code only but as I said in my email, I think using code only in VFP doesn't make the best use of the tool and you may be able to find something to convert it if you really want to. To each his own. I do not use database containers. I hope this does not break your solution. I was concerned because of the validation rules, but this, at least, does not appear to be an issue. The database container is not important to the solution. FWIW I don't use dbfs any more as sql server and other databases are so much more powerful and stable. Focus should be set on a control in the grid at the start. I assume that there is a simple statement to do that. Yes, just setfocus() to the column in the grid. Validation of each column is not done at the start of row-level validation. This is important. What if the data displayed is invalid? I may be able to get this myself. You gave very limited specs, I assumed that the data can only be entered using this screen so it is impossible to get invalid data in :) You can move the individual column validations from the textbox.valid() and put them in their own methods so you can call them from multiple places and call when you see fit. I have not done much yet, but this looks as if it works. So how did I miss it? I think bad documentation is to blame, but while converting it to code, I ought to find out. I think I probably got snookered by Before/AfterRowColChange(). [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f9e7b51d-69ec-a25a-1719-dc09072c3...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 06:06 2019-01-10, Frank Cazabon wrote: Gene, I've knocked up a quick demo which I hope meets your requirements and emailed you the link to the download on google drive. I was beat last week, and did not get to it. I have a couple days off (today and tomorrow) and am digging into it. Preliminary: I should have stated code only. Never mind. Converting it to code only will help me learn. I do not use database containers. I hope this does not break your solution. I was concerned because of the validation rules, but this, at least, does not appear to be an issue. Focus should be set on a control in the grid at the start. I assume that there is a simple statement to do that. Validation of each column is not done at the start of row-level validation. This is important. What if the data displayed is invalid? I may be able to get this myself. I have not done much yet, but this looks as if it works. So how did I miss it? I think bad documentation is to blame, but while converting it to code, I ought to find out. I think I probably got snookered by Before/AfterRowColChange(). [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/82033ed3938509bd19ec0df89bd6b3e3@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
At 12:47 2019-01-10, Frank Cazabon wrote: All columns have different validation rules. There is no input mask to force the text column to only accept numbers. You can put alphabetic characters in there too. Then it uses the rule specified earlier by Gene. You can download it and look at it and read Gene's specification in his last message here. My spec was never intended to be bullet-proof, just adequate for a very basic but non-trivial grid. "non-trivial" means that it shows working and workable implementation some things of importance to me. I intend that numeric values be entered for numeric columns. Really, this is a simple example. Yes, I would have input masks in app code. Yes, I would have many other things as well. This is not app code. Anyone thinking that this code would be of use in a real app is overthinking the situation. Run and scream after looking at the code if you want. Print out a copy of the code, and burn it. Whatever you want. Thanks for you time, Frank and anyone else who has contributed. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/463275b5d647e6f1edf0e73149185b5d@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
At 12:39 2019-01-10, Frank Cazabon wrote: What control? The text? This is a quick knock up for Gene to check out, all I've put in is what he specifically asked for so it's a bare minimum thing. ... and that is exactly what I want. I want something simple enough that I can fairly easily rip it to pieces figuring out how it works but not so simplistic that it does not scale to something useful. I will check it out. Maybe, I will have missed a couple things that will come up later and need a bit more help, but maybe, at that point, I will be able to handle them myself. I do not expect people to put in a lot of work on this. I just need help out of the pit. I would be pleased to find that I can get Grid working as I need. I do not believe it yet, but I have always been willing. Remember that ~15 years some have mentioned? This is the first time I have gotten some Grid code to chew on. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/b1ed754e8aac86bb0df894138918765c@mtlp84 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
At 12:23 2019-01-10, Richard Kaye wrote: Control not constrained to digits only? thetext is a character string. It is not constrained at all except by the validation that it can not be "". evennr and weirdnr are integers so digits (and signs) only. [snipped previous] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bd0b46f6bdabe4ec67dbdb4e60afb514@mtlp83 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 08:10 2019-01-10, Koen Piller wrote: Frank, Downloading and installing the file Gene.zip was easy done succesfull. The form: I am not able to enter a value in column #Weird if I have entered 8 in the column text. Is that how it is supposed to work? I came up with some simple rules to test validation. They are arbitrary, but they are also simple. (No sense having them be complicated for a proof of concept.) Regarding weirdnr: 1) weirdnr is supposed to be divisible by 3. 2) It is also supposed to have the same even-oddness as the first character of thetext. Example 1: With thetext of "An example", "A" has a value of 65 which is odd, so weirdnr must be odd. Since it must also be divisible by 3, it must be one of {3, 9, 15, ...} or the negative of one of them. Example 2: With thetext of "Brilliant or bad example", "B" has a value of 66 which is even, so weirdnr must be even. Since it must also be divisible by 3, it must be one of {0, 6, 12, 18, ...} or the negative of one of them. The above assumes Frank implemented correctly what I asked for, and for that matter, that I wrote what I intended. I have just gotten home from work -- I am working full-time outside of IT -- and have not looked at his code yet. I might not get to look at it in detail for a few days. But I will. This is the first potential grid example that works for my value of "works". If I have been overlooking something, I want to know about it. Mind you, I am going to try to break it, too. I want something solid and to know that I have something solid. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/6672ca8cca1bbfc4a0a209cc6ae65401@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
Ah. OK. I was just tossing out a possible reason why it works for you but not Koen and "bad" data entry is the first thing that came to mind. Actually reviewing the code would mean I would have to ignore the day job... 😊 -- rk -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: Thursday, January 10, 2019 3:48 PM To: profoxt...@leafe.com Subject: RE: AW: Custom Scrollbar All columns have different validation rules. There is no input mask to force the text column to only accept numbers. You can put alphabetic characters in there too. Then it uses the rule specified earlier by Gene. You can download it and look at it and read Gene's specification in his last message here. On 10 January 2019 16:43:54 GMT-04:00, Richard Kaye wrote: >The column with the valid rule. Is it only allowing digits to be >entered? I would expect a data type mismatch if it was allowing >anything other than digits. Maybe Koen is trying to type alpha >characters? > >-- > >rk > >-Original Message- >From: ProfoxTech On Behalf Of Frank >Cazabon >Sent: Thursday, January 10, 2019 3:40 PM >To: profoxt...@leafe.com >Subject: RE: AW: Custom Scrollbar > >What control? The text? > >This is a quick knock up for Gene to check out, all I've put in is what >he specifically asked for so it's a bare minimum thing. > >On 10 January 2019 16:23:50 GMT-04:00, Richard Kaye > wrote: >>Control not constrained to digits only? >> >>-- >> >>rk >> >>-Original Message- >>From: ProfoxTech On Behalf Of Frank >>Cazabon >>Sent: Thursday, January 10, 2019 3:19 PM >>To: profoxt...@leafe.com >>Subject: Re: AW: Custom Scrollbar >> >>Give me examples of what you are entering. I enter The Text as 5, Even > >># as 2 and Weird # as 3 successfully because 5 % 2 = 1 and 3 % 2 = 1. >> >>Frank. >> >>Frank Cazabon >> >>On 10/01/2019 04:03 PM, Koen Piller wrote: >>> Yes and still I cannot enter any value in weird >>> Regards >>> Koen >> >> [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/7d475e50-5ab6-4025-8ab5-d9a4255b0...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/7d475e50-5ab6-4025-8ab5-d9a4255b0...@gmail.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn6pr10mb1458b245a909fd0af3a4a1bdd2...@bn6pr10mb1458.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
All columns have different validation rules. There is no input mask to force the text column to only accept numbers. You can put alphabetic characters in there too. Then it uses the rule specified earlier by Gene. You can download it and look at it and read Gene's specification in his last message here. On 10 January 2019 16:43:54 GMT-04:00, Richard Kaye wrote: >The column with the valid rule. Is it only allowing digits to be >entered? I would expect a data type mismatch if it was allowing >anything other than digits. Maybe Koen is trying to type alpha >characters? > >-- > >rk > >-Original Message- >From: ProfoxTech On Behalf Of Frank >Cazabon >Sent: Thursday, January 10, 2019 3:40 PM >To: profoxt...@leafe.com >Subject: RE: AW: Custom Scrollbar > >What control? The text? > >This is a quick knock up for Gene to check out, all I've put in is what >he specifically asked for so it's a bare minimum thing. > >On 10 January 2019 16:23:50 GMT-04:00, Richard Kaye > wrote: >>Control not constrained to digits only? >> >>-- >> >>rk >> >>-Original Message- >>From: ProfoxTech On Behalf Of Frank >>Cazabon >>Sent: Thursday, January 10, 2019 3:19 PM >>To: profoxt...@leafe.com >>Subject: Re: AW: Custom Scrollbar >> >>Give me examples of what you are entering. I enter The Text as 5, Even > >># as 2 and Weird # as 3 successfully because 5 % 2 = 1 and 3 % 2 = 1. >> >>Frank. >> >>Frank Cazabon >> >>On 10/01/2019 04:03 PM, Koen Piller wrote: >>> Yes and still I cannot enter any value in weird >>> Regards >>> Koen >> >> [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/7d475e50-5ab6-4025-8ab5-d9a4255b0...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
The column with the valid rule. Is it only allowing digits to be entered? I would expect a data type mismatch if it was allowing anything other than digits. Maybe Koen is trying to type alpha characters? -- rk -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: Thursday, January 10, 2019 3:40 PM To: profoxt...@leafe.com Subject: RE: AW: Custom Scrollbar What control? The text? This is a quick knock up for Gene to check out, all I've put in is what he specifically asked for so it's a bare minimum thing. On 10 January 2019 16:23:50 GMT-04:00, Richard Kaye wrote: >Control not constrained to digits only? > >-- > >rk > >-Original Message- >From: ProfoxTech On Behalf Of Frank >Cazabon >Sent: Thursday, January 10, 2019 3:19 PM >To: profoxt...@leafe.com >Subject: Re: AW: Custom Scrollbar > >Give me examples of what you are entering. I enter The Text as 5, Even ># as 2 and Weird # as 3 successfully because 5 % 2 = 1 and 3 % 2 = 1. > >Frank. > >Frank Cazabon > >On 10/01/2019 04:03 PM, Koen Piller wrote: >> Yes and still I cannot enter any value in weird >> Regards >> Koen > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn6pr10mb14581085fc3964bd7a6dc3efd2...@bn6pr10mb1458.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
What control? The text? This is a quick knock up for Gene to check out, all I've put in is what he specifically asked for so it's a bare minimum thing. On 10 January 2019 16:23:50 GMT-04:00, Richard Kaye wrote: >Control not constrained to digits only? > >-- > >rk > >-Original Message- >From: ProfoxTech On Behalf Of Frank >Cazabon >Sent: Thursday, January 10, 2019 3:19 PM >To: profoxt...@leafe.com >Subject: Re: AW: Custom Scrollbar > >Give me examples of what you are entering. I enter The Text as 5, Even ># as 2 and Weird # as 3 successfully because 5 % 2 = 1 and 3 % 2 = 1. > >Frank. > >Frank Cazabon > >On 10/01/2019 04:03 PM, Koen Piller wrote: >> Yes and still I cannot enter any value in weird >> Regards >> Koen > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/24bdb414-2dd1-4850-a56d-a657165e1...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
Control not constrained to digits only? -- rk -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: Thursday, January 10, 2019 3:19 PM To: profoxt...@leafe.com Subject: Re: AW: Custom Scrollbar Give me examples of what you are entering. I enter The Text as 5, Even # as 2 and Weird # as 3 successfully because 5 % 2 = 1 and 3 % 2 = 1. Frank. Frank Cazabon On 10/01/2019 04:03 PM, Koen Piller wrote: > Yes and still I cannot enter any value in weird > Regards > Koen ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn6pr10mb145849ef6f95b7d9c69eb4f0d2...@bn6pr10mb1458.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
Give me examples of what you are entering. I enter The Text as 5, Even # as 2 and Weird # as 3 successfully because 5 % 2 = 1 and 3 % 2 = 1. Frank. Frank Cazabon On 10/01/2019 04:03 PM, Koen Piller wrote: Yes and still I cannot enter any value in weird Regards Koen Op do 10 jan. 2019 om 17:59 schreef Frank Cazabon There is validation according to Gene's rule: On 10/01/2019 12:10 PM, Koen Piller wrote: the row-level validation is: asc(thetext)%2=weirdnr%2 Frank, Downloading and installing the file Gene.zip was easy done succesfull. The form: I am not able to enter a value in column #Weird if I have entered 8 in the column text. Is that how it is supposed to work? Regards, Koen Is it that you are getting the message regarding that validation? Frank. Frank Cazabon [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/57c734e0-ef02-fc86-57b6-0680755c1...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
Yes and still I cannot enter any value in weird Regards Koen Op do 10 jan. 2019 om 17:59 schreef Frank Cazabon > There is validation according to Gene's rule: > > On 10/01/2019 12:10 PM, Koen Piller wrote: > > the row-level validation is: > > asc(thetext)%2=weirdnr%2 > > > Frank, > > Downloading and installing the file Gene.zip was easy done succesfull. > > The form: I am not able to enter a value in column #Weird if I have > entered > > 8 in the column text. Is that how it is supposed to work? > > Regards, > > Koen > > Is it that you are getting the message regarding that validation? > > Frank. > > Frank Cazabon > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACUu1Sv3LzR7wwv2oWg0bKtvFJknJ7zLFUD8Pxv5SEB1zvg=t...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
There is validation according to Gene's rule: On 10/01/2019 12:10 PM, Koen Piller wrote: the row-level validation is: asc(thetext)%2=weirdnr%2 Frank, Downloading and installing the file Gene.zip was easy done succesfull. The form: I am not able to enter a value in column #Weird if I have entered 8 in the column text. Is that how it is supposed to work? Regards, Koen Is it that you are getting the message regarding that validation? Frank. Frank Cazabon ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ed786b61-a953-490b-da73-b7a9ec201...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
Frank, Downloading and installing the file Gene.zip was easy done succesfull. The form: I am not able to enter a value in column #Weird if I have entered 8 in the column text. Is that how it is supposed to work? Regards, Koen Op do 10 jan. 2019 om 16:36 schreef Frank Cazabon : > I was hoping that I would get Gene's response first as it really was a > quick and dirty thing to show him how it could be done, but if others > are interested I guess it won't hurt to have more eyes on it: > > > https://drive.google.com/file/d/1mR9CS02c3xr20-Y-sVr2B6cxAvsM8APh/view?usp=sharing > > Let me know if there is a problem downloading the file as I generally > don't share files this way, so may have made a silly mistake when trying > to share it. > > Frank. > > Frank Cazabon > > On 10/01/2019 11:25 AM, Koen Piller wrote: > > Frank > > Would you mind to e-mail me the link also? > > Regards > > Koen > > > > Op do 10 jan. 2019 om 15:06 schreef Frank Cazabon < > frank.caza...@gmail.com> > > > >> Gene, > >> > >> I've knocked up a quick demo which I hope meets your requirements and > >> emailed you the link to the download on google drive. > >> > >> Frank. > >> > >> Frank Cazabon > >> > >> On 09/01/2019 02:52 PM, Gene Wirchenko wrote: > >>> At 05:28 2019-01-08, Frank Cazabon wrote: > Gene, back in April last year you were asking if anyone could write > code to your specification regarding the grid problems you were > having. I don't recall ever seeing your specification, maybe if you > posted it someone might be able to do the code for you. > >>> At that time, I was also having difficulties posting to the > >>> list. I thought I had come up with something, but maybe, it did not > >>> make it and I mistakenly deleted it. Let me specify something simple: > >>> > >>> Consider a cursor or table of: > >>>thetext c(20) > >>>evennr n(3) > >>>weirdnr n(3) > >>> > >>> The validations are: > >>>thetext>"" > >>>evennr%2=0 > >>>weirdnr%3=0 > >>> and the row-level validation is: > >>>asc(thetext)%2=weirdnr%2 > >>> > >>> When a control-level validation error occurs, throw an > >>> appropriate message box and then set focus to the control with the > >>> erroneous value. > >>> > >>> For a row-level validation: > >>> > >>>1) All control-level validations should be done first. Start with > >>> the current control, then do all the others from left to right. The > >>> first that fails gets the message box, and checking stops. > >>> > >>> Then, do the row-level validation. If it fails, throw an > >>> aoppropriate message box and then set focus to the control in the > >>> first column from the left of the values that are checked. (In the > >>> example above, thetext is left of weirdnr, so set focus to thetext.) > >>> > >>> Part 2: > >>> > >>> The columns can now be rearranged in any order. Despite this: > >>> > >>> The coontrol-level validations should still set focus to the > >>> correct control. > >>> > >>> The column-level validations done at the start of the row-level > >>> validation should be done in the order current then left-to-right. > >>> NOTE THAT THIS COULD NOW BE A DIFFERENT ORDER. > >>> > >>> The row-level validation should still set focus to the leftmost > >>> involved control. NOTE THAT THIS MIGHT BE A DIFFERENT CONTROL. > >>> (Example: If weirdnr gets moved to the left of thetext, row-level > >>> validation failing should set focus to weirdnr.) > >>> > >>> > >>> This is basic functionality that I want/need. I have been unable > >>> to get this to work with VFP's Grid despite my efforts. > >>> > >>> [snip] > >>> > >>> Sincerely, > >>> > >>> Gene Wirchenko > >>> > >>> [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACUu1Sv4k1pBTuo+xKhEsBxKuOpJy5JMW+OxhxCjiT0=0su...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
I was hoping that I would get Gene's response first as it really was a quick and dirty thing to show him how it could be done, but if others are interested I guess it won't hurt to have more eyes on it: https://drive.google.com/file/d/1mR9CS02c3xr20-Y-sVr2B6cxAvsM8APh/view?usp=sharing Let me know if there is a problem downloading the file as I generally don't share files this way, so may have made a silly mistake when trying to share it. Frank. Frank Cazabon On 10/01/2019 11:25 AM, Koen Piller wrote: Frank Would you mind to e-mail me the link also? Regards Koen Op do 10 jan. 2019 om 15:06 schreef Frank Cazabon Gene, I've knocked up a quick demo which I hope meets your requirements and emailed you the link to the download on google drive. Frank. Frank Cazabon On 09/01/2019 02:52 PM, Gene Wirchenko wrote: At 05:28 2019-01-08, Frank Cazabon wrote: Gene, back in April last year you were asking if anyone could write code to your specification regarding the grid problems you were having. I don't recall ever seeing your specification, maybe if you posted it someone might be able to do the code for you. At that time, I was also having difficulties posting to the list. I thought I had come up with something, but maybe, it did not make it and I mistakenly deleted it. Let me specify something simple: Consider a cursor or table of: thetext c(20) evennr n(3) weirdnr n(3) The validations are: thetext>"" evennr%2=0 weirdnr%3=0 and the row-level validation is: asc(thetext)%2=weirdnr%2 When a control-level validation error occurs, throw an appropriate message box and then set focus to the control with the erroneous value. For a row-level validation: 1) All control-level validations should be done first. Start with the current control, then do all the others from left to right. The first that fails gets the message box, and checking stops. Then, do the row-level validation. If it fails, throw an aoppropriate message box and then set focus to the control in the first column from the left of the values that are checked. (In the example above, thetext is left of weirdnr, so set focus to thetext.) Part 2: The columns can now be rearranged in any order. Despite this: The coontrol-level validations should still set focus to the correct control. The column-level validations done at the start of the row-level validation should be done in the order current then left-to-right. NOTE THAT THIS COULD NOW BE A DIFFERENT ORDER. The row-level validation should still set focus to the leftmost involved control. NOTE THAT THIS MIGHT BE A DIFFERENT CONTROL. (Example: If weirdnr gets moved to the left of thetext, row-level validation failing should set focus to weirdnr.) This is basic functionality that I want/need. I have been unable to get this to work with VFP's Grid despite my efforts. [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1643ada0-3dc2-a65b-461c-3731ffada...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
Frank Would you mind to e-mail me the link also? Regards Koen Op do 10 jan. 2019 om 15:06 schreef Frank Cazabon > Gene, > > I've knocked up a quick demo which I hope meets your requirements and > emailed you the link to the download on google drive. > > Frank. > > Frank Cazabon > > On 09/01/2019 02:52 PM, Gene Wirchenko wrote: > > At 05:28 2019-01-08, Frank Cazabon wrote: > >> Gene, back in April last year you were asking if anyone could write > >> code to your specification regarding the grid problems you were > >> having. I don't recall ever seeing your specification, maybe if you > >> posted it someone might be able to do the code for you. > > > > At that time, I was also having difficulties posting to the > > list. I thought I had come up with something, but maybe, it did not > > make it and I mistakenly deleted it. Let me specify something simple: > > > > Consider a cursor or table of: > > thetext c(20) > > evennr n(3) > > weirdnr n(3) > > > > The validations are: > > thetext>"" > > evennr%2=0 > > weirdnr%3=0 > > and the row-level validation is: > > asc(thetext)%2=weirdnr%2 > > > > When a control-level validation error occurs, throw an > > appropriate message box and then set focus to the control with the > > erroneous value. > > > > For a row-level validation: > > > > 1) All control-level validations should be done first. Start with > > the current control, then do all the others from left to right. The > > first that fails gets the message box, and checking stops. > > > > Then, do the row-level validation. If it fails, throw an > > aoppropriate message box and then set focus to the control in the > > first column from the left of the values that are checked. (In the > > example above, thetext is left of weirdnr, so set focus to thetext.) > > > > Part 2: > > > > The columns can now be rearranged in any order. Despite this: > > > > The coontrol-level validations should still set focus to the > > correct control. > > > > The column-level validations done at the start of the row-level > > validation should be done in the order current then left-to-right. > > NOTE THAT THIS COULD NOW BE A DIFFERENT ORDER. > > > > The row-level validation should still set focus to the leftmost > > involved control. NOTE THAT THIS MIGHT BE A DIFFERENT CONTROL. > > (Example: If weirdnr gets moved to the left of thetext, row-level > > validation failing should set focus to weirdnr.) > > > > > > This is basic functionality that I want/need. I have been unable > > to get this to work with VFP's Grid despite my efforts. > > > > [snip] > > > > Sincerely, > > > > Gene Wirchenko > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACUu1SsWgNzGgM=gvqP1gqSCzsKW7BypcaJ1-=kbcvetisc...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
Gene, I've knocked up a quick demo which I hope meets your requirements and emailed you the link to the download on google drive. Frank. Frank Cazabon On 09/01/2019 02:52 PM, Gene Wirchenko wrote: At 05:28 2019-01-08, Frank Cazabon wrote: Gene, back in April last year you were asking if anyone could write code to your specification regarding the grid problems you were having. I don't recall ever seeing your specification, maybe if you posted it someone might be able to do the code for you. At that time, I was also having difficulties posting to the list. I thought I had come up with something, but maybe, it did not make it and I mistakenly deleted it. Let me specify something simple: Consider a cursor or table of: thetext c(20) evennr n(3) weirdnr n(3) The validations are: thetext>"" evennr%2=0 weirdnr%3=0 and the row-level validation is: asc(thetext)%2=weirdnr%2 When a control-level validation error occurs, throw an appropriate message box and then set focus to the control with the erroneous value. For a row-level validation: 1) All control-level validations should be done first. Start with the current control, then do all the others from left to right. The first that fails gets the message box, and checking stops. Then, do the row-level validation. If it fails, throw an aoppropriate message box and then set focus to the control in the first column from the left of the values that are checked. (In the example above, thetext is left of weirdnr, so set focus to thetext.) Part 2: The columns can now be rearranged in any order. Despite this: The coontrol-level validations should still set focus to the correct control. The column-level validations done at the start of the row-level validation should be done in the order current then left-to-right. NOTE THAT THIS COULD NOW BE A DIFFERENT ORDER. The row-level validation should still set focus to the leftmost involved control. NOTE THAT THIS MIGHT BE A DIFFERENT CONTROL. (Example: If weirdnr gets moved to the left of thetext, row-level validation failing should set focus to weirdnr.) This is basic functionality that I want/need. I have been unable to get this to work with VFP's Grid despite my efforts. [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/64f74617-dd0a-e973-b20a-f180906ee...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Custom Scrollbar
You don't say. Op wo 9 jan. 2019 21:54 schreef > At 08:18 2019-01-06, Jean Laeremans > > wrote: > >> If memory serves me right he must be at it for at least 15 years. > > > lol...we've been hanging around this barber shop for quite a long > time ;-) > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/capqlobzpjnq0fcp4rcccdvurgypmkm0tj6auv+nf2tdbu83...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Custom Scrollbar
At 08:18 2019-01-06, Jean Laeremans wrote: If memory serves me right he must be at it for at least 15 years. lol...we've been hanging around this barber shop for quite a long time ;-) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/80c505ec4c528d0fb9866b729214e...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 05:28 2019-01-08, Frank Cazabon wrote: Gene, back in April last year you were asking if anyone could write code to your specification regarding the grid problems you were having. I don't recall ever seeing your specification, maybe if you posted it someone might be able to do the code for you. At that time, I was also having difficulties posting to the list. I thought I had come up with something, but maybe, it did not make it and I mistakenly deleted it. Let me specify something simple: Consider a cursor or table of: thetext c(20) evennr n(3) weirdnr n(3) The validations are: thetext>"" evennr%2=0 weirdnr%3=0 and the row-level validation is: asc(thetext)%2=weirdnr%2 When a control-level validation error occurs, throw an appropriate message box and then set focus to the control with the erroneous value. For a row-level validation: 1) All control-level validations should be done first. Start with the current control, then do all the others from left to right. The first that fails gets the message box, and checking stops. Then, do the row-level validation. If it fails, throw an aoppropriate message box and then set focus to the control in the first column from the left of the values that are checked. (In the example above, thetext is left of weirdnr, so set focus to thetext.) Part 2: The columns can now be rearranged in any order. Despite this: The coontrol-level validations should still set focus to the correct control. The column-level validations done at the start of the row-level validation should be done in the order current then left-to-right. NOTE THAT THIS COULD NOW BE A DIFFERENT ORDER. The row-level validation should still set focus to the leftmost involved control. NOTE THAT THIS MIGHT BE A DIFFERENT CONTROL. (Example: If weirdnr gets moved to the left of thetext, row-level validation failing should set focus to weirdnr.) This is basic functionality that I want/need. I have been unable to get this to work with VFP's Grid despite my efforts. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/731e29e7879827379eafb5958e3b7f26@mtlp83 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 07:54 2019-01-09, you wrote: Gene, correct me if I'm wrong, but as far back as this list goes, I remember you talking about your own VFP grid replacement, honestly as far back as 15+ years ago. Am I right? Yes and no. I have tried over that time, but most of the time, I have had to work on other stuff. My own grid is a low priority until I have something useful working. I have tried to work with VFP's Grid control and kept running into trouble. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f7adc88592eecdc2621a1247365351dc@mtlp83 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
Gene, correct me if I'm wrong, but as far back as this list goes, I remember you talking about your own VFP grid replacement, honestly as far back as 15+ years ago. Am I right? On 2019-01-07 00:20, Gene Wirchenko wrote: At 08:13 2019-01-06, wrote: >> I want to create my own grid WHY, just WHY? Because the VFP grid does not work. Haven't yet found a problem for which I would need a homegrown grid. What can't you do in VFP's native grid, in combination with the excellent container hierarchy which you could add into any / every column of a grid? Full validation of a row. I came close, but it required a lot of kludges and an innocent change in one place could blow it up. Build a set of controls, save them as class, add that class to the Column, change Column.CurrentControl to point to that class, set Column.Sparse to .F. and presto, you can do any complicated setup and stil have the benefits of VFP's native gridspeed. I wish. One of the things that Grid is supposedly not for is data entry. I need a grid that can handle that. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0f90af823f1fcb463af85388bd69f...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
Gene, I am sure you have tried all of the following, but thought I might check regarding the record validation thing. Are you using data from a table that is part of a database? If so, do you have both field and row level validations specified in the dbc? Are you using buffering and CursorGetProp() and related functions/methods to check for field/row level changes? If yes to all above, just ignore this message.. If no to any of the above, that might be part of the problems you are having with the validations. Fletcher Fletcher Johnson fletchersjohn...@yahoo.com LinkedIn.com/in/FletcherJohnson beknown.com/FletcherJohnson twitter.com/fletcherJ twitter.com/svcsug strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Monday, January 7, 2019 7:35 PM To: ProFox Email List Subject: RE: AW: Custom Scrollbar At 14:47 2019-01-07, "Darren" wrote: >Been watching this thread and decided to pipe in >- I have to observe that I have done some pretty >tricky stuff with the VFP grid. Granted some not >so straight forward but subclass columns and >headers etc. and you can go for broke. Not found >anything that can’t be done with the VFP grid. >Not to say it can do everything but I'm yet to >find what that is. Spend a bit of time (a few >hours) and enlightened you will be. I have spent *manweeks* trying to get Grid to work for my needs. It has resisted quite effectively. [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/084a01d4a7bc$4af1fc50$e0d5f4f0$@yahoo.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
On 08/01/2019 03:27, Gene Wirchenko wrote: I can not get proper row-level validation working consistently. I have tried and tried and tried. I keep finding cases where it breaks. I deal with a case, and something else breaks. It is very frustrating. Maybe you can describe a scenario (with data etc and what you want it to do) where the grid does not work? I'd be interested to see it. Peter This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/9f8383a4-4cc7-8942-14b7-4834a3523...@whisperingsmith.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
Gene, back in April last year you were asking if anyone could write code to your specification regarding the grid problems you were having. I don't recall ever seeing your specification, maybe if you posted it someone might be able to do the code for you. I for one do a lot of data entry grids using Visual MaxFrame Professional which makes use of Business Objects for field and row validation. Frank. Frank Cazabon On 07/01/2019 11:35 PM, Gene Wirchenko wrote: At 14:47 2019-01-07, "Darren" wrote: Been watching this thread and decided to pipe in - I have to observe that I have done some pretty tricky stuff with the VFP grid. Granted some not so straight forward but subclass columns and headers etc. and you can go for broke. Not found anything that can’t be done with the VFP grid. Not to say it can do everything but I'm yet to find what that is. Spend a bit of time (a few hours) and enlightened you will be. I have spent *manweeks* trying to get Grid to work for my needs. It has resisted quite effectively. [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f3f55a32-b596-e800-44d8-158a933a9...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
While it can definitely be fun to roll your own, I would also investigate Craig Boyd's gridextras class. It's got a ton of useful features baked in such as column sorting, export, filtering, quick reporting and so on. You basically add an instance to your form, set a few properties and call its setup method when the form instantiates. <http://www.sweetpotatosoftware.com/blog/index.php/2008/11/25/visual-foxpro-grid-enhancements/> -- rk -Original Message- From: ProfoxTech On Behalf Of Gene Wirchenko Sent: Monday, January 7, 2019 10:35 PM To: profoxt...@leafe.com Subject: RE: AW: Custom Scrollbar At 14:47 2019-01-07, "Darren" wrote: >Been watching this thread and decided to pipe in >- I have to observe that I have done some pretty tricky stuff with the >VFP grid. Granted some not so straight forward but subclass columns and >headers etc. and you can go for broke. Not found anything that can’t >be done with the VFP grid. >Not to say it can do everything but I'm yet to find what that is. Spend >a bit of time (a few >hours) and enlightened you will be. I have spent *manweeks* trying to get Grid to work for my needs. It has resisted quite effectively. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/7590d97538b2309d61ca7919f6e8cce0@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/7590d97538b2309d61ca7919f6e8cce0@mtlp86 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn6pr10mb1458170213751c99a8f610c2d2...@bn6pr10mb1458.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
Hi Gene: I think that I've found what you need. You need to use the Valid event of the grid in combination with the valid of the controls. Please, read this chapter about grids of the book 1001 things you wanted to know about VFP. "Grids, the misunderstood controls:" https://books.google.es/books?id=wKNfTHRNkLAC&pg=PA159&lpg=PA159&dq=chapter+6+grids+the+misunderstood+controls&source=bl&ots=_08ZpTRmYN&sig=96XyTJ44EPz0-LM5magwVtuTzmg&hl=es&sa=X&ved=2ahUKEwj15-zS0N3fAhWMJ1AKHX0kAzgQ6AEwBHoECAgQAQ#v=onepage&q=chapter%206%20grids%20the%20misunderstood%20controls&f=false El mar., 8 ene. 2019 4:27, Gene Wirchenko escribió: > At 03:18 2019-01-07, "Fernando D. Bozzo" wrote: > >Hi Gene, About this: >"One of the things that Grid is supposedly not > >for is data entry" > > > I don't agree. > > Neither do I, but I have seen this opinion posted many times > over the years. I do not understand it myself, but there it is. > > > Not sure about the complexity of what you need to do, but if you > > used FoxPro before VFP, you could remember that before the grid > > component was the BROWSE command with many parameters that allowed > > many validations and options for row/column, and that many > > validations and options where made exactly for that purpose, for > > data entry. Most of them have no sense for other purpose than data entry. > > Yes, but I had a period of time where I was not using > xBASE. That was about when the fancy browses had their day. I have > looked at BROWSE, and it does not have quite what I want. > > > One of my first programming challenges was to do a component > > exactly as you need it to (I'm talking about dBase III+ era), and > > could do it, but the problem was that performed horribly, too slow > > to navigate records and columns. I think that you could face the > > same problem. Do not forget that you have to control each and every > > aspect of the component, as: - Scrolling left/right controlling > > start and end columns > >I have this scrolling already working in a concept case. It > was fairly easy. I grant that this may change when I add more > feature. I do not think so though. > > > - Scrolling top/bottom controlling start and end rows - > > Controlling the data you load/unload, because you can't load a > > millon records in memory, and this forces you to control > > dinamically the loading of a new bunch of records in the direction > > you are navigating, and unloading records from the other side - > > Yup! It is going to be fun, but I have some ideas. > > I am concerned with how the scrollbar works, but I may just > come up with my own version that bypasses the issues. > > >Controlling every key for navigation and other needed purposes - > >Controlling the visualization of each aspect of your info (think on > >Autosizing columns, pre-programmed sizes, combination of both, > >assuring that you show columns correctly and fluently ,etc) > > I do not plan to have every feature that Grid has, at least for > the start. > > I tried to get Grid working when allowing column order to > change, and it was horrible. > > > - More things you may ancounter > > Quite possibly. > > What I have encountered is trouble with row-level > validation. Without that, Grid is NOT what I want. > > > Obviously I'm thinking in a component that can be used for any > > table, and not just for one special table, because the programming > > effort to do this type of component is too high to do it for just > > one table. Don't know if you already said this because I didn't > > follow the entire thread, but: What type of validation do you need, > > and what is the problem you are facing that can't be handled with the > grid? > > I can not get proper row-level validation working > consistently. I have tried and tried and tried. I keep finding > cases where it breaks. I deal with a case, and something else > breaks. It is very frustrating. > > I had quite a lot of trouble to get my test case to work. I > had to experiment with events and methods, but once I got it, it > worked and did so consistently. > > > And more importantly: Is really a grid what you need? why can't > > you use an input form with navigation keys that scrolls data in > background? > > Because some of the work that needs to be done needs multiple > rows visible at once. > > [snip] > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGQ_JunzDhwHndjjyyZ3KZA0WR86D5=uxwtawryhg8+vlpt...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, a
RE: AW: Custom Scrollbar
At 14:47 2019-01-07, "Darren" wrote: Been watching this thread and decided to pipe in - I have to observe that I have done some pretty tricky stuff with the VFP grid. Granted some not so straight forward but subclass columns and headers etc. and you can go for broke. Not found anything that canât be done with the VFP grid. Not to say it can do everything but I'm yet to find what that is. Spend a bit of time (a few hours) and enlightened you will be. I have spent *manweeks* trying to get Grid to work for my needs. It has resisted quite effectively. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/7590d97538b2309d61ca7919f6e8cce0@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 04:43 2019-01-07, Koen Piller wrote: Gene The native VFP grid can handle datahandling perfectly. Please explain why you differ on opinion Because despite multiple efforts by me to get it to work, it would not work. I do not believe that Grid works. At the very least, it is so quirky, it is very difficult to use. Given that I have been able to learn how to use other VFP classes fairly easily, I lean to the view that Grid is buggy. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cee9014521ac7d80b138146d8c8cbf76@mtlp86 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 03:18 2019-01-07, "Fernando D. Bozzo" wrote: Hi Gene, About this: >"One of the things that Grid is supposedly not for is data entry" I don't agree. Neither do I, but I have seen this opinion posted many times over the years. I do not understand it myself, but there it is. Not sure about the complexity of what you need to do, but if you used FoxPro before VFP, you could remember that before the grid component was the BROWSE command with many parameters that allowed many validations and options for row/column, and that many validations and options where made exactly for that purpose, for data entry. Most of them have no sense for other purpose than data entry. Yes, but I had a period of time where I was not using xBASE. That was about when the fancy browses had their day. I have looked at BROWSE, and it does not have quite what I want. One of my first programming challenges was to do a component exactly as you need it to (I'm talking about dBase III+ era), and could do it, but the problem was that performed horribly, too slow to navigate records and columns. I think that you could face the same problem. Do not forget that you have to control each and every aspect of the component, as: - Scrolling left/right controlling start and end columns I have this scrolling already working in a concept case. It was fairly easy. I grant that this may change when I add more feature. I do not think so though. - Scrolling top/bottom controlling start and end rows - Controlling the data you load/unload, because you can't load a millon records in memory, and this forces you to control dinamically the loading of a new bunch of records in the direction you are navigating, and unloading records from the other side - Yup! It is going to be fun, but I have some ideas. I am concerned with how the scrollbar works, but I may just come up with my own version that bypasses the issues. Controlling every key for navigation and other needed purposes - Controlling the visualization of each aspect of your info (think on Autosizing columns, pre-programmed sizes, combination of both, assuring that you show columns correctly and fluently ,etc) I do not plan to have every feature that Grid has, at least for the start. I tried to get Grid working when allowing column order to change, and it was horrible. - More things you may ancounter Quite possibly. What I have encountered is trouble with row-level validation. Without that, Grid is NOT what I want. Obviously I'm thinking in a component that can be used for any table, and not just for one special table, because the programming effort to do this type of component is too high to do it for just one table. Don't know if you already said this because I didn't follow the entire thread, but: What type of validation do you need, and what is the problem you are facing that can't be handled with the grid? I can not get proper row-level validation working consistently. I have tried and tried and tried. I keep finding cases where it breaks. I deal with a case, and something else breaks. It is very frustrating. I had quite a lot of trouble to get my test case to work. I had to experiment with events and methods, but once I got it, it worked and did so consistently. And more importantly: Is really a grid what you need? why can't you use an input form with navigation keys that scrolls data in background? Because some of the work that needs to be done needs multiple rows visible at once. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/15d042d9866641a883852a099cc7ceb5@mtlp83 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: AW: Custom Scrollbar
Been watching this thread and decided to pipe in - I have to observe that I have done some pretty tricky stuff with the VFP grid. Granted some not so straight forward but subclass columns and headers etc. and you can go for broke. Not found anything that can’t be done with the VFP grid. Not to say it can do everything but I'm yet to find what that is. Spend a bit of time (a few hours) and enlightened you will be. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Koen Piller Sent: Monday, 7 January 2019 11:44 PM To: profoxt...@leafe.com Subject: Re: AW: Custom Scrollbar Gene The native VFP grid can handle datahandling perfectly. Please explain why you differ on opinion Koen Op ma 7 jan. 2019 om 12:19 schreef Fernando D. Bozzo > Hi Gene, > > About this: > > >"One of the things that Grid is supposedly not for is data > entry" > > I don't agree. Not sure about the complexity of what you need to do, but if > you used FoxPro before VFP, you could remember that before the grid > component was the BROWSE command with many parameters that allowed many > validations and options for row/column, and that many validations and > options where made exactly for that purpose, for data entry. Most of them > have no sense for other purpose than data entry. > > One of my first programming challenges was to do a component exactly as you > need it to (I'm talking about dBase III+ era), and could do it, but the > problem was that performed horribly, too slow to navigate records and > columns. > I think that you could face the same problem. Do not forget that you have > to control each and every aspect of the component, as: > > - Scrolling left/right controlling start and end columns > - Scrolling top/bottom controlling start and end rows > - Controlling the data you load/unload, because you can't load a millon > records in memory, and this forces you to control dinamically the loading > of a new bunch of records in the direction you are navigating, and > unloading records from the other side > - Controlling every key for navigation and other needed purposes > - Controlling the visualization of each aspect of your info (think on > Autosizing columns, pre-programmed sizes, combination of both, assuring > that you show columns correctly and fluently ,etc) > - More things you may ancounter > > Obviously I'm thinking in a component that can be used for any table, and > not just for one special table, because the programming effort to do this > type of component is too high to do it for just one table. > > Don't know if you already said this because I didn't follow the entire > thread, but: > What type of validation do you need, and what is the problem you are facing > that can't be handled with the grid? > > And more importantly: Is really a grid what you need? why can't you use an > input form with navigation keys that scrolls data in background? > > Best Regards! > > > El lun., 7 ene. 2019 a las 6:20, Gene Wirchenko () > escribió: > > > At 08:13 2019-01-06, wrote: > > > >> I want to create my own grid > > > > > >WHY, just WHY? > > > > Because the VFP grid does not work. > > > > >Haven't yet found a problem for which I would need a homegrown grid. > > >What can't you do in VFP's native grid, in combination with the > excellent > > >container hierarchy which you could add into any / every column of a > grid? > > > > Full validation of a row. > > > > I came close, but it required a lot of kludges and an innocent > > change in one place could blow it up. > > > > >Build a set of controls, save them as class, add that class to the > Column, > > >change Column.CurrentControl to point to that class, set Column.Sparse > to > > >.F. and presto, you can do any complicated setup and stil have the > > benefits > > >of VFP's native gridspeed. > > > > I wish. > > > > One of the things that Grid is supposedly not for is data > > entry. I need a grid that can handle that. > > > > Sincerely, > > > > Gene Wirchenko > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/005f01d4a6da$f268e8f0$d73abad0$@ozemail.com.au ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Custom Scrollbar
Or use the MSGrid component that is free but only works using datasets. Dave Crozier Software Development Manager Flexipol Packaging Ltd. ﴾⚆ᨎ⚆﴿ Flexipol® Packaging Ltd T 01706 222 792 E dcroz...@flexipol.co.uk W https://www.flexipol.co.uk/ Follow us: Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received. It is the responsibility of the recipient to ensure that they have adequate virus protection. - Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time -Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: 07 January 2019 10:16 To: profoxt...@leafe.com Subject: Re: Custom Scrollbar Would it not be more cost effective to look at something like iGrid ActiveX which is $275 for a single developer than expend your time rolling your own? -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cwlp265mb08526244463e20173f485f14fb...@cwlp265mb0852.gbrp265.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
Gene The native VFP grid can handle datahandling perfectly. Please explain why you differ on opinion Koen Op ma 7 jan. 2019 om 12:19 schreef Fernando D. Bozzo > Hi Gene, > > About this: > > >"One of the things that Grid is supposedly not for is data > entry" > > I don't agree. Not sure about the complexity of what you need to do, but if > you used FoxPro before VFP, you could remember that before the grid > component was the BROWSE command with many parameters that allowed many > validations and options for row/column, and that many validations and > options where made exactly for that purpose, for data entry. Most of them > have no sense for other purpose than data entry. > > One of my first programming challenges was to do a component exactly as you > need it to (I'm talking about dBase III+ era), and could do it, but the > problem was that performed horribly, too slow to navigate records and > columns. > I think that you could face the same problem. Do not forget that you have > to control each and every aspect of the component, as: > > - Scrolling left/right controlling start and end columns > - Scrolling top/bottom controlling start and end rows > - Controlling the data you load/unload, because you can't load a millon > records in memory, and this forces you to control dinamically the loading > of a new bunch of records in the direction you are navigating, and > unloading records from the other side > - Controlling every key for navigation and other needed purposes > - Controlling the visualization of each aspect of your info (think on > Autosizing columns, pre-programmed sizes, combination of both, assuring > that you show columns correctly and fluently ,etc) > - More things you may ancounter > > Obviously I'm thinking in a component that can be used for any table, and > not just for one special table, because the programming effort to do this > type of component is too high to do it for just one table. > > Don't know if you already said this because I didn't follow the entire > thread, but: > What type of validation do you need, and what is the problem you are facing > that can't be handled with the grid? > > And more importantly: Is really a grid what you need? why can't you use an > input form with navigation keys that scrolls data in background? > > Best Regards! > > > El lun., 7 ene. 2019 a las 6:20, Gene Wirchenko () > escribió: > > > At 08:13 2019-01-06, wrote: > > > >> I want to create my own grid > > > > > >WHY, just WHY? > > > > Because the VFP grid does not work. > > > > >Haven't yet found a problem for which I would need a homegrown grid. > > >What can't you do in VFP's native grid, in combination with the > excellent > > >container hierarchy which you could add into any / every column of a > grid? > > > > Full validation of a row. > > > > I came close, but it required a lot of kludges and an innocent > > change in one place could blow it up. > > > > >Build a set of controls, save them as class, add that class to the > Column, > > >change Column.CurrentControl to point to that class, set Column.Sparse > to > > >.F. and presto, you can do any complicated setup and stil have the > > benefits > > >of VFP's native gridspeed. > > > > I wish. > > > > One of the things that Grid is supposedly not for is data > > entry. I need a grid that can handle that. > > > > Sincerely, > > > > Gene Wirchenko > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacuu1steey0sxkuwwgjenjigeqxdf-co0r4q112enmbxycx...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
Hi Gene, About this: >"One of the things that Grid is supposedly not for is data entry" I don't agree. Not sure about the complexity of what you need to do, but if you used FoxPro before VFP, you could remember that before the grid component was the BROWSE command with many parameters that allowed many validations and options for row/column, and that many validations and options where made exactly for that purpose, for data entry. Most of them have no sense for other purpose than data entry. One of my first programming challenges was to do a component exactly as you need it to (I'm talking about dBase III+ era), and could do it, but the problem was that performed horribly, too slow to navigate records and columns. I think that you could face the same problem. Do not forget that you have to control each and every aspect of the component, as: - Scrolling left/right controlling start and end columns - Scrolling top/bottom controlling start and end rows - Controlling the data you load/unload, because you can't load a millon records in memory, and this forces you to control dinamically the loading of a new bunch of records in the direction you are navigating, and unloading records from the other side - Controlling every key for navigation and other needed purposes - Controlling the visualization of each aspect of your info (think on Autosizing columns, pre-programmed sizes, combination of both, assuring that you show columns correctly and fluently ,etc) - More things you may ancounter Obviously I'm thinking in a component that can be used for any table, and not just for one special table, because the programming effort to do this type of component is too high to do it for just one table. Don't know if you already said this because I didn't follow the entire thread, but: What type of validation do you need, and what is the problem you are facing that can't be handled with the grid? And more importantly: Is really a grid what you need? why can't you use an input form with navigation keys that scrolls data in background? Best Regards! El lun., 7 ene. 2019 a las 6:20, Gene Wirchenko () escribió: > At 08:13 2019-01-06, wrote: > > >> I want to create my own grid > > > >WHY, just WHY? > > Because the VFP grid does not work. > > >Haven't yet found a problem for which I would need a homegrown grid. > >What can't you do in VFP's native grid, in combination with the excellent > >container hierarchy which you could add into any / every column of a grid? > > Full validation of a row. > > I came close, but it required a lot of kludges and an innocent > change in one place could blow it up. > > >Build a set of controls, save them as class, add that class to the Column, > >change Column.CurrentControl to point to that class, set Column.Sparse to > >.F. and presto, you can do any complicated setup and stil have the > benefits > >of VFP's native gridspeed. > > I wish. > > One of the things that Grid is supposedly not for is data > entry. I need a grid that can handle that. > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGQ_Ju=v1uvypm_nohs-b0v31ppr2nbbazawmknzqw2crhe...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Custom Scrollbar
Would it not be more cost effective to look at something like iGrid ActiveX which is $275 for a single developer than expend your time rolling your own? -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1546856156.1019298.1627512592.71ba7...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Custom Scrollbar
At 08:18 2019-01-06, Jean Laeremans wrote: If memory serves me right he must be at it for at least 15 years. No, it is just that I have never had the free time to go all the way with it. (It is lower priority than my other work.) During that time, I have tried to make VFP's Grid work and have failed despite solid efforts. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f4d13cba68c15d53e75244bdc3b98ee7@mtlp85 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: AW: Custom Scrollbar
At 08:13 2019-01-06, wrote: >> I want to create my own grid WHY, just WHY? Because the VFP grid does not work. Haven't yet found a problem for which I would need a homegrown grid. What can't you do in VFP's native grid, in combination with the excellent container hierarchy which you could add into any / every column of a grid? Full validation of a row. I came close, but it required a lot of kludges and an innocent change in one place could blow it up. Build a set of controls, save them as class, add that class to the Column, change Column.CurrentControl to point to that class, set Column.Sparse to .F. and presto, you can do any complicated setup and stil have the benefits of VFP's native gridspeed. I wish. One of the things that Grid is supposedly not for is data entry. I need a grid that can handle that. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/d3e7c8e925ef9658f59e62571a4e9cb3@mtlp84 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Custom Scrollbar
If memory serves me right he must be at it for at least 15 years. !😉 Op zo 6 jan. 2019 17:14 schreef >> I want to create my own grid > > WHY, just WHY? > > Haven't yet found a problem for which I would need a homegrown grid. > What can't you do in VFP's native grid, in combination with the excellent > container hierarchy which you could add into any / every column of a grid? > Build a set of controls, save them as class, add that class to the Column, > change Column.CurrentControl to point to that class, set Column.Sparse to > .F. and presto, you can do any complicated setup and stil have the benefits > of VFP's native gridspeed. > > > wOOdy > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/capqlobwtcd1pc8sjg65-7jr7npi6v3pzahyyxx3jytmkrg8...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
AW: Custom Scrollbar
>> I want to create my own grid WHY, just WHY? Haven't yet found a problem for which I would need a homegrown grid. What can't you do in VFP's native grid, in combination with the excellent container hierarchy which you could add into any / every column of a grid? Build a set of controls, save them as class, add that class to the Column, change Column.CurrentControl to point to that class, set Column.Sparse to .F. and presto, you can do any complicated setup and stil have the benefits of VFP's native gridspeed. wOOdy ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/019d01d4a5da$cfdfa0e0$6f9ee2a0$@wondzinski.de ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Custom Scrollbar
Hi There are several Custom made scrollcontainers around, Google for it. The most sofisticated for me is made by Carlos Aliotti but also Graig Boyd made a very good working class. For graphic in VFP you cant work without GDIplus, check Cesar Chaloms blog for Some inventive procedures. Regards Koen Op zo 6 jan. 2019 om 02:36 schreef Gene Wirchenko > Hello: > > I want to create my own grid. I am slowly making progress. I > have decided that I need my own scrollbar control. > > It appears that a combination of Image controls will do what I > need -- but do you have some other ideas? -- but I have not worked > with VFP graphics. > > Now, I need to define some icons/images. What software do you > recommend for creating these at the pixel level? I would like to be > able to duplicate the appearance (colourwise) so I would like to be > able to pick the colours off existing VFP controls (especially > scrollbars) as well. > > One issue that I am concerned with is being able to have a > scrollbar stretched and still look good. How does one stretch an > Image properly? > > Is there anything you think I am not considering but should? > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACUu1Su1VMuKo-S=Cr+-iP=chj-sainjw3ffb4tmvg7xoa2...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Custom Scrollbar
Hello: I want to create my own grid. I am slowly making progress. I have decided that I need my own scrollbar control. It appears that a combination of Image controls will do what I need -- but do you have some other ideas? -- but I have not worked with VFP graphics. Now, I need to define some icons/images. What software do you recommend for creating these at the pixel level? I would like to be able to duplicate the appearance (colourwise) so I would like to be able to pick the colours off existing VFP controls (especially scrollbars) as well. One issue that I am concerned with is being able to have a scrollbar stretched and still look good. How does one stretch an Image properly? Is there anything you think I am not considering but should? Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/fd8ca3149f93d983c8297e0f4acb4313@mtlp87 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.