RE: [OT]

I think everyone with a three-digit IQ and both front teeth is hoping Trump loses. Unfortunately, that might be no more than a scant majority. -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam Buckland Sent: Wednesday, 2 March 2016 7:40 AM To: ProFox Email

Using an expression for the RowSource of a textbox

I am almost certain that I have successfully used an expression as the field to display in a listbox but I can't figure out the syntax I used or which RowSourceType needs to be selected. Can someone help me out? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/

Re: A Curious Find: FoxTales

However, when I did find - was a small book called FoxTales: Behind the Scenes at Fox Software. A great book. I loved the part about how the reporting engine was a forbidding tangle of spaghetti code that everybody was afraid to touch. Ken Dibble www.stic-cil.org _

Re: Suggestions for closing out simple applications?

Thanks very much Fred and Darren - That makes things much clearer! On Tue, Mar 1, 2016 at 6:06 PM, Darren wrote: > Also if the two forms are Modal you do not need READ EVENTS or CLEAR > EVENTS. > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of J

RE: Suggestions for closing out simple applications?

Also if the two forms are Modal you do not need READ EVENTS or CLEAR EVENTS. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder Sent: Wednesday, 2 March 2016 9:49 AM To: profoxt...@leafe.com Subject: Re: Suggestions for closing out simple appli

RE: Suggestions for closing out simple applications?

Joe READ EVENTS starts the EVENT processing CLEAR EVENTS is what stops the EVENT processing You need to put a CLEAR EVENTS somewhere in your application where it will be executed. Once READ EVENTS is executed it will not go to the next line of code until a CLEAR EVENTS is issued. Essentially R

Re: Suggestions for closing out simple applications?

If you don't have a CLEAR EVENTS in your code somewhere else, you'll never get to the one after the READ EVENTS as that's where the code "sits" until a CLEAR EVENTS causes the code after the READ EVENTS to be executed. You'll never execute anything after the READ EVENTS until a CLEAR EVENTS is iss

Re: Suggestions for closing out simple applications?

My application is so simple that it has no menu. Is there an advantage to having the clear events in a form rather than directly following the read events in the main program? Also - what am I missing that would allow the command window to become active after my forms close or is moving the clear

Re: Suggestions for closing out simple applications?

You don't need a CLEAR EVENTS after your READ EVENTS. You need to have a CLEAR EVENTS somewhere else in your code (menu option, last form's Destroy method, etc.) That will cause the main program to pick up after the READ EVENTS and go from there. Fred On Tue, Mar 1, 2016 at 2:43 PM, Joe Yoder

Re: A Curious Find: FoxTales

Remember getting it at at a conference as well. On Tue, Mar 1, 2016 at 3:35 PM, Ed Leafe wrote: > On 03/01/2016 02:04 PM, Kurt Wendt wrote: > > > I was almost thinking this should be marked as OT or NF - since its Not > Technical - and its Not about VFP coding... > > But it is about Fox, so no t

Suggestions for closing out simple applications?

I have never used a framework and often just execute my stuff in the VFP environment. When I do an exe for others to use I am never sure what commands to include to shut things down. Sometimes I end up with applications that can't be shut down without killing them in Task Manager and sometimes I

Re: A Curious Find: FoxTales

I also bought that book when it came out and it still resides on my bookshelf. A great read. - Michael Oke, II oke...@gmail.com 661-349-6221 - On Tue, Mar 1, 2016 at 1:35 PM, Ed Leafe wrote: > On 03/01/2016 02:04 PM, Kurt Wendt wrote: > >

Re: A Curious Find: FoxTales

On 03/01/2016 02:04 PM, Kurt Wendt wrote: > I was almost thinking this should be marked as OT or NF - since its Not > Technical - and its Not about VFP coding... But it is about Fox, so no tag needed. I read that when it came out. A very interesting read, as I knew many of the people involved!

RE: [OT]

