ProFox February 2016

profox@leafe.com

56 participants
80 discussions

.NET equivalent of VFP SQL Pass-Through (i.e. without using EF or LINQ)
by Paul Newton 10 Feb '16

10 Feb '16

Hi all In VFP we can do this lnConnection = SQLSTRINGCONNECT(cConnectString) SQLEXEC(lnConnection,"Select * From cname") && puts results into SQLRESULT I am wondering what is the nearest equivalent in .NET This is what I have come up with, but is there a better way? SqlConnection sqlConnection1 = new SqlConnection(cConnectString); SqlCommand cmd = new SqlCommand(); SqlDataReader reader; cmd.CommandText = "SELECT * FROM cname"; cmd.CommandType = CommandType.Text; cmd.Connection = sqlConnection1; sqlConnection1.Open(); reader = cmd.ExecuteReader(); Also how would I approach UPDATE and DELETE etc? Many thanks Paul Newton

4 6

Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)
by Kurt Wendt 10 Feb '16

10 Feb '16

Hey Ted, Thanks for "Getting That For me". So - yes, I decided to go the Grid route on this issue. I did look at the 1001/Ch 6 - but, in the webpage it refers to using sample code that came with the book. However, I saw one of the links above it - from Foxite. I decided to implement that code. To be honest - I hadn't sub-classed before, but, I figured it out and made a Grid sub-class. However, I'm having a problem in implementing the code. I implemented everything as stated on this webpage: https://www.foxite.com/faq/default.aspx?id=3# I believe I implemented all the code correctly. However, I'm having a problem with the following lines: WITH THIS .nActiveRow = IIF(.ACTIVEROW = 0, .nActiveRow ,.ACTIVEROW) && Assign value to class property Originally the 2nd line above was as follows: .nActiveRow =.ACTIVEROW && Assign value to class property The problem is - value in ACTIVEROW is Always Zero (a property in the Grid ). I have NO Idea why its always Zero. In theory - if I change to another record - it should be giving the record #. Any suggestions would be greatly appreciated. Regards, Kurt -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ted Roche Sent: Thursday, January 28, 2016 4:50 PM To: profoxtech(a)leafe.com Subject: Re: A Question of ListBoxes... On Thu, Jan 28, 2016 at 4:04 PM, Kurt Wendt <Kurt_Wendt(a)globetax.com> wrote: > > To a certain extent - I agree. If they want a Grid - maybe I should give them one. That being said - I don't think there is a straightforward way in a Grid to Select Multiple items. Am I wrong? Although - After writing the last 2 sentences - some ideas were rolling around in my head about implementing a multi-select in a Grid. Since, at least with me - I know anything is possible - as I've done some interesting screen designs in the past! > Forgive me, but the answer is obviously: http://bfy.tw/3yWI and again, I recommend 1001, Chapter 6 this time. -- Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server]

11 50

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)
by Brant E. Layton 10 Feb '16

10 Feb '16

Hi Kurt, Sorry I didn't say anything sooner - another trick is to use a cursor containing a logical field. In the Grid, you add a checkbox (an additional control ) to the column assigned to the logical field. Then, the user can just click on the checkbox on the record they want. You can also add buttons that check All or check None or Invert the selection - all sorts of nifty stuff. Just a thought. | Brant Layton| |480.964.1316| On 2/9/2016 11:34 AM, profoxtech-request(a)leafe.com wrote: > RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A > Question of ListBoxes) --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 7

[NF] Blogging or CMS or what?
by Ken Kixmoeller (ProFox) 10 Feb '16

10 Feb '16

Hey, folks - -- I'm needing to set up a web site but I need it to be easy for deeply non-technical folks (i.e. my wife and the like) to add content. (And I don't want to write it!) The site wil mostly media -- pages with sets of photos, embedded YouTube videos, or both. The pages will have very little written content. Most or all of the images will also be posted to Instagram, Facebook, maybe Twitter, etc. I am starting to do some research on my own, but it always amazes me what you folks know. Suggestions to jump-start this would be deeply appreciated! Ken

6 14

Foxpro in the wild: FireRMS
by Kevin Cully 10 Feb '16

10 Feb '16

