ProFox April 2022

profox@leafe.com

29 participants
23 discussions

trouble with superbrowse on new vfp and thor installation
by Jeff Roberts 30 Apr '22

30 Apr '22

I set up a new machine recently and I installed VFP9 with SP2 then Thor. When I open a table and then choose Thor Tools->Tables->Superbrowse, I get an error "unknown member okeywordlist". I haven't ever seen this but it has been a while since I set up a new machine. Has anyone else seen this? Hopefully, I just missed a step. Screenshot attached. Thanks![image: 2022-04-27_08-20-01.png] -- Jeff Roberts | jefflroberts(a)gmail.com --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/png ---

1 1

Virtual Fox Fest 2022 (May): Last chance
by Rick Schummer 26 Apr '22

26 Apr '22

We are down to the last minute and the registration squad is providing one last incentive to get you to register now because the next week is already busy. While we don't mind registering people at the last minute, it is hectic just before the conference and it is much easier to process registrations today than it is the day before or the day of the conference. Our friends at DBI want to help incentivize you to register in the next 24 hours and have provided us licenses to their awesome products to give away. 1) Two (2) Studio Controls COM 64 Full Developer Licenses (each a USD $699 value, https://www.dbi-tech.com/ProductPage_studiocontrolscom64.aspx) What's included: - 25 Modern Unicode, 64 bit and 32 bit UX Design ActiveX Controls - Multiple Access Demos for each component high lighting key industry tested features - Detailed, individual component help files - Tutorial style 'Developing With' per component help - 32 - bit design and Deployment controls - 64 - bit Design and Deployment controls 2) One (1) Solutions Schedule COM 64 Version 4.0 (not yet released to the public, USD $1499 value, https://www.dbi-tech.com/ProductPage_SolutionsScheduleCOM64.aspx) Full Developer License. What's currently included: - Royalty-Free distribution - Source Code Samples written in VFP - Compiled (.exe) Samples - Annual Product Upgrade Service - Direct Access to the Product's Technical Support Group - Online license management - Online Software Activations 3) Two (2) $100 Microsoft Store Gift Cards. So here is the deal. Everyone who is registered before 3:00pm (North American Eastern Time, GMT -4) on April 27, 2022 has a chance to win one of the five give-aways, including those who registered earlier. We know this is important so here is the link to the registration site to make things easy: http://geekgatherings.com/Registration Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

VFP Advanced COM
by Chris Davis 26 Apr '22

26 Apr '22

Just having a play around with this, I have created a simple COM exe and compiled it in the 64bit version of VFPA. It suggests its creating a 64bit exe but I can only create an instance of it from a 32bit application (VFP 32bit / Node 32bit) ... if I try from VFPA 64Bit or Node 64Bit then it can't find the class. Am I trying to do something its not intended to do? TIA Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 1

Issues with referencing an array in a form
by Joe Yoder 26 Apr '22

26 Apr '22

I want to call a form to select the year for a report and then print the report. I do a select into array to get the list of choices into array YearArr in the load procedure of the form but when the form attempts to load a combo box using the array as the list of choices I get the message YearArr is not an array. Load procedure of form contents: SELECT year(start) distinct from leases into array YearArr Combo box properties: Row source : YearArr Row source type: 5 - Array What am I missing that is needed to make this work? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

[NF] Those were the days ... ISP charges
by Paul Newton 25 Apr '22

25 Apr '22

From an ISP in Kenya ca. 2005 What are the cost implications? =============================== They are so minimal, you won't believe it! For as little as US$ 200 per month you can get yourself a leased line of 64Kbps uplink and 256Kbps downlink. Paul Newton

6 9

RE: Issues with referencing an array in a form
by Jürgen Wondzinski 25 Apr '22

25 Apr '22

Why not just use the RowSourceType 3 (SQL Statement) in your combobox? Put this into your control RowSourceType=3 RowSource= "Select dist Str(year(start),4) from leases into cursor curYears" In Destroy, if no private Datasession: Use in select("CurYears") [excessive quoting removed by server]

1 0

visual foxpro advanced table size limits
by Ajit Abraham 22 Apr '22

22 Apr '22

Hello Jeff, I downloaded and checked the VFPA version from http://www.baiyujia.com/vfpadvanced/f_vfpa_about.asp It does *not* support large files. That version is 10.0 But version 10.1 supports large files - which needs a subscription. Just send an email to Chen (ccb2000(a)163.com) and he will guide you with the subscription Chen is an extremely supportive and friendly person. He has indicated that a 10.2 release is on works (maybe this year or next) which will support 32GB RAM (and if you use the 64bit version - then the full RAM of your PC!) - WOW! Regards, Ajit Abraham --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Virtual Fox Fest 2022 (May): Time to Register
by Rick Schummer 21 Apr '22

21 Apr '22

Thanks to all who registered for Virtual Fox Fest; we appreciate your support. This is another friendly reminder to the rest of you that it takes just a few minutes to register, here is the link: http://geekgatherings.com/registration Emails to registered attendees begin next week with all the details about the conference. You can order your Virtual Fox Fest gear from https://geekgatherings.logosoftwear.com/. Virtual Fox Fest is May 5, 2022! Only 14 days until we gather virtually via the Internet! Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

visual foxpro advanced table size limits
by Jeff Roberts 20 Apr '22

20 Apr '22

I recently ran across Ajit Abraham's github repo at https://github.com/Ajitweb/vfp10LargeTables where he guides you through importing a large dataset from imdb to show Visual Foxpro Advanced breaking the 2GB table size limit. I already had the 32bit version of Visual Foxpro Advanced installed so I tried this exercise with it and still got the table size large error that you'd get with VFP9. So I downloaded the 64bit version and installed and tried that with the same result. I am guessing that I am missing something simple or maybe the 32bit version I had on my laptop was too old and is causing a conflict of some kind? Anybody else seen this behaviour and know what I need to change? I am not trying to do this in production I was just curious and really wanted to see it for myself. Thanks! -- Jeff Roberts | jefflroberts(a)gmail.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

can visual foxpro create a table inside a sql statement?
by Jeff Roberts 15 Apr '22

15 Apr '22

I've been watching a video tutorial called "Mastery with SQL" that uses Postgres for the back end. At one point while talking about subqueries the instructor runs the following SQL query: SELECT * FROM (values ('short', 0, 60), ('medium', 60, 120), ('long', 120, 10000)) as c("desc", "min", "max"); This query more or less creates a table and then selects everything out of it. Not very useful on its own but could be handy when joined up to a real table. I get a syntax error running this in Visual Foxpro 9 so I was wondering if the syntax can be changed so that it will work, or is this type of query even possible with Visual Foxpro? I think it could be done with a create cursor statement ahead of the query but I'm just curious if it can be done with a one-liner. FYI the query as-is works in Postgres but not VFP, Sqlite, or Mysql (at least the versions I have on my machine). -- Jeff Roberts | jefflroberts(a)gmail.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 3

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox April 2022