Let the flames begin. I always appreciated Bob Calco Carl Lindner -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam Buckland Sent: Tuesday, March 01, 2016 4:10 PM To: ProFox Email List Subject: [OT] So this is before Super Duper Tuesday gets into fo

[OT]

So this is before Super Duper Tuesday gets into force So Who's gonna win... Hillary or Trump? Outside the USA... but can vote... ;-) Adam ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/p

RE: How to allow multiple forms to update the same record pointer in a table

Correct. Mostly. You don't remove the DE - you simply remove the Table from the DE - and that will do what you want. And, that is exactly the trick I use. I do it to rapidly develop a screen. I just KNEW you would like it! Regards, Kurt Wendt Consultant Tel. +1-212-747-9100 www.GlobeTax.com

A Curious Find: FoxTales

I was almost thinking this should be marked as OT or NF - since its Not Technical - and its Not about VFP coding... So - a couple of months ago, as you know - I was looking for a book here at my office regarding Office Automation. Since, in our office - there were a number of bookcases with lot

Re: How to allow multiple forms to update the same record pointer in a table

Wow! I guess that aspect should put hair back on my head! Do I assume correctly that after the form design is complete one can remove the data environment without causing issues? On Tue, Mar 1, 2016 at 1:57 PM, Kurt Wendt wrote: > OK - here's one more insight. > > I discovered Visual Design vi

Re: Import/Export with CSV

Power Query is an add in for Excel 2010 and 2013. We are going to implement it in our newer BI model later this year. Is it useful for VFP data? I don't think so. We are consider it for repeat queries that could mimic a union clause in a query. Our ERP had separate tables for Order Headers dep

RE: How to allow multiple forms to update the same record pointer in a table

OK - here's one more insight. I discovered Visual Design via the Data Env. some years ago - and I "fell in love" with working that way. So - if you open a New Form. Then, open the Data Env. as I mentioned. Then you Add a Table to the DE. Now you can do visual design. Simply click on a field in

Re: How to allow multiple forms to update the same record pointer in a table

Bingo - that was it! I had tried to figure out how to work with the data environment setting but never thought about just deleting the entire thing. I'll want to spend some time learning about how the data environment can work to my advantage rather than causing additional hair loss! Thanks to a

Re: SQL Server Transactions

Are you asking whether the VFP View is available on another machine, or whether the SQL Server table is visible? If the View is part of a dbc database then the answer *may* be yes, on the SQL table I'm 99% sure its no. If, for whatever reason you don't want to complete the transaction then surel

RE: How to allow multiple forms to update the same record pointer in a table

Joe - I believe that's your problem - re: " data environment on each form shows only the one table." If you open the form, right click on an Empty space on the form, then select Data Environment. At that point the graphical version of the DE comes up - and you should be able to simply select th

RE: SQL Server Transactions

Never use SQLDISCONNECT when you have an open transaction. That's a recipe for orphaning your SQL process. I would suggest a review of the SQL functions in the help. There are connection properties related to transactions and functions for SQLCOMMIT, SQLCANCEL, SQLROLLBACK, etc. -- rk -

Re: SQL Server Transactions

You already are inside a transaction, why ask for another one? Let's go back to why you need transactions in the first place. Doing an update that changes rows across the entire table and I mean a table with a half million rows to 2 million. This update is using a where clause that doesn't have

Re: How to allow multiple forms to update the same record pointer in a table

The data environment on each form shows only the one table in the system. Apparently this value gets created when the form is created. I have not figured out a way to delete it. I have the simple demo created and could zip it up to send to whoever is willing to look at it but I am wondering how i

RE: SQL Server Transactions

Ok how about if I do this .. BEGIN TRANSACTION Stuff Then another BEGIN TRANSACTION -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: 01 March 2016 17:15 To: profoxt...@leafe.com Subject: Re: SQL Server Transactions Sorry you

Re: SQL Server Transactions

