ProFox July 2019

profox@leafe.com

39 participants
51 discussions

Re: LOCATE Backwards?
by Gene Wirchenko 04 Jul '19

04 Jul '19

At 12:19 2019-07-03, Ted Roche <tedroche(a)gmail.com> wrote: >On Wed, Jul 3, 2019 at 12:48 PM Gene Wirchenko <gene(a)shaw.ca> wrote: > > > What if an index is not appropriate? Is there any way to do a > > LOCATE backwards (or something equivalent)? (The table has 186,574 > > rows currently so searching backwards would definitely be worth > > it.) I do not think there is such a critter, but maybe, you know better? > >SET FILTER TO <condition> && optional >GO BOTTOM >SKIP -1 && as needed, this LOCATEs backwards Argh! I should not have missed that since I am not an anti-SET-FILTER-TO-ist. Thank you. Sincerely, Gene Wirchenko

1 0

Re: LOCATE Backwards?
by Ted Roche 03 Jul '19

03 Jul '19

On Wed, Jul 3, 2019 at 12:48 PM Gene Wirchenko <gene(a)shaw.ca> wrote: > > What if an index is not appropriate? Is there any way to do a > LOCATE backwards (or something equivalent)? (The table has 186,574 > rows currently so searching backwards would definitely be worth > it.) I do not think there is such a critter, but maybe, you know better? > SET FILTER TO <condition> && optional GO BOTTOM SKIP -1 && as needed, this LOCATEs backwards -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

RE: LOCATE Backwards?
by Paul H. Tarver 03 Jul '19

03 Jul '19

If you are using VFP9, why won't a SELECT statement work? Something like: SELECT TOP 1 * FROM table WHERE condition ORDER BY key DESC INTO CURSOR tmp Just make sure you create index(es) on the condition field(s) so Rushmore will kick in and it should give you a reverse order cursor with all the matching values in a flash. Is there a reason you want to use LOCATE instead? Paul H. Tarver -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Gene Wirchenko Sent: Wednesday, July 03, 2019 11:47 AM To: profoxtech(a)leafe.com Subject: LOCATE Backwards? Hello: I have a situation in my app where I am having to pick up what will presumably be the last row in a table. Mind you, the general situation is that it might not be if in a multiuser situation. With the current situation, I can use an index to find that row really fast. BUT ... What if an index is not appropriate? Is there any way to do a LOCATE backwards (or something equivalent)? (The table has 186,574 rows currently so searching backwards would definitely be worth it.) I do not think there is such a critter, but maybe, you know better? Sincerely, Gene Wirchenko [excessive quoting removed by server]

1 0

Using FoxPro & ODBC to connect to Progress Database
by Paul H. Tarver 03 Jul '19

03 Jul '19

Finally, I have something new and maybe interesting to throw at y'all! Got a potential client I'm doing some prelim work for to determine if we can establish an ODBC connection to a Progress Database. I'm just now trying to install all the ODBC drivers and extras the Progress client requires. However, I wondered if anyone on this group had ever connected Foxpro to Progress and if so, what pitfalls can you help me avoid? I'm told by the client that they use SQL Management Studio and then connect to the Progress database via Linked Databases which forces the use of an ODBC DSN. My goal would be to use this to browse the tables and build my test queries and then use SQL Pass-Through via a DSN-Less ODBC connection to query data in production. I've accomplished similar processes by connecting Foxpro to SQL, MySQL, PostgreSQL, FirebirdSQL, Oracle, Sybase, SQLite and Access. I've ODBC'd my way into a bunch of databases, but I've never worked with Progress. Any tips, suggestions or recommendations? Thanks in advance! Paul H. Tarver --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

Re: LOCATE Backwards?
by Charlie Coleman 03 Jul '19

03 Jul '19

