ProFox

profox@leafe.com

2704 discussions

Memo bloat
by Paul Newton 27 May '20

27 May '20

Hi all I have a table with a memo field. It contains ca. 970 records and the size of the FPT is ca 230KB. I added 161 records to the table, populating the memo field with several lines of text (the total size of all the text added was ca 700KB). In each case the memo field was a single replace (no memo = memo + ..., no replace memo with .... Additive). The FPT ended up as 234MB but a PACK MEMO reduced this to ca 935KB. The trouble is that this is a widely used table in a multi-user environment and it would be impractical to use PACK MEMO on a regular basis. Blocksize is set to 64. Any suggestions or comments would be very welcome. Thanks in advance. Paul Newton

7 10

AW: Memo bloat
by Jürgen Wondzinski 26 May '20

26 May '20

Just to add a little tidbit information for "why is this FPT behaviour done that way": In the early days of dBase / FoxBase, computers only has those 640kB of RAM, from which only about 500 or so have been usable. And in FoxBase we had whopping 64kB as reserved space for variables. Some of us might still remember that time :) With the invention of MultiUser programming we learned to GATHER/SCATTER our tablefields to temporarily keep a copy in memory as well as revert data in case of problems. The same approach is used internally by the dataengine: To be able to revert interactive changes, the engine has to save a copy of the fields. That approach works well with standard C/N/D/L fields, but what to do with Memofields, which even at those dark ages already had a maximum of lunatic 2 GigaWatts, err GigaBytes? You can't just copy 2 GBytes to a MemVar (with 640k Memory!) Thus they decided to approach a different path for editing Memos: Memofields get always edited at disklevel, in contrast to Charfields, which get edited on a MemVar. To get Multiuser working, they always locked the original Memoblock(s), copied the content to the end of the memofile and edited there. If the user reverts the edit, then they just scrap the just appended junk and release the lock on the original memoblock(s), but if the user saves the changes, then the new blocknumber is recorded in the DBF field-pointer, and the old memoblocks are then no more referenced, thus leaving them in the memofile as junk or useless filler. Thus, with every edit a FPT will always grow for the size of the original blocks (plus the blocks to fit additional edits), and it always grows in multiples of the allocated blocksize. At VFP8 betatest times (as far as I remember) they tried to change that behaviour of "always copy to a new block" to only occur if the table is used sharable. In VFP9 this is not the case, a FPT also grows in exclusive mode. The above revert-logic also debunks the "if the edit isn't changing the original length, it will not grow" myth :) . The block size is just a preallocated tablespace for your edit. It also pays to analyze the best blocksize-setting for your data and do a SET BLOCKSIZE TO x before creating a new FPT (you cannot change the blocksize of an existing FPT). There's a gotcha here: Values from 1 to 32 are Multiples of 512 Bytes (which therefor results to blocksizes from 512 Bytes to 16384 Bytes), and from 33 to 32768 they are taken literally. (Default is 64 bytes). A value of 0 results in "no preallocated blocksize", the block grows as needed, but will therefor always get appended. Blocksize 0 is used on all Metadata files (SCX, MPX, VCX, FRX etc) Another gotcha: ? SET("BLOCK") just tells you the setting for newly created MemoTables, you need to use SYS(2012) to get the blocksize of the currrent table. BTW 1: It also is not possible to do some sort of recycling those dead junkspaces in a FPT, since you don't know beforehand how big the needed space would be to store your new data and find a fitting dead space. BTW 2: Blocks are always used in consecutive sequence, there's no way to connect several fragments spread over the FPT. Only the first blocknumber gets stored in the DBF-to-FPT pointerfield. That's why we have the PACK MEMO command, which just copies the referenced block-chains to a new file. -----Ursprüngliche Nachricht----- Von: ProFox <profox-bounces(a)leafe.com> Im Auftrag von Christof Wollenhaupt Gesendet: Dienstag, 26. Mai 2020 16:09 An: ProFox Mailinglist <profox(a)leafe.com> Betreff: Re: [SPAM] Memo bloat Hi Alan, > If the changed data in bytes > blocksize then it will add a new block. If you keep the changes < blocksize then it will re-use the same space. The trouble is with a blocksize of 64, it's very likely that it will almost always be adding blocks. That would be very thoughtful of VFP, indeed, but it's unfortunately not what is happening: Set Blocksize To 64 Create Table memotest (memofield M) Use memotest shared Insert into memotest values ("1234567890") Use Dir like memotest.fpt ? Use memotest shared Replace memofield with "54321" Use Dir like memotest.fpt ? Use memotest shared Replace memofield with "1234567890" Use Dir like memotest.fpt The code replaces the same field with a shorter string, then with a longer string. All strings are way below the blocksize. Yet, each time the FPT file grows by 64 bytes. -- Christof

