ProFox June 2017

profox@leafe.com

53 participants
64 discussions

[NF] Find table where last record was added
by Kevin J Cully 07 Jun '17

07 Jun '17

Hello all, I'm trying to (partially) reverse engineer how an ERP system is working. It uses M$ SQL Server and it has hundreds of tables. I know most of the tables that store actual data, but I know that there must be tables where the business rules are stored. Is there a way to query a system table for which table just had a record added to it? There are lots of pages showing how to get the last record added in a table, but this isn't what I'm needing. I'm wanting to add a (test) business rule, and then find what table(s) that got written into. I believe this query gives me the last time the table structure has changed, but that's not what I want either: SELECT [name],create_date,modify_date FROM sys.tables order by modify_date desc Thanks, Kevin This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and (i) destroy this message if a facsimile or (ii) delete this message immediately if this is an electronic communication. Thank you. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 6

Is there any advantage for indexing on balance rather than on principle - payments +adjustments?
by Michael Madigan 07 Jun '17

07 Jun '17

When creating an index , Is there any advantage for indexing on balance rather than on principle - payments +adjustments? Index on balance tag balanceindex on principle - payments + adjustments tag balance Right now we don't have a balance field, would there be any advance to add a balance fields? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 6

[NF] Python conference in NY Aug 2017
by Stephen Russell 07 Jun '17

07 Jun '17

Early pricing ends June 30 https://conferences.oreilly.com/jupyter/jup-ny -- 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 ---

1 0

Re: e: [NF] PyQT for desktop applications
by Gene Wirchenko 07 Jun '17

07 Jun '17

At 21:28 2017-06-06, mbsoftwaresolutions(a)mbsoftwaresolutions.com wrote: [snip] >I was surprised years ago (and somewhat still am) with how low the >bar got set on what was an acceptable UX on a website. Much of that >would have NEVER been tolerated in a desktop app. <sarcasm style="dripping">But Web app UX has been improving oh-so-much-more than desktop apps for some time now.</sarcasm> Sincerely, Gene Wirchenko

2 1

Re: e: [NF] PyQT for desktop applications
by Gene Wirchenko 06 Jun '17

06 Jun '17

At 10:26 2017-06-06, "Brant E. Layton" <dcci(a)futureone.com> wrote: >One more point for the desktop application: Navigation. > >I've worked with many applications that are intense data entry - and >the best ones can be 'driven' entirely from the keyboard. You don't >have to reach for the mouse to make selections, etc. Of course, >there are those users that don't know where the TAB key is... > >Trying to fill out forms on the Web? Only about one half of the web >pages I encounter can even set focus to the first fillable field - >let alone navigate the entire page efficiently. (bank login pages...) > >But, we mostly just put up with what we are given. I also find that Web forms are often laid out badly. They can not count on a screen size so they go with the one-per-line model: Data Item 1: _____ Data Item 2: _________________________ Data Item 3: __________________________________________________ Data Item 4: _____ Data Item 5: __________ even if it would be clearer to have more than one item on a line (such as with addresses). This often overflows off the bottom the screen. My desktop app does not have this problem. I saw one page that I greatly regret not having saved the URL for. It was made very "pretty". As a result, each data item (one per line) took about triple the vertical space it needed. Worse, there were no cues as to how long the input could be. I filled in a reference of about 35-40 characters and when I submitted the form, only then was I told that input was limited to 12 characters. I very much dislike Web forms. Sincerely, Gene Wirchenko

3 2

Re: [NF] What's the difference between a PRODUCT manager and a PROGRAM manager?
by Gene Wirchenko 06 Jun '17

06 Jun '17

At 04:33 2017-06-06, Ted Roche <tedroche(a)gmail.com> wrote: >On Fri, Jun 2, 2017 at 12:30 PM, ><mbsoftwaresolutions(a)mbsoftwaresolutions.com> wrote: > > Product manager handles the logistical stuff, whereas Program manager > > handles the app development? > >You really need to read the job descriptions, as everyone defines them >differently. > >At MS, in the 90s, one was a title that all of your sales people had, >the other was the boss. I never could keep them straight. One job description that I saw recently (and have seen many times before) was for a position titled "Office Manager". The work was that of a receptionist/secretary. Sincerely, Gene Wirchenko

1 0

[NF] What's the difference between a PRODUCT manager and a PROGRAM manager?
by mbsoftwaresolutions＠mbsoftwaresolutions.com 06 Jun '17

06 Jun '17

Product manager handles the logistical stuff, whereas Program manager handles the app development?

4 3

VFP9SP2 report problem with Summary overflowing and page footer not showing
by mbsoftwaresolutions＠mbsoftwaresolutions.com 06 Jun '17

06 Jun '17

Good evening, ProFox Community! I've got a "Proposal" report that has a page footer that *should* be printed on each page, and a Summary page that has a memo field that stretches as needed. Apparently the client has really long winded memos that get imaged, and the result is that the summary section's continuation onto subsequent pages causes the footer to be basically ignored or not shown. Ideas? Thanks, --Mike

2 2

[NF] Profox emails not showing up
by Charlie-gm 05 Jun '17

05 Jun '17

This is a test email. It looks like my messages are not coming through to the list. I had a couple that were discussing the 'rich client' / 'browser' debate. -Charlie

3 3

Issues with Excel (Office365) & appendxlsx.prg
by Paul H. Tarver 03 Jun '17

03 Jun '17

I have been using the "appendxlsx.prg" procedure to import data from Excel (XLS and XLSX) files for a few years now but yesterday I ran into a weird problem and now I'm wondering if there is a bug in either Office 365 or Appendxlsx.prg. A client who has been using one of my programs for a couple years without any problems contacted me yesterday with an issue related to data not being imported correctly. The Excel spreadsheet containing the data is pretty straightforward with less than 100 rows and probably 20-25 columns. The client creates and maintains the spreadsheet and then imports the spreadsheet data in my program which converts it into a file to be imported elsewhere. All rows have similar data, but in the case of one row, the data was imported correctly with the exception of one cell. The cell contained a Case ID which looks like this: "091-293828-012" and that one cell was imported into my program via the "appendxlsx.prg" procedure as '0'. Nothing I did to the cell would change the behavior. If I added characters to the beginning or end of the Case Id, it would still import as '0'. If I changed the cell contents to '1234567890', it would import as '0'. The row above this record and the row after this record as well as all other records in the file imported correctly. But not this one cell. Ultimately, saving the Excel file to a CSV format and importing it as a CSV solved the problem. However, in talking with the client, the only change that has been made is they switched recently to Office 365. Their problems importing data from the Excel spreadsheet began shortly after that. Has anyone seen behavior like this? Is it a problem I need to debug in the "appendxlsx.prg" program, or is this a bug in Office 365? Thanks in advance! Paul H. Tarver Tarver Program Consultants, Inc. Email: <mailto:paul@tpcqpc.com> paul(a)tpcqpc.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox June 2017