Sorry you have to tell the server to keep them or chuck them. Then disconnect because SQL is a disconnect API and nothing like a VFP cursor or table. EVER. :) Create your connection. Pass the CRUD statement(s) Commit or Rollback disconnect. On Tue, Mar 1, 2016 at 10:55 AM, Chris Davis w

Re: SQL Server Transactions

Just to cloud the issue further, I remember a presentation in Prague where (to my surprise) *either* row or table buffering was completely debunked - can't remember which or why - anyone? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance

Re: SQL Server Transactions

It is always the wise policy to test out these situations, as ultimately, it doesn't matter what SHOULD happen, in theory, as much as what DOES happen, in practice. On Tue, Mar 1, 2016 at 11:55 AM, Chris Davis wrote: > I think I may have found the issue, what happens if I > > BEGIN TRANSACTION >

RE: SQL Server Transactions

I think I may have found the issue, what happens if I BEGIN TRANSACTION Append records via VFP Remote View with Buffering at 5. And then if TABLEUPDATE is .T. So a SQL DISCONNECT and don't do a COMMIT? -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Beha

Re: SQL Server Transactions

Do these rows generate a PKey? If so do you need that for secondary table inserts as well? On Tue, Mar 1, 2016 at 10:50 AM, Chris Davis wrote: > Thanks for this, but with READ COMMITTED being the SQL Server default, in > theory my appended records cannot be seen by other clients until the COMMI

Re: SQL Server Transactions

This is a massive grey area because you can preset, like Ted showed, or you can hide intentional. I worry that you are not setting the rollback or commit when needed and in essence you could be defining a wall to shelter your data from others. Are you setting only one connection and pushing all s

RE: SQL Server Transactions

Thanks for this, but with READ COMMITTED being the SQL Server default, in theory my appended records cannot be seen by other clients until the COMMIT fires? -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 01 March 2016 16:47 To: p

RE: SQL Server Transactions

Chris, Sorry I may have clouded the issue, I just thought VFP tables and not SQL Server DOH!!! it has been a long day! +1 for what Ted has said re Transaction Isolation Level. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 01 M

Re: SQL Server Transactions

On Tue, Mar 1, 2016 at 11:24 AM, Chris Davis wrote: > > If I start a SQL transaction and append records via a VFP View, issue a table > update but don't COMMIT the transaction are these records available from > another machine? They could be, depending on how you set up the Transaction Isolatio

RE: SQL Server Transactions

Buffered records actually contain a -ve record number property which exists until the tableupdate/tablerevert. See towards the bottom of that link. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Chris Davis Sent: 01 March 2016 16:25 To: profox@lea

RE: SQL Server Transactions

https://msdn.microsoft.com/en-us/library/aa975707%28v=vs.71%29.aspx Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Chris Davis Sent: 01 March 2016 16:25 To: profox@leafe.com Subject: SQL Server Transactions Hi All If I start a SQL transaction and app

Re: VFP 9 breakpoints

As I'm tired typing if set step on endif I use this: setStepOn() with procedure setStepOn(condition as Boolean) as Boolean if (cast(m.condition as L) or empty(pcount())) set step on endif endproc advantage: can be inserted in a logical expression Thierry Nivelet FoxInCloud Give your VFP

SQL Server Transactions

Hi All If I start a SQL transaction and append records via a VFP View, issue a table update but don't COMMIT the transaction are these records available from another machine? If they are how could I know that they have been appended in a transaction that may well end up getting rolled back? T

Re: VFP 9 breakpoints

+1, or ASSERT Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/ Le 27/02/2016 16:19, Alan Bourke a écrit : The breakpoints have always been a bit hit and miss for me. I always just stick a SET STEP ON in. _

RE: [NF] Website Redirect...

Alan, That link worked like a dream... Thanks Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 01 March 2016 15:31 To: profoxt...@leafe.com Subject: Re: [NF] Website Redirect... Try plugging your URL into this: http://insider.zone/tool