1 0

Paradox data viewer and exporter?
by Kevin Cully 25 May '20

25 May '20

I just heard from our CIO that there is a old Paradox system that they would like to export some data to Excel. She's not able to connect to the Paradox tables via a vendor supplied ODBC connection. It might be a version issue or perhaps she doesn't have all of the data tables properly downloaded. Has anyone used a Paradox Data Viewer to export the data that they can recommend? Thank you, ahead of time. -Kevin

3 3

[NF] gmail tracker
by Charles Hart Enzer, M.D. 20 May '20

20 May '20

Recommendations for Gmail Tracking? - Who - Who with multiple recipients - When - Frequency Thank you. -- *Shai / שי **Charles Hart Enzer, MD(Retired, **Ohio**), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html#Publications> *Retirement is **not What You are Retiring from* *Retirement is about What You are Retiring to* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 3

[NF] Gmail Tracking
by Charles Hart Enzer, M.D. 18 May '20

18 May '20

Recommendations for Gmail Tracking? - Who - Who with multiple recipients - When - Frequency Thank you. -- *Shai / שי **Charles Hart Enzer, MD(Retired, **Ohio**), FAACAP* *Aliyah <https://app.mailtag.io/link-event-v2?mt__id=b34e893c-a4da-4b77-acb7-19613ba…>: Cincinnati to Jerusalem <https://app.mailtag.io/link-event-v2?mt__id=04498e88-d542-469d-9daa-15179a6…>'s German Colony <https://app.mailtag.io/link-event-v2?mt__id=23bd2e45-6152-489a-a24e-a957622…> May 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <https://app.mailtag.io/link-event-v2?mt__id=822d2df9-6fce-4c89-8640-551fa53…>* *Publications* <https://app.mailtag.io/link-event-v2?mt__id=5d490ca9-4e3a-4acb-8841-fb9e9af…> *Retirement is **not What You are Retiring from* *Retirement is about What You are Retiring to* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

[NF] Ideal language/Framework for web-based functionality like off-line views?
by Ted Roche 10 May '20

10 May '20

Calling on the collective wisdom for some technical recommendations. There are only a few hard problems in computer science and offline master-master server replication is one of them... The charity I'm trying to help has a single-user FPW app currently. When a second user wants to add data, the Master user has to export lists of available serial numbers and export the existing inventory, the non-master user imports those files, does the data entry, and exports the new data that the Master must now re-import. Export/Import uses an ancient PKZIP to pass ZIP files back and forth, which they email or floppy-transport. Ah, the memories. In the best of all possible worlds, the data would go up on the net to be immediately accessed by all. Unfortunately, these folks are working in a developing country with unreliable internet, and are working in a brief time period and high throughput environment. They need both the ability to function when disconnected, and to re-connect and resync changes, with all the edge case issues that brings up. Years ago, Fox shipped with an "off-line view" method that had hooks to solve a lot of the typical conflict problems, though I really thought it was more of a curiosity than a robust framework. In the decades (and decades) since then, surely someone has come out with a replication scheme that can be managed without a post-graduate degree in database set theory. Has anyone come across a web framework with an offline component support like this? The core data the client is using is pretty small (~10,000 records in the main table) Something like: https://developers.google.com/web/fundamentals/instant-and-offline/web-stor… (Just the first hit in a web search, not a recommendation). I'm hoping to find some appropriate technology and then line up a dev in that technology (or a college-level project if appropriate) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 3