I've started a job with my county government and I was working with the Fire Marshal and he was showing me the system they use to track properties, and who occupy the properties. In case there is a fire or emergency they need to have an idea on who are in the spaces in case there needs to be a rescue. Evidently a version of this system runs in all of their trucks as well. Yep. Foxpro against SQL data. http://www.zolldata.com/rescuenet-firerms/ I wish I had a screen shot. Maybe later.

3 2

Re: Foxpro in the wild: FireRMS
by Brant E. Layton 10 Feb '16

10 Feb '16

There are others, too, though moving away from VFP to dotnet. VisualFire by Emergency Technologies originally, purchased last year by ESO Solutions. I'm the maintenance programmer. visualfire.com is the SaaS portal...emergencytechnologies.com forwards to esosolutions.com - which doesn't mention VisualFire since they had an alternate product. | Brant Layton| |480.964.1316| On 2/10/2016 6:10 AM, profoxtech-request(a)leafe.com wrote: > Re: Foxpro in the wild: FireRMS --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Re: [NF] Blogging or CMS or what?
by Gene Wirchenko 08 Feb '16

08 Feb '16

At 08:08 2016-02-08, "Ken Kixmoeller (ProFox)" <foxhelp(a)information-architecture.com> wrote: >I'm needing to set up a web site but I need it to be easy for deeply >non-technical folks (i.e. my wife and the like) to add content. (And I >don't want to write it!) > >The site wil mostly media -- pages with sets of photos, embedded >YouTube videos, or both. The pages will have very little written >content. Most or all of the images will also be posted to Instagram, >Facebook, maybe Twitter, etc. > >I am starting to do some research on my own, but it always amazes me >what you folks know. Suggestions to jump-start this would be deeply >appreciated! I have had a blog for nearly three years using WordPress. Once I got it set up -- and that was not that much -- I have kept it simple. Now, I have just started a job where I have to learn the rest. WordPress *can* do a lot more, and I am starting to find out what. But, for my blog, I have ignored that complication and done fine. Sincerely, Gene Wirchenko

1 0

Re: [NF] FTDI disables devices with counterfeit chips
by Ken Dibble 08 Feb '16

08 Feb '16

>Well, for you and I that's not a bad rule. For folks just trying to >make their machine stop crashing, trying to update everything is a >pretty typical strategy, and the first thing customer support will ask >you. I could rant further, of course. I am increasingly of the opinion that general purpose computers are unacceptably dangerous in the hands of people who don't know a very great deal about how to control them. People who just want to get email or browse the web should use a phone or a tablet that can't do anything else, or screw up anything else. Etc... And while that's an insurmountable problem in people's homes, I would argue that it's not insurmountable in a place of business. If, as a business owner or administrator, you put a general purpose computer into the hands of an employee, then you have a basic responsibility to know how to protect it and maintain it, or to hire, or contract with, someone who does. That includes knowing whether it's a good idea to take the advice of a first-level help desk person or not. Would they let the person who runs the machine-tool lathe try fix it when it breaks down, or would they bring in the in-house mechanic? For that matter, would they let a clerical person try to fix the copier when it jams? Or would they call in the copier repair person? But for some reason, when it comes to computers, all bets are off. Anybody can use one and anybody can "fix" one. Ken

3 2

Re: [NF] Hankering after that old Amstrad PC1512 font?
by Ken Dibble 06 Feb '16

06 Feb '16

>http://int10h.org/oldschool-pc-fonts/fontlist/ My first computer was an Amstrad PCW, and I think it had 512 k of RAM. The font looks about right. It had a dedicated word-processing keyboard, but it could run as a PC with CP/M. It had logo and a version of BASIC. You could buy games for it, even modem if you so desired. 3 inch (not 3.5) double-sided floppy disks but the reader was single-sided so you had to flip them over: https://www.google.com/search?q=amstrad+pcw&biw=1582&bih=850&tbm=isch&imgil…

2 1

[NF] Hankering after that old Amstrad PC1512 font?
by Alan Bourke 06 Feb '16

06 Feb '16

http://int10h.org/oldschool-pc-fonts/fontlist/ -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox February 2016