RE: [NF] Website Redirect...

Stephen, Yes it is index.html Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: 01 March 2016 15:37 To: ProFox Email List Subject: Re: [NF] Website Redirect... What is the name of the file you have this in? Index.html I hope. I h

Re: [NF] Website Redirect...

Try plugging your URL into this: http://insider.zone/tools/client-side-url-redirect-generator/ It will generate some HTML/JavaScript to do it. Might not work for the 3 people that still disable JavaScript, but hey. -- Alan Bourke alanpbourke (at) fastmail (dot) fm _

Re: [NF] Website Redirect...

What is the name of the file you have this in? Index.html I hope. I have the same string in an index file myself and it has been working for 10+ years. Try is as well in a more modern file: HTH On Tue, Mar 1, 2016 at 9:27 AM, Dave Crozier wrote: > Guys, > Without playing around with the ISP

Re: 64 bit VFP compiler?

Hi Wes: There was much debate about this compiler on Foxite, Spanish Google Groups and mainly in UniversalThread (Chen, the Developer, participate in UT forums) It creates a real 64 bit EXE and solves some VFP bugs, but need the VFP IDE and original runtimes. In his web there is documentation, b

[NF] Website Redirect...

Guys, Without playing around with the ISP settings what is a simple way of redirecting a website to a different domain home page. I specifically don't want redirect it at the control panel level. http://www.example.com/";> I have tried putting this into the header of the home page but it doesn'

Re: 64 bit VFP compiler?

On Tue, 1 Mar 2016, at 02:43 PM, Dave Crozier wrote: > Never heard of it at all, or the company but I just installed it on a Win > 7 64bit VM and it installed no problem. Seeps to be the real deal. As far as I know it isn't a 64-bit Visual FoxPro compiler. It takes a standard EXE built from VFP,

Re: 64 bit VFP compiler?

This has been used and discussed on the www.foxite.com site. Kind regards Andrew Stirling 01250 870397 / 874580 07910467915 supp...@calcpay.co.uk http://www.calcpay.co.uk On 01/03/2016 14:25, Wes Wilson wrote: Has anyone heard of this compiler? If so, any comments about it? http://www.baiyuji

RE: 64 bit VFP compiler?

Never heard of it at all, or the company but I just installed it on a Win 7 64bit VM and it installed no problem. Seeps to be the real deal. I'll try and do a few compilations to see how it goes. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Wes Wi

64 bit VFP compiler?

Has anyone heard of this compiler?  If so, any comments about it? http://www.baiyujia.com/vfpcompiler/en/default.asp  Wes Wilson, President ERW Custom Programming, Inc. Crescent Lake Plaza 5459  Elizabeth Lake Rd. Waterford, MI 48327 (248) 683-4182 LinkedIn Profile www.erw.com weswil...@erw.c

RE: How to allow multiple forms to update the same record pointer in a table

Joe - I completely agree with you - that it shouldn't be necessary. As another WAG - do you have anything in a Data Environment on either the 1st form - or the 2nd form that is called? Regards, Kurt Wendt Consultant Tel. +1-212-747-9100 www.GlobeTax.com -Original Message- From: Profo

ProFox List Statistics for February 2016

== ProFox List Statistics February 2016 == Subscriber Count at End of Month: ProFox: 283 ProFoxTech: 187 == Total Posts: 4

Re: How to allow multiple forms to update the same record pointer in a table

Darren and Rafael I was thinking of passing the record number between forms but understood that it should not be necessary. I plan to build a very simple demo app from scratch. If that exercise doesn't shake out the problem I will zip it

RE: Import/Export with CSV

Darren, Good spotting! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Darren Sent: 29 February 2016 21:22 To: profox@leafe.com Subject: RE: Import/Export with CSV Took a look at that link and it references an Excel add-on - "Power Query" - looks like