Re: How many of you use foreign key constraints and References in your database schema?
On 2017-10-31 17:02, Charlie-gm wrote: On 10/31/2017 4:26 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: At the day gig, they use FK constraints and References in their Oracle database schema. Honestly, I got into that years ago with VFP but then kinda fell off that wagon over the years, preferring to just handle some things in the BizObj of the solution rather For large applications (500+ tables) I usually require it. Smaller apps... eh... I think there would still be benefits but I'm usually building them so fast that end users won't take the time to provide a complete enough picture to drive all RI rules. Sure, I could still do them on my "internal design only" tables, but like you said, there is some overhead associated. So in the smaller cases it's pretty situational as to whether or not I use it. My attitude is, generally, the more you can put "into" the database, that "belongs" in the database, the better flexibility, maintainability, and stability you'll get. I am using triggers in one of my apps (FabNet) to make sure keys have cascading updates/deletes elsewhere as needed. ___ 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/04b9d8538b42c4c2742f75fb9c6ef...@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: How many of you use foreign key constraints and References in your database schema?
Constraints stop some devs cold when they are trying to "clean up" their data. It is in the correct space in the database because it protects the data there. Compliance auditors like it as well. On Tue, Oct 31, 2017 at 3:26 PM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > At the day gig, they use FK constraints and References in their Oracle > database schema. Honestly, I got into that years ago with VFP but then > kinda fell off that wagon over the years, preferring to just handle some > things in the BizObj of the solution rather than put more rules in the > backend database. The idea was that if I changed backend databases, I > wouldn't need to rewrite a whole bunch of specific DBMS code. > > Where's your preference in design with these in mind? > [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/CAJidMYJjCtegFvqi=pkbdzkuy_5gzfntq2ucmonpcpy+m8p...@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: How many of you use foreign key constraints and References in your database schema?
On 10/31/2017 4:26 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: At the day gig, they use FK constraints and References in their Oracle database schema. Honestly, I got into that years ago with VFP but then kinda fell off that wagon over the years, preferring to just handle some things in the BizObj of the solution rather For large applications (500+ tables) I usually require it. Smaller apps... eh... I think there would still be benefits but I'm usually building them so fast that end users won't take the time to provide a complete enough picture to drive all RI rules. Sure, I could still do them on my "internal design only" tables, but like you said, there is some overhead associated. So in the smaller cases it's pretty situational as to whether or not I use it. My attitude is, generally, the more you can put "into" the database, that "belongs" in the database, the better flexibility, maintainability, and stability you'll get. -Charlie ___ 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/fed5c7ff-8f70-e818-de09-75dc8f0f7...@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.
How many of you use foreign key constraints and References in your database schema?
At the day gig, they use FK constraints and References in their Oracle database schema. Honestly, I got into that years ago with VFP but then kinda fell off that wagon over the years, preferring to just handle some things in the BizObj of the solution rather than put more rules in the backend database. The idea was that if I changed backend databases, I wouldn't need to rewrite a whole bunch of specific DBMS code. Where's your preference in design with these in mind? ___ 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/e92feff80f8c017e701c6c53d2150...@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: [NF] Open systems Drive you crazy
Steve - pretty Cool Arse video! I especially got a kick out of one shot about 1:40 in which shows Zortrax 3D Printers being used for his devices. I will continue to watch the rest of the video piecemeal - as its definitely interesting! -K- -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, October 31, 2017 3:00 PM To: profoxt...@leafe.com Subject: [NF] Open systems Drive you crazy Great watch here. Super Hacker George Hotz: I Can Make Your Car Drive Itself for Under $1,000 https://www.youtube.com/watch?v=aqdYbwY9vPU I like how he looks at a problem. -- Stephen Russell ___ 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/80838f1ca795b14ea1af48659f35166f19068...@drexch02.corp.globetax.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.
[NF] Open systems Drive you crazy
Great watch here. Super Hacker George Hotz: I Can Make Your Car Drive Itself for Under $1,000 https://www.youtube.com/watch?v=aqdYbwY9vPU I like how he looks at a problem. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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/CAJidMYKm_7=vdjsg0vz7hgphi9wemtu+cjdor_bigoboorz...@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: VFP10 Advanced was FoxPro DevCon in Frankfurt
+1 On 31-Oct-2017 6:08 PM, Dave Crozier wrote: Thanks w00dy, As usual an excellent answer to many questions that lots of VFPers will have Dave --- -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: 31 October 2017 12:29 To: 'ProFox Email List'Subject: AW: VFP10 Advanced was FoxPro DevCon in Frankfurt Basically, the moniker "VFPA" is three things: a) the regular 32Bit VFP9 enginge, patched with 30+ bugfixes b) same as a), but with a 64bit engine c) a true 64bit compiler, which doesn't need the runtime etc BTW, the "A" in VFPA is the next HEX sign after 9, or a 10 in Dec. But it also fits with the "Advanced" tag :) VFPA is already around since several years, and Mr.Chen seems to be very knowledgable with Assembler and debugging C++ machinecode :) Personally I use the regular 32bit version without any problems at my customers site. It behaves just as a usual VFP9 without some quirks. I was bitten by those report-engine bugs as well as the Grid-Optimize problem, and with VFPA this stuff just works. You just do a "recompile all" on your project, put your EXE and that single VFPAR.DLL to your customer and that's all. One caveat: VFPA hast he language-Resource-DLL included, thus you need different VFPAR.dll for different langauges. (Personally I don't like that approach, since you can't run in a multi-language scenario anymore, where VFP picks the language DLL according to the user settings) Also I'm not really convinced about the need for the 64bit version. At least not for existing desktop applications. As soon as you have some FLLs or OCXs included, you're basically toasted, since you need those as a 64bit version. Since most of the VFP specific addons are already 15 years old, the chances to get those vendors to compile their old stuff into a 64bit version are somewhat desillusional. Then: what do you gain from a 64bit version? You don't get over the 2Gb limit for DBFs, it's just that it can address more RAM. Ok, when did you ran out of RAM with a VFP version, where the engine was built to work even on PCs with as little as 64MB RAM?You also have a marketing plus, because you're now a native 64bit app. And it may run a little bit faster because of the unneeded 32Bit layer in Windows. As long as you don't need any of your old addons But it does have a valid usecase for Middle-tier applications, like ActiveFoxProPages or AFPX or FIC, where the VFP engine connects directly to 64bit WebServers. BTW: @ChristofWollenhaupt: did you already compiled the AFP engine with VFPA? The third option, a true compiler, is stil work in progress. It does work, but stil has the same restrictions as option b). Mr.Chen is working to enhance the limitations at various parts like max. Stringlength, max DBF size etc, but there are a lot of complications. 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/df8767de-ca77-14b0-e79b-f7d25093e...@hawthorncottage.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: [NF] INT vs MEDIUMINT vs SMALLINT vs TINYINT
Here is a good video for B+ tree, and how they operate. https://www.youtube.com/watch?v=tY9xu3vuZ10 About 5 min in it gets to the demonstration of the science. The creation of leaves and how things can bounce around you insert. Just think of Guid, where you are inserting into branches that have 50 or 5,000 are all different, C7948B8E-9B98-48C0-B2EA-11DB5474A99D, 0639AB12-9B34-4A86-9C76-13A38B587C20, 0D14D7A2-DFBA-41C4-9102-14AAB2F77F6D and A59F2BA2-4CBF-4E70-B5E3-20F4E7C577DA. Adding data to the end of the index has a little performance, but adding all over the place you can get into leaf/page tears and resetting of headers on leaves. This is the performance I was referring to. In SQL you can define your fillfactor that is "free-space" in your index as it rebuilds. Some tables will do well for a lower fillfactor, or more free space for future inserts when you have any sort of character data. A higher value for auto inc column of INT. When you get an analysis of queries and it says Index Seek, Index Scan the Seek used the these b+tree headers to find the location, and the index scan scans the entire index to find the data you desire. Redundant values in a status column are a seek and not a scan because the variety of OPEN/Closed is very limited. You can seriously spend way too much time attempting to tune these suckers and as they grow over time you have to come back and tune again. :) Tuning with 5,000 rows and in two years you have 1,500,000 rows you may need to come back and verify a process is still in good shape. On Tue, Oct 31, 2017 at 6:33 AM, Frank Cazabonwrote: > Morning Stephen, > > What do you mean by "pound script this"? Do you mean to run it over and > over? > > I did that I get the SeqCol coming out in order increasing as per your > example with the first couple characters in the SeqCol changing and the > rest the same. > > I still don't understand your last 2 paragraphs. As I understood this when > I researched it each new insert means it goes to the end so is always being > added at the end so no paging complexity is involved. Could you clarify > this for me, please? > > Frank. > > Frank Cazabon > > > On 30/10/2017 03:26 PM, Stephen Russell wrote: > >> Frank, that puts the logic at the rdbms engine and no longer in your app, >> in-front of your data. >> >> In reality, you get data all over the place but this bunch will be close. >> Pound script this a few times and you will see the leading values are what >> changes an not the last 4-5-6 characters. >> >> CREATE TABLE GUID_Example >> ( >> SeqCol uniqueidentifier DEFAULT NewSequentialID() >> ,IDCol uniqueidentifier DEFAULT NEWID(),) >> Inserting five default values in table >> INSERT INTO GUID_Example DEFAULT >> VALUES >> INSERT INTO GUID_Example DEFAULT >> VALUES >> INSERT INTO GUID_Example DEFAULT >> VALUES >> INSERT INTO GUID_Example DEFAULT >> VALUES >> - >> SELECT * >> FROM GUID_Example >> >> Clean up database >> >> DROP TABLE GUID_Example >> >> I got this as output : >> SeqCol >> IDCol >> 1E54CB01-A7BD-E711-9C54-D481D71992B4 120C2AD7-ECF1-487F-BE56-0FD36A78237F >> 1F54CB01-A7BD-E711-9C54-D481D71992B4 E6F5D7B5-61F8-4FD3-988B-F0949A029E29 >> 2054CB01-A7BD-E711-9C54-D481D71992B4 B5C05851-FBA5-4DD7-864A-133EE1BC6C68 >> 2154CB01-A7BD-E711-9C54-D481D71992B4 638865DA-F2E4-4101-9534-E3DB83A0008E >> >> When the performance goes to insert all over the index pages where there >> is >> a lot of available room you may not have a performance hit at all. On the >> flip side using the newsequentialID it may make a compound insert into a >> page that was starting to get tight and now is tight. >> >> Please remember folks that Fkey index is also a component in the insert >> event as well. The more indexes you maintain that you >> really don't need, do get in your way on any platform. >> >> >> >> >> >> >> >> On Mon, Oct 30, 2017 at 1:23 PM, Frank Cazabon >> wrote: >> >> I believe NewSequentialID() in SQL Server (or the UuidCreateSequential API >>> call) avoids the paging problem behind Guids. >>> >>> Frank. >>> >>> Frank Cazabon >>> >>> >>> On 30/10/2017 02:17 PM, Stephen Russell wrote: >>> >>> Good URLs you presented. To me from a performance POV the INSERT of the GUID is the only downside with respect to the index. It has to identify the page and add itself to there. If need be it will tear the page and generate two pages with access holes to accept new index-data going forward. Next. you look at the type of data you are presenting via a velocity of inserts. Are your inserts per min to a table > 10,000? If so the GUID may be the wrong thing. Think of eBay in the closing seconds of an auction, or your stock trader in changes in the market generating A LOT of transactions. These situations are where next int is best because it
RE: VFP10 Advanced was FoxPro DevCon in Frankfurt
Thanks w00dy, As usual an excellent answer to many questions that lots of VFPers will have Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: 31 October 2017 12:29 To: 'ProFox Email List'Subject: AW: VFP10 Advanced was FoxPro DevCon in Frankfurt Basically, the moniker "VFPA" is three things: a) the regular 32Bit VFP9 enginge, patched with 30+ bugfixes b) same as a), but with a 64bit engine c) a true 64bit compiler, which doesn't need the runtime etc BTW, the "A" in VFPA is the next HEX sign after 9, or a 10 in Dec. But it also fits with the "Advanced" tag :) VFPA is already around since several years, and Mr.Chen seems to be very knowledgable with Assembler and debugging C++ machinecode :) Personally I use the regular 32bit version without any problems at my customers site. It behaves just as a usual VFP9 without some quirks. I was bitten by those report-engine bugs as well as the Grid-Optimize problem, and with VFPA this stuff just works. You just do a "recompile all" on your project, put your EXE and that single VFPAR.DLL to your customer and that's all. One caveat: VFPA hast he language-Resource-DLL included, thus you need different VFPAR.dll for different langauges. (Personally I don't like that approach, since you can't run in a multi-language scenario anymore, where VFP picks the language DLL according to the user settings) Also I'm not really convinced about the need for the 64bit version. At least not for existing desktop applications. As soon as you have some FLLs or OCXs included, you're basically toasted, since you need those as a 64bit version. Since most of the VFP specific addons are already 15 years old, the chances to get those vendors to compile their old stuff into a 64bit version are somewhat desillusional. Then: what do you gain from a 64bit version? You don't get over the 2Gb limit for DBFs, it's just that it can address more RAM. Ok, when did you ran out of RAM with a VFP version, where the engine was built to work even on PCs with as little as 64MB RAM?You also have a marketing plus, because you're now a native 64bit app. And it may run a little bit faster because of the unneeded 32Bit layer in Windows. As long as you don't need any of your old addons But it does have a valid usecase for Middle-tier applications, like ActiveFoxProPages or AFPX or FIC, where the VFP engine connects directly to 64bit WebServers. BTW: @ChristofWollenhaupt: did you already compiled the AFP engine with VFPA? The third option, a true compiler, is stil work in progress. It does work, but stil has the same restrictions as option b). Mr.Chen is working to enhance the limitations at various parts like max. Stringlength, max DBF size etc, but there are a lot of
AW: VFP10 Advanced was FoxPro DevCon in Frankfurt
Basically, the moniker "VFPA" is three things: a) the regular 32Bit VFP9 enginge, patched with 30+ bugfixes b) same as a), but with a 64bit engine c) a true 64bit compiler, which doesn't need the runtime etc BTW, the "A" in VFPA is the next HEX sign after 9, or a 10 in Dec. But it also fits with the "Advanced" tag :) VFPA is already around since several years, and Mr.Chen seems to be very knowledgable with Assembler and debugging C++ machinecode :) Personally I use the regular 32bit version without any problems at my customers site. It behaves just as a usual VFP9 without some quirks. I was bitten by those report-engine bugs as well as the Grid-Optimize problem, and with VFPA this stuff just works. You just do a "recompile all" on your project, put your EXE and that single VFPAR.DLL to your customer and that's all. One caveat: VFPA hast he language-Resource-DLL included, thus you need different VFPAR.dll for different langauges. (Personally I don't like that approach, since you can't run in a multi-language scenario anymore, where VFP picks the language DLL according to the user settings) Also I'm not really convinced about the need for the 64bit version. At least not for existing desktop applications. As soon as you have some FLLs or OCXs included, you're basically toasted, since you need those as a 64bit version. Since most of the VFP specific addons are already 15 years old, the chances to get those vendors to compile their old stuff into a 64bit version are somewhat desillusional. Then: what do you gain from a 64bit version? You don't get over the 2Gb limit for DBFs, it's just that it can address more RAM. Ok, when did you ran out of RAM with a VFP version, where the engine was built to work even on PCs with as little as 64MB RAM?You also have a marketing plus, because you're now a native 64bit app. And it may run a little bit faster because of the unneeded 32Bit layer in Windows. As long as you don't need any of your old addons But it does have a valid usecase for Middle-tier applications, like ActiveFoxProPages or AFPX or FIC, where the VFP engine connects directly to 64bit WebServers. BTW: @ChristofWollenhaupt: did you already compiled the AFP engine with VFPA? The third option, a true compiler, is stil work in progress. It does work, but stil has the same restrictions as option b). Mr.Chen is working to enhance the limitations at various parts like max. Stringlength, max DBF size etc, but there are a lot of complications. 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/00b501d35243$ccd194d0$6674be70$@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: VFP10 Advanced was FoxPro DevCon in Frankfurt
Just seen I was looking at the wrong prices and it does have a free version. I'll give it a look unless anyone has some review details of it. Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 31 October 2017 11:37 To: ProFox Email ListSubject: RE: VFP10 Advanced was FoxPro DevCon in Frankfurt At nearly £1,200 pounds sterling it isn't exactly cheap for a product that isn't mainstream! I didn't pay that for CA Visual Objects and that went the way of the software scrap bin. Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 31 October 2017
RE: VFP10 Advanced was FoxPro DevCon in Frankfurt
At nearly £1,200 pounds sterling it isn't exactly cheap for a product that isn't mainstream! I didn't pay that for CA Visual Objects and that went the way of the software scrap bin. Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 31 October 2017 10:52 To: profoxt...@leafe.com Subject: Re: VFP10 Advanced was FoxPro DevCon in Frankfurt > Another false dawn{ :-) } and Craig seems to have unfortunately > disappeared off the VFP scene over the last few years after producing > some brilliant work. > You should look at XSharp as it's effectively what VFP Studio could have become. -- 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/1509447109.2727743.1156659792.73121...@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. ___ 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/18725b8cd2d5d247873a2baf401d4ab2b48cd...@ex2010-a-fpl.fpl.LOCAL ** 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: [NF] INT vs MEDIUMINT vs SMALLINT vs TINYINT
Morning Stephen, What do you mean by "pound script this"? Do you mean to run it over and over? I did that I get the SeqCol coming out in order increasing as per your example with the first couple characters in the SeqCol changing and the rest the same. I still don't understand your last 2 paragraphs. As I understood this when I researched it each new insert means it goes to the end so is always being added at the end so no paging complexity is involved. Could you clarify this for me, please? Frank. Frank Cazabon On 30/10/2017 03:26 PM, Stephen Russell wrote: Frank, that puts the logic at the rdbms engine and no longer in your app, in-front of your data. In reality, you get data all over the place but this bunch will be close. Pound script this a few times and you will see the leading values are what changes an not the last 4-5-6 characters. CREATE TABLE GUID_Example ( SeqCol uniqueidentifier DEFAULT NewSequentialID() ,IDCol uniqueidentifier DEFAULT NEWID(),) Inserting five default values in table INSERT INTO GUID_Example DEFAULT VALUES INSERT INTO GUID_Example DEFAULT VALUES INSERT INTO GUID_Example DEFAULT VALUES INSERT INTO GUID_Example DEFAULT VALUES - SELECT * FROM GUID_Example Clean up database DROP TABLE GUID_Example I got this as output : SeqCol IDCol 1E54CB01-A7BD-E711-9C54-D481D71992B4 120C2AD7-ECF1-487F-BE56-0FD36A78237F 1F54CB01-A7BD-E711-9C54-D481D71992B4 E6F5D7B5-61F8-4FD3-988B-F0949A029E29 2054CB01-A7BD-E711-9C54-D481D71992B4 B5C05851-FBA5-4DD7-864A-133EE1BC6C68 2154CB01-A7BD-E711-9C54-D481D71992B4 638865DA-F2E4-4101-9534-E3DB83A0008E When the performance goes to insert all over the index pages where there is a lot of available room you may not have a performance hit at all. On the flip side using the newsequentialID it may make a compound insert into a page that was starting to get tight and now is tight. Please remember folks that Fkey index is also a component in the insert event as well. The more indexes you maintain that you really don't need, do get in your way on any platform. On Mon, Oct 30, 2017 at 1:23 PM, Frank Cazabonwrote: I believe NewSequentialID() in SQL Server (or the UuidCreateSequential API call) avoids the paging problem behind Guids. Frank. Frank Cazabon On 30/10/2017 02:17 PM, Stephen Russell wrote: Good URLs you presented. To me from a performance POV the INSERT of the GUID is the only downside with respect to the index. It has to identify the page and add itself to there. If need be it will tear the page and generate two pages with access holes to accept new index-data going forward. Next. you look at the type of data you are presenting via a velocity of inserts. Are your inserts per min to a table > 10,000? If so the GUID may be the wrong thing. Think of eBay in the closing seconds of an auction, or your stock trader in changes in the market generating A LOT of transactions. These situations are where next int is best because it always going to the last page of the index. If you are not in that type of data environment you can do either with no problem. M$ loves using GUID in their internal systems like CRM or SharePoint. It is Massive GUID driven in all of the tables. On Mon, Oct 30, 2017 at 12:42 PM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: On 2017-10-30 11:09, Stephen Russell wrote: Less efficient indexes? Are you talking about space in a db compared to an int for a pointer or are you saying that the time to isolate the data on that row because of the data type of the pointer? The flip side is data insertion. Can you tell us why you use less efficient? Not sure of your wording, if you meant exactly that or not, so let me try to respond: I like the guid v(40) indexes because if ever I needed to combine data, I'm not running into duplicate keys. Plus, I like defining the key ahead of time and having complete control so I can work with parent/child/grandchild datasets easier (than if I had to contend with auto-inc keys). The negative of this approach as I understood it is that the since the index is 4x larger in size than a 4-byte integer key, it would not be as efficient in memory, and the index tree needs reindexing more often so as to be balanced. Plenty of good article on the interweb discussing both: http://www.ovaistariq.net/733/understanding-btree-indexes-an d-how-they-impact-performance/#.WfdQDHYpCJA https://blog.codinghorror.com/primary-keys-ids-versus-guids/ http://web.archive.org/web/20150511162734/http://databases. aspfaq.com/database/what-should-i-choose-for-my-primary-key.html I think I'll stick with app-generated GUIDs though for the portability and no-collision benefit if I merged/move data. I also want to do replication where their database is stored locally but then replicates to a master database outside their office. [excessive quoting removed by server]
Re: VFP10 Advanced was FoxPro DevCon in Frankfurt
> Another false dawn{ :-) } and Craig seems to have unfortunately > disappeared off the VFP scene over the last few years after producing > some brilliant work. > You should look at XSharp as it's effectively what VFP Studio could have become. -- 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/1509447109.2727743.1156659792.73121...@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: VFP10 Advanced was FoxPro DevCon in Frankfurt
In my last job (as in last not previous ) I wrote an interface to a time recording system that sort of was and wasn't VFP - It was written in C, included the C libraries for all the VFP interface calls, and the rest was sort of VFP pseudo-code using function calls in place of VFP commands (a little bit reminiscent of Clipper). On 31-Oct-2017 3:38 PM, Dave Crozier wrote: Apologies, as pro_ext.h is obviously globally available if you wish to do any interfacing to VFP... I have used it before but years ago and in a very rudimentary way so access by Microsoft is obviously allowed. Mr Chen must simply be a very, very intelligent and talented individual!! Dave --- ___ 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/bcac45e6-ff9e-e309-12a1-9abd01055...@hawthorncottage.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: VFP10 Advanced was FoxPro DevCon in Frankfurt
Dave, I saw a notification of a new message just as I had hit send. I have seen some of the messages on foxite and the impression I get is that there are some bug fixes in vfpA and better 64 support. However, it doesn't change the core runtimes, but I could be wrong there. Paul On Tue, Oct 31, 2017 at 9:13 PM, Dave Crozierwrote: > Paul, > I was a little hasty in my response (see previous post which pre-empted > yours) and stand corrected. > > As stated I did some work interfacing C++ into VFP 7 but is was a lifetime > ago ... or seems like that! > > Even the thought of it brings shudders to my spine. > > Dave > > > > --- > 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. > > Flexipol Packaging Ltd. > Unit 14 Bentwood Road > Carrs > Industrial Estate > Haslingden > Rossendale > Lancashire > BB4 5HH > > Tel:01706-222792 > Fax: 01706-224683 > www.Flexipol.co.uk > --- > > 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul Hemans > Sent: 31 October 2017 10:10 > To: ProFox Email List > Subject: Re: VFP10 Advanced was FoxPro DevCon in Frankfurt > > Dave > https://msdn.microsoft.com/en-us/library/aa975726(v=vs.71).aspx > > To use the header file and create a compiled library, you need: > >- The header file Pro_ext.h. You can print this file to see the function >declarations, typedefs, and structs used in the Visual FoxPro API. >- The file Winapims.lib. > > Both of these files are installed in the API subdirectory when you install > Visual FoxPro. > > Nothing fishy there. > > On Tue, Oct 31, 2017 at 8:57 PM, Dave Crozier > wrote: > > > Posts from 'Mr Chen' in Foxite... he/she obviously know their stuff > > and have been developing for a good while. > > > > https://www.foxite.com/members/default.aspx?id=4e637c9c-b764-4c9d-99d8 > > - > > 0dfddba20427 > > > > > > if you look at his post on the Report Footer fix > > > > http://www.baiyujia.com/vfpdocuments/f_vfp9fix.asp > > > > he actually shows code to "pro_ext.h" with Copyright to Microsoft > > Corporation. Surely this code wouldn't be legitimately available for > > duplication or modification. Hence my suspect mind as to how the code > > was obtained. Either that or I'm becoming a very cynical human being!! > > > > Dave > > > > > > > > > > --- > > 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
RE: VFP10 Advanced was FoxPro DevCon in Frankfurt
Wow, Just looked and Craig's VFP Studio in association with Bo Durban was almost 10 years ago!!! Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 31 October 2017 10:32 To: ProFox Email ListSubject: RE: VFP10 Advanced was FoxPro DevCon in Frankfurt Andy, Yes it has started a bit of a buzz. However I remember the sadly departed Allen and myself having a similar discussion about a similar product from a company called Ecologica (I think) which seemed to fizzle out about the same time that Craig Boyd announced that his VFP Studio product would be about 4 months away!. https://www.sweetpotatosoftware.com/blog/index.php/2008/02/20/vfp-studio-code-editor-screencast/ Another false dawn{ :-) } and Craig seems to have unfortunately disappeared off the VFP scene over the last few years after producing some brilliant work. Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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
RE: VFP10 Advanced was FoxPro DevCon in Frankfurt
Andy, Yes it has started a bit of a buzz. However I remember the sadly departed Allen and myself having a similar discussion about a similar product from a company called Ecologica (I think) which seemed to fizzle out about the same time that Craig Boyd announced that his VFP Studio product would be about 4 months away!. https://www.sweetpotatosoftware.com/blog/index.php/2008/02/20/vfp-studio-code-editor-screencast/ Another false dawn{ :-) } and Craig seems to have unfortunately disappeared off the VFP scene over the last few years after producing some brilliant work. Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of AndyHC Sent: 31 October 2017 10:25 To: profox@leafe.com Subject: Re: VFP10 Advanced was FoxPro DevCon in Frankfurt Dave, don't forget there's a lot of stuff in xsource. and it's good to see I stirred up some interest in baiyujia.com On 31-Oct-2017 3:27 PM, Dave Crozier wrote: > Posts from 'Mr Chen' in Foxite... he/she obviously know their stuff and have > been developing for a good while. > > https://www.foxite.com/members/default.aspx?id=4e637c9c-b764-4c9d-99d8-0dfddba20427 > > > if you look at his post on the Report Footer fix > > http://www.baiyujia.com/vfpdocuments/f_vfp9fix.asp > > he actually shows code to "pro_ext.h" with Copyright to Microsoft > Corporation. Surely this code wouldn't be legitimately available for > duplication or modification. Hence my suspect mind as to how the code was > obtained. Either that or I'm becoming a very cynical human being!! > > Dave > > > > > --- > > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier > Sent: 31 October 2017 09:29 > To: ProFox Email List> Subject: RE: VFP10 Advanced was FoxPro DevCon in Frankfurt > > Either these guys are very, very, very bright or there just COULD have been > some industrial espionage going on here I think. > > They do seem to have so much in depth information about the inner workings of > VFP and the layout/composition of the existing VFP Code Base. > > Just a thought but not complaining though if it works! > > Dave > > > > > --- > 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
Re: VFP10 Advanced was FoxPro DevCon in Frankfurt
Dave, don't forget there's a lot of stuff in xsource. and it's good to see I stirred up some interest in baiyujia.com On 31-Oct-2017 3:27 PM, Dave Crozier wrote: Posts from 'Mr Chen' in Foxite... he/she obviously know their stuff and have been developing for a good while. https://www.foxite.com/members/default.aspx?id=4e637c9c-b764-4c9d-99d8-0dfddba20427 if you look at his post on the Report Footer fix http://www.baiyujia.com/vfpdocuments/f_vfp9fix.asp he actually shows code to "pro_ext.h" with Copyright to Microsoft Corporation. Surely this code wouldn't be legitimately available for duplication or modification. Hence my suspect mind as to how the code was obtained. Either that or I'm becoming a very cynical human being!! Dave --- -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 31 October 2017 09:29 To: ProFox Email ListSubject: RE: VFP10 Advanced was FoxPro DevCon in Frankfurt Either these guys are very, very, very bright or there just COULD have been some industrial espionage going on here I think. They do seem to have so much in depth information about the inner workings of VFP and the layout/composition of the existing VFP Code Base. Just a thought but not complaining though if it works! Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt at VR-FX Sent: 30 October 2017 17:37 To: profox@leafe.com Subject: Re: VFP10 Advanced was FoxPro DevCon in Frankfurt I was surprised to read about this today - had not even heard of it till now. Very interesting indeed! -K- On 10/30/2017 1:05 PM, Dave Crozier wrote: About time we had a discussion section for this. Must admit it had flown under my radar until the reference to it was posted here. Any more information from anyone may be welcome to us all. Dave ___ 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/92cb2680-8209-4781-002c-871a49c76...@hawthorncottage.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: VFP10 Advanced was FoxPro DevCon in Frankfurt
Apologies, as pro_ext.h is obviously globally available if you wish to do any interfacing to VFP... I have used it before but years ago and in a very rudimentary way so access by Microsoft is obviously allowed. Mr Chen must simply be a very, very intelligent and talented individual!! Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 31 October 2017 09:57 To: ProFox Email ListSubject: RE: VFP10 Advanced was FoxPro DevCon in Frankfurt Posts from 'Mr Chen' in Foxite... he/she obviously know their stuff and have been developing for a good while. https://www.foxite.com/members/default.aspx?id=4e637c9c-b764-4c9d-99d8-0dfddba20427 if you look at his post on the Report Footer fix http://www.baiyujia.com/vfpdocuments/f_vfp9fix.asp he actually shows code to "pro_ext.h" with Copyright to Microsoft Corporation. Surely this code wouldn't be legitimately available for duplication or modification. Hence my suspect mind as to how the code was obtained. Either that or I'm becoming a very cynical human being!! Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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
RE: VFP10 Advanced was FoxPro DevCon in Frankfurt
Paul, I was a little hasty in my response (see previous post which pre-empted yours) and stand corrected. As stated I did some work interfacing C++ into VFP 7 but is was a lifetime ago ... or seems like that! Even the thought of it brings shudders to my spine. Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul Hemans Sent: 31 October 2017 10:10 To: ProFox Email ListSubject: Re: VFP10 Advanced was FoxPro DevCon in Frankfurt Dave https://msdn.microsoft.com/en-us/library/aa975726(v=vs.71).aspx To use the header file and create a compiled library, you need: - The header file Pro_ext.h. You can print this file to see the function declarations, typedefs, and structs used in the Visual FoxPro API. - The file Winapims.lib. Both of these files are installed in the API subdirectory when you install Visual FoxPro. Nothing fishy there. On Tue, Oct 31, 2017 at 8:57 PM, Dave Crozier wrote: > Posts from 'Mr Chen' in Foxite... he/she obviously know their stuff > and have been developing for a good while. > > https://www.foxite.com/members/default.aspx?id=4e637c9c-b764-4c9d-99d8 > - > 0dfddba20427 > > > if you look at his post on the Report Footer fix > > http://www.baiyujia.com/vfpdocuments/f_vfp9fix.asp > > he actually shows code to "pro_ext.h" with Copyright to Microsoft > Corporation. Surely this code wouldn't be legitimately available for > duplication or modification. Hence my suspect mind as to how the code > was obtained. Either that or I'm becoming a very cynical human being!! > > Dave > > > > > --- > 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. > > Flexipol Packaging Ltd. > Unit 14 Bentwood Road > Carrs > Industrial Estate > Haslingden > Rossendale > Lancashire > BB4 5HH > >
Re: VFP10 Advanced was FoxPro DevCon in Frankfurt
Dave https://msdn.microsoft.com/en-us/library/aa975726(v=vs.71).aspx To use the header file and create a compiled library, you need: - The header file Pro_ext.h. You can print this file to see the function declarations, typedefs, and structs used in the Visual FoxPro API. - The file Winapims.lib. Both of these files are installed in the API subdirectory when you install Visual FoxPro. Nothing fishy there. On Tue, Oct 31, 2017 at 8:57 PM, Dave Crozierwrote: > Posts from 'Mr Chen' in Foxite... he/she obviously know their stuff and > have been developing for a good while. > > https://www.foxite.com/members/default.aspx?id=4e637c9c-b764-4c9d-99d8- > 0dfddba20427 > > > if you look at his post on the Report Footer fix > > http://www.baiyujia.com/vfpdocuments/f_vfp9fix.asp > > he actually shows code to "pro_ext.h" with Copyright to Microsoft > Corporation. Surely this code wouldn't be legitimately available for > duplication or modification. Hence my suspect mind as to how the code was > obtained. Either that or I'm becoming a very cynical human being!! > > Dave > > > > > --- > 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. > > Flexipol Packaging Ltd. > Unit 14 Bentwood Road > Carrs > Industrial Estate > Haslingden > Rossendale > Lancashire > BB4 5HH > > Tel:01706-222792 > Fax: 01706-224683 > www.Flexipol.co.uk > --- > > 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier > Sent: 31 October 2017 09:29 > To: ProFox Email List > Subject: RE: VFP10 Advanced was FoxPro DevCon in Frankfurt > > Either these guys are very, very, very bright or there just COULD have > been some industrial espionage going on here I think. > > They do seem to have so much in depth information about the inner workings > of VFP and the layout/composition of the existing VFP Code Base. > > Just a thought but not complaining though if it works! > > Dave > > > > > --- > 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
RE: VFP10 Advanced was FoxPro DevCon in Frankfurt
Posts from 'Mr Chen' in Foxite... he/she obviously know their stuff and have been developing for a good while. https://www.foxite.com/members/default.aspx?id=4e637c9c-b764-4c9d-99d8-0dfddba20427 if you look at his post on the Report Footer fix http://www.baiyujia.com/vfpdocuments/f_vfp9fix.asp he actually shows code to "pro_ext.h" with Copyright to Microsoft Corporation. Surely this code wouldn't be legitimately available for duplication or modification. Hence my suspect mind as to how the code was obtained. Either that or I'm becoming a very cynical human being!! Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 31 October 2017 09:29 To: ProFox Email ListSubject: RE: VFP10 Advanced was FoxPro DevCon in Frankfurt Either these guys are very, very, very bright or there just COULD have been some industrial espionage going on here I think. They do seem to have so much in depth information about the inner workings of VFP and the layout/composition of the existing VFP Code Base. Just a thought but not complaining though if it works! Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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
RE: VFP10 Advanced was FoxPro DevCon in Frankfurt
Either these guys are very, very, very bright or there just COULD have been some industrial espionage going on here I think. They do seem to have so much in depth information about the inner workings of VFP and the layout/composition of the existing VFP Code Base. Just a thought but not complaining though if it works! Dave --- 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. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --- 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: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt at VR-FX Sent: 30 October 2017 17:37 To: profox@leafe.com Subject: Re: VFP10 Advanced was FoxPro DevCon in Frankfurt I was surprised to read about this today - had not even heard of it till now. Very interesting indeed! -K- On 10/30/2017 1:05 PM, Dave Crozier wrote: > About time we had a discussion section for this. > Must admit it had flown under my radar until the reference to it was posted > here. > Any more information from anyone may be welcome to us all. > Dave > ___ 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/058c3dce-66d0-ea51-8071-e04757f5e...@optonline.net ** 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. ___ 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/18725b8cd2d5d247873a2baf401d4ab2b48cd...@ex2010-a-fpl.fpl.LOCAL ** 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.