I think someone already mentioned GO BOTTOM. But just in case there is an index set, I think you might want to do a SET ORDER TO 0 just before doing the GO BOTTOM. And of course, if you do that, you might want to restore the index after the GO BOTTOM. Something like: cIndex = ORDER() set order to 0 go bottom set order to (cIndex) On Wed, Jul 3, 2019 at 12:48 PM Gene Wirchenko <gene(a)shaw.ca> wrote: > Hello: > > I have a situation in my app where I am having to pick up what > will presumably be the last row in a table. Mind you, the general > situation is that it might not be if in a multiuser situation. > > With the current situation, I can use an index to find that row > really fast. > > BUT ... > > What if an index is not appropriate? Is there any way to do a > LOCATE backwards (or something equivalent)? (The table has 186,574 > rows currently so searching backwards would definitely be worth > it.) I do not think there is such a critter, but maybe, you know better? > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server]

1 0

Re: LOCATE Backwards?
by Koen Piller 03 Jul '19

03 Jul '19

Try go bott Op wo 3 jul. 2019 om 12:48 schreef Gene Wirchenko <gene(a)shaw.ca> > Hello: > > I have a situation in my app where I am having to pick up what > will presumably be the last row in a table. Mind you, the general > situation is that it might not be if in a multiuser situation. > > With the current situation, I can use an index to find that row > really fast. > > BUT ... > > What if an index is not appropriate? Is there any way to do a > LOCATE backwards (or something equivalent)? (The table has 186,574 > rows currently so searching backwards would definitely be worth > it.) I do not think there is such a critter, but maybe, you know better? > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server]

1 0

LOCATE Backwards?
by Gene Wirchenko 03 Jul '19

03 Jul '19

Hello: I have a situation in my app where I am having to pick up what will presumably be the last row in a table. Mind you, the general situation is that it might not be if in a multiuser situation. With the current situation, I can use an index to find that row really fast. BUT ... What if an index is not appropriate? Is there any way to do a LOCATE backwards (or something equivalent)? (The table has 186,574 rows currently so searching backwards would definitely be worth it.) I do not think there is such a critter, but maybe, you know better? Sincerely, Gene Wirchenko

1 0

Reverse Wildcard String Comparison
by Paul H. Tarver 03 Jul '19

03 Jul '19

Ok, I need a little help and here's the scenario: I have an x-ref table that looks like this: DeptNum, Description, Value 1??, Dept 1, 99930 2??, Dept 2, 92382 3??, Dept 3, 83728 ?4?, Dept 4, 27377 Next, I have a data table with thousands of employees with department numbers I want to scan through. If the employee's dept # is 101, then in the fastest way possible, I want to compare 101 to the DeptNum in the x-ref table and return the value 99930. If the employee's dept # is 141, then the search should return both 99930 and 27377 and I'll perform some logic to determine which value is most important. I know I can do SELECT queries using the LIKE statement such as Select * from x-ref where x-ref.DeptNum LIKE "1%", but in this case, I know the explicit value and I need to compare it to the masked values in the x-ref table. So I really need to the reverse which would be Select * from x-ref where "1%" LIKE x-ref.DeptNum (which doesn' t work, I know.). FYI, The DeptNum field can be up to 20 characters long and I am guessing the masked values could be as well. Unfortunately, I think I'm stuck mentally on doing this with a SQL Query and I'm not able to think outside of this box right now, so any suggestions will help. Hell, at this point, I'll take snarky comments, but only if they contain clues to how I need to proceed. LOL Thanks in advance Paul H. Tarver --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

[NF] Work in SalesForce?
by Kurt at VR-FX 03 Jul '19

03 Jul '19

I'm curious. I have a buddy of mine who has been DEMANDING that I get onto the SalesForce bandwagon. Seems there is a HUGE Demand out there it. And, supposedly - its Stupid easy to learn. So - I Am VERY curious to know. IS there any folks here who work with it!?!? -K-

1 0

[NF] What would you miss from VFP, when migrating
by Johan Nel 02 Jul '19

02 Jul '19

Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(<script>) From a X# perspective the FOX release already has support for: 1. DBFCDX and readonly access for VFP specific FieldTypes (AutoInc, etc) with full support planned in the foreseeable future; 2. WITH/ENDWITH, TEXT/ENDTEXT (partially implemented); 3. Macro-compilation; 4. Script engine that can make full use of the .NET framework. XBase greetings, Johan Nel FOX Member: Friends of XSharp https://xsharp.info George, South Africa

9 55

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox July 2019