SQL Server Shared Management Objects (SMO)
by Paul Newton 01 May '20

01 May '20

Hi all We have been using the following to get a list of available servers loDMO = CreateObject("sqlSMO.Application") loServerList = loDMO.ListAvailableSQLServers However SQL-DMO was apparently deprecated with SQL Server 2005 and succeeded by SQL-SMO. Has anybody used SQL Server Shared Management Objects in VFP and, if so, can they please give me some pointers on what I need to install and how to implement code to replace that above. Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 13

ProFox List Statistics for April 2020
by List Administrator Account 01 May '20

01 May '20

================================================== ProFox List Statistics April 2020 ================================================== Subscriber Count at End of Month: ProFox: 295 ProFoxTech: 181 ================================================== Total Posts: 190 (Up 134.57% from March 2020) Total [OT] Posts: 0 (Unchanged from March 2020) Total [NF] Posts: 29 (Down 17.14% from March 2020) Daily Message Counts for April 2020 ------------------------------------------------ DOW Date Count --- ---- ----- W 1 - 5 T 2 - 2 S 4 - 4 S 5 - 1 M 6 - 3 T 7 - 2 W 8 - 9 T 9 - 7 F 10 - 6 S 11 - 1 S 12 - 3 T 16 - 9 F 17 - 12 S 18 - 4 M 20 - 4 T 21 - 14 W 22 - 4 T 23 - 22 F 24 - 9 S 25 - 3 S 26 - 1 M 27 - 2 T 28 - 18 W 29 - 19 T 30 - 26 Message Counts By Day of Week for April 2020 ------------------------------------------------ DOW Count --- ----- Sun - 5 Mon - 9 Tue - 34 Wed - 37 Thu - 66 Fri - 27 Sat - 12 Distinct Posters to the List (changes relative to March 2020) ------------------------------------------------ Non-OT messages: 34 (Up 13.33%) OT messages: 0 (Unchanged) NF messages: 9 (Down 40.0%) Total number: 34 (Up 13.33%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 20 MB Software Solutions, LLC 2. 19 Richard Kaye 3. 14 Alan Bourke 4. 13 Tracy Pearson 5. 11 Eric Selje 6. 9 Malcolm Greene 7. 9 Paul H. Tarver 8. 9 Ted Roche 9. 8 Paul Newton 10. 7 Dave Crozier 11. 7 Kurt Wendt 12. 7 Stephen Russell 13. 6 Jürgen Wondzinski 14. 5 Frank Cazabon 15. 5 Charlie Coleman 16. 5 António Tavares Lopes 17. 4 Johan Nel 18. 4 Michael Savage 19. 3 Mike 20. 3 John Weller Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 9 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Malcolm Greene 2. 5 MB Software Solutions, LLC 3. 4 Johan Nel 4. 4 Alan Bourke 5. 4 Eric Selje 6. 3 Richard Kaye 7. 1 Vince Teachout 8. 1 Jean Laeremans 9. 1 Paul H. Tarver Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 20 MB Software Solutions, LLC 2. 19 Richard Kaye 3. 14 Alan Bourke 4. 13 Tracy Pearson 5. 11 Eric Selje 6. 9 Malcolm Greene 7. 9 Paul H. Tarver 8. 9 Ted Roche 9. 8 Paul Newton 10. 7 Dave Crozier 11. 7 Kurt Wendt 12. 7 Stephen Russell 13. 6 Jürgen Wondzinski 14. 5 Frank Cazabon 15. 5 Charlie Coleman 16. 5 António Tavares Lopes 17. 4 Johan Nel 18. 4 Michael Savage 19. 3 Mike 20. 3 John Weller Top 15 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Jürgen Wondzinski 2. 3 Paul Newton 3. 3 MB Software Solutions, LLC 4. 3 Johan Nel 5. 2 Michael Savage 6. 1 List Administrator Account 7. 1 Paul H. Tarver 8. 1 Ed Leafe 9. 1 Kurt Wendt 10. 1 Frank Cazabon 11. 1 Dave Crozier 12. 1 Malcolm Greene 13. 1 Kurt at VR-FX 14. 1 Ted Roche 15. 1 Richard Kaye Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 26 GoFish problem 2. 19 Office automation using VFP 10 64-bit version 3. 17 Test 4. 15 [NF] Recommendations on a balance board for standup desk use 5. 15 File sharing services 6. 12 SQL Server Shared Management Objects (SMO) 7. 9 SQL Server 17 - ODBC or Native Client? 8. 8 Decompile FoxPro Windows 2.6? 9. 7 does Refox work in windows 10? 10. 6 Who Likes Burgers & Foxpro ( job in California) 11. 6 64-bit app via the Chen version 12. 6 AW: 64-bit app via the Chen version 13. 6 [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April 14. 5 Pandemic/Penetration Testing Job 15. 5 FoxBin2Prg Form.Property = "" becomes .F. 16. 4 =?UTF-8?Q?_[NF]_X#_Bandol_2.4_released, _public_release_next_week_and_?= LIVE Demo 23 April 17. 3 Congrats Eric Selje! 18. 3 AddObject/BindEvent Question 19. 3 ng give me my file explorer back. 20. 2 MSXML6 instead of MSXML4 Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 26 GoFish problem 2. 19 Office automation using VFP 10 64-bit version 3. 17 Test 4. 15 [NF] Recommendations on a balance board for standup desk use 5. 15 File sharing services 6. 12 SQL Server Shared Management Objects (SMO) 7. 9 SQL Server 17 - ODBC or Native Client? 8. 8 Decompile FoxPro Windows 2.6? 9. 7 does Refox work in windows 10? 10. 6 Who Likes Burgers & Foxpro ( job in California) 11. 6 64-bit app via the Chen version 12. 6 AW: 64-bit app via the Chen version 13. 6 [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April 14. 5 Pandemic/Penetration Testing Job 15. 5 FoxBin2Prg Form.Property = "" becomes .F. 16. 4 =?UTF-8?Q?_[NF]_X#_Bandol_2.4_released, _public_release_next_week_and_?= LIVE Demo 23 April 17. 3 Congrats Eric Selje! 18. 3 AddObject/BindEvent Question 19. 3 ng give me my file explorer back. 20. 2 MSXML6 instead of MSXML4

1 0

Test
by Dave Crozier 30 Apr '20

30 Apr '20

Hi guys, Just sending an email for Ed’s benefit so he can hopefully sort out my issues posting to Profox. Hence my absence for nearly 12 months. Missing the interaction with you all and hoping you are all well. If some of you could reply to this message to confirm that I can see your responses even though I can’t see my posts to the group Thanks Dave Crozier Software Development Manager Flexipol Packaging Ltd. ﴾⚆ᨎ⚆﴿ Flexipol® Packaging Ltd T 01706 222 792 E DCrozier(a)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 Disclaimer The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful. This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/jpeg image/jpeg image/png image/png image/png image/png ---

10 16

Getting list of SQL Servers on a network
by Paul Newton 30 Apr '20

30 Apr '20

Hi all Using code examples from the internet I have tried three different ways of getting a list of SQL Servers on the network: NetServerEnum (Win32 API) SQLBrowseConnect (ODBC32) SmoApplication.EnumAvailableSqlServers None of the methods returns anything and I am beginning to suspect that this is because I am using a VPN connection. Does that seem likely? Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox