ProFox

profox@leafe.com

2704 discussions

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

ProFox List Statistics for June 2019
by List Administrator Account 01 Jul '19

01 Jul '19

================================================== ProFox List Statistics June 2019 ================================================== Subscriber Count at End of Month: ProFox: 292 ProFoxTech: 182 ================================================== Total Posts: 127 (Down 30.98% from May 2019) Total [OT] Posts: 3 (Up 100.0% from May 2019) Total [NF] Posts: 52 (Up 44.44% from May 2019) Daily Message Counts for June 2019 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 1 S 2 - 2 M 3 - 2 T 4 - 2 W 5 - 4 T 6 - 22 F 7 - 4 M 10 - 7 T 11 - 10 S 16 - 2 M 17 - 3 T 18 - 7 W 19 - 1 M 24 - 1 T 25 - 7 W 26 - 1 T 27 - 28 F 28 - 22 S 29 - 1 Message Counts By Day of Week for June 2019 ------------------------------------------------ DOW Count --- ----- Sun - 4 Mon - 13 Tue - 26 Wed - 6 Thu - 50 Fri - 26 Sat - 2 Distinct Posters to the List (changes relative to May 2019) ------------------------------------------------ Non-OT messages: 27 (Down 18.18%) OT messages: 2 (Up 100.0%) NF messages: 12 (Down 14.29%) Total number: 27 (Down 18.18%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 15 Stephen Russell 2. 13 Paul H. Tarver 3. 12 MB Software Solutions, LLC 4. 9 Tracy Pearson 5. 8 Ted Roche 6. 8 Johan Nel 7. 7 Gene Wirchenko 8. 7 Alan Bourke 9. 6 António Tavares Lopes 10. 6 Frank Cazabon 11. 4 Paul Newton 12. 3 Ajoy Khaund 13. 3 Man-wai Chang 14. 2 Eric Selje 15. 2 Rick Schummer 16. 2 Fletcher Johnson 17. 2 Richard Kaye 18. 2 <juergen(a)wondzinski.de> 19. 2 John Weller 20. 2 Bill Anderson Top 2 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ 1. 2 20% Johan Nel 2. 1 8% MB Software Solutions, LLC Top 12 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 13 Stephen Russell 2. 9 MB Software Solutions, LLC 3. 7 Johan Nel 4. 7 Paul H. Tarver 5. 6 Frank Cazabon 6. 3 António Tavares Lopes 7. 2 Alan Bourke 8. 1 <juergen(a)wondzinski.de> 9. 1 Ted Roche 10. 1 Charles Hart Enzer, M.D. 11. 1 Kevin Cully 12. 1 John Weller Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 15 Stephen Russell 2. 13 Paul H. Tarver 3. 13 MB Software Solutions, LLC 4. 10 Johan Nel 5. 9 Tracy Pearson 6. 8 Ted Roche 7. 7 Gene Wirchenko 8. 7 Alan Bourke 9. 6 António Tavares Lopes 10. 6 Frank Cazabon 11. 4 Paul Newton 12. 3 Ajoy Khaund 13. 3 Man-wai Chang 14. 2 Eric Selje 15. 2 Rick Schummer 16. 2 Fletcher Johnson 17. 2 Richard Kaye 18. 2 <juergen(a)wondzinski.de> 19. 2 John Weller 20. 2 Bill Anderson Top 14 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 3 Johan Nel 2. 2 MB Software Solutions, LLC 3. 2 Rick Schummer 4. 2 <juergen(a)wondzinski.de> 5. 2 Stephen Russell 6. 2 Paul Newton 7. 1 List Administrator Account 8. 1 Ajoy Khaund 9. 1 Gene Wirchenko 10. 1 Bill Anderson 11. 1 Paul H. Tarver 12. 1 Tracy Pearson 13. 1 Charles Hart Enzer, M.D. 14. 1 Eric Selje Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 40 [NF] What would you miss from VFP, when migrating 2. 23 Funny bug 3. 12 Odd Error Message 4. 8 VFP 9 SP fix lists 5. 7 Mobile App 6. 5 ProFox List Statistics for May 2019 7. 4 [NF] Scaling in mySQL? 8. 3 [NF] Fun with Table of Contents in MS Word 2016 (...NOT FUN) 9. 3 Odd build error when trying to create automation COM component; references drive/folder I don't have in Project Info/Servers tab 10. 3 Problem with WMI query 11. 2 Grid and DynamicForeColor 12. 2 .NET and FoxPro Analyst / Developer role in Pleasant Prairie 13. 2 Using FoxPro & ODBC to connect to Progress Database 14. 2 [NF] Lianja and Python 15. 1 [NF] Remember the days when M$ didn't care? 16. 1 [NF] Weird Android Flash/Flashlight 17. 1 [SUSPECTED SPAM] Funny bug 18. 1 Fwd: .NET and FoxPro Analyst / Developer role in Pleasant Prairie 19. 1 Southwest Fox 2019: Super-Saver deadline approaches! 20. 1 AW: Funny bug Top 1 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 3 [OT] X# progress report - June 2019 Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 40 [NF] What would you miss from VFP, when migrating 2. 23 Funny bug 3. 12 Odd Error Message 4. 8 VFP 9 SP fix lists 5. 7 Mobile App 6. 5 ProFox List Statistics for May 2019 7. 4 [NF] Scaling in mySQL? 8. 3 [NF] Fun with Table of Contents in MS Word 2016 (...NOT FUN) 9. 3 [OT] X# progress report - June 2019 10. 3 Odd build error when trying to create automation COM component; references drive/folder I don't have in Project Info/Servers tab 11. 3 Problem with WMI query 12. 2 Grid and DynamicForeColor 13. 2 .NET and FoxPro Analyst / Developer role in Pleasant Prairie 14. 2 Using FoxPro & ODBC to connect to Progress Database 15. 2 [NF] Lianja and Python 16. 1 [NF] Remember the days when M$ didn't care? 17. 1 [NF] Weird Android Flash/Flashlight 18. 1 [SUSPECTED SPAM] Funny bug 19. 1 Fwd: .NET and FoxPro Analyst / Developer role in Pleasant Prairie 20. 1 Southwest Fox 2019: Super-Saver deadline approaches!

1 0

Problem with WMI query
by Paul Newton 28 Jun '19

28 Jun '19

Hi all I have tried to run a WMI query to process Application events on or after a certain date (SearchEventStart). I have tried each of the following formats for SearchEventStart to no avail. 20190628123502.000000+000 28/06/2019 12:34:10 PM 2019-06-28 12:35:27:000 The code I am using looks like this: strComputer = "." objWMIService = GetObject("winmgmts:\\" + strComputer + "\root\cimv2") colEvents = objWMIService.ExecQuery( "Select * from Win32_NTLogEvent Where Logfile = 'Application' And TimeWritten >= '" + SearchEventStart + "'" ) This does not work but it works if I omit the second part of the WHERE clause like so: colEvents = objWMIService.ExecQuery( "Select * from Win32_NTLogEvent Where Logfile = 'Application'") Any ideas? Any help would be much appreciated. Thanks Paul Newton

2 2

RE: Odd Error Message
by Tracy Pearson 28 Jun '19

28 Jun '19

Hello Gene, That just raises more questions about what COM object is being used to create the XLS file. Is it shipping with the latest Windows 10 computer? Is it built in to the VFP runtimes? Is this functionality suddenly going to stop working one day after the DLL is identified and removed by some anti-virus software? All things I don't have time to investigate. Due to a different control having the same "Unknown COM status" message when attempting to have it write a file to a non-existent path, or a locked file, I have put checks in before calling the functions. Sometimes I think I should change my behavior to write to a temporary file, then move the bytes from the temporary file in to the destination. It would mean a longer save time, but I would be able to deal with anti-virus and on-demand backup tools putting a lock on the files. It's not an exercise for this month. All things in their time, Tracy -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Gene Wirchenko Sent: Monday, June 24, 2019 6:15 PM To: profoxtech(a)leafe.com Subject: Odd Error Message Hello: I got an interesting error message today. It was another example of an error message indicating that an error had occurred with the message not terribly useful for determining the actual error. Try the following use sometable copy to nothere\nothere\sometable copy to nothere\nothere\somecopy type xl5 where sometable is some table and nothere\nothere is a non-existent subdirectory chain. The error message for the first copy command is "Invalid path or filename." This is sensible. The error message for the second copy command is "OLE error code 0x80030003: Unknown COM status code." Huh? Copying to a directory that does not exist results in an error. You even get a choice of error messages. Sincerely, Gene Wirchenko [excessive quoting removed by server]

6 10

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox