RE: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Dave Crozier
Bind the form controls to the form data object's properties. That way they stay independent of the main data and you can manipulate them to your hearts content until you want to commit or roll back the changes. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On B

Re: [WC] Sad story at the World Cup

2014-06-24 Thread Ricardo Aráoz
El 17/06/14 10:08, Ed Leafe escribió: On Jun 16, 2014, at 8:16 PM, Ricardo Aráoz wrote: Soccer? What's that? Is that the game you play with an oval ball, using full body armour, and passing it with your hands? Why didn't you call it handball? Or armourball? https://app.box.com/s/vqdwpbrfoz47

RE: Is there a better way...

2014-06-24 Thread Bob Lee
This soltution might be overkill Buta webservice is really what you want. Amazon has one design just for this.. workflows Called Simple WorkFlow http://aws.amazon.com/swf/faqs/ Like every webservice Amazon provides there is a free level, and paid level and there is a pretty steep learning c

Re: Is there a better way...

2014-06-24 Thread Ted Roche
On Tue, Jun 24, 2014 at 6:44 PM, M Jarvis wrote: > > Sounds kinda like you are talking about a 'dashboard' it requeries > itself every X minutes or so to update stuff on the page like "Orders > placed this hour" or "Support Calls Matt Didn't Answer Because He No > Longer Gives a Flying Flip".

Re: Is there a better way...

2014-06-24 Thread Ted Roche
On Tue, Jun 24, 2014 at 6:11 PM, Mike Copeland wrote: > > I was simply 'wondering out loud' if such a process was possible > (communicating upstream from server) between MariaDB and VFP. I can see a > lot of places it would be useful, but what triggered the question is a > simple scenario where a

RE: Is there a better way...

2014-06-24 Thread Dan Covill
I'm not a fan of "Push", too many ways for it not to get there. I'd just query the server. A few years ago (say, about 20!) I did something like this for a 'live' backup system. FoxPro DOS system with 30 workstations, traffic got to where daily night backups just wouldn't cut it. I used a wor

Re: Is there a better way...

2014-06-24 Thread Mike Copeland
That's actually not a bad idea! I've already got forms in my app that incorporate IE, and I have a web server available that I can write to...Thanks! (Keep smokin'!) Mike M Jarvis wrote: On Tue, Jun 24, 2014 at 3:11 PM, Mike Copeland wrote: All good to hear, Mike (opinions and everything.)

Re: Is there a better way...

2014-06-24 Thread M Jarvis
On Tue, Jun 24, 2014 at 3:11 PM, Mike Copeland wrote: > All good to hear, Mike (opinions and everything.) > > I was just curious if anyone was aware of a methodology similar to what I > think is called "push" in the world of html...where a website server can > tell your browser to update the page

Re: Is there a better way...

2014-06-24 Thread Mike Copeland
All good to hear, Mike (opinions and everything.) I was just curious if anyone was aware of a methodology similar to what I think is called "push" in the world of html...where a website server can tell your browser to update the page contents because the website server, uh, because it wants th

Re: Is there a better way...

2014-06-24 Thread Stephen Russell
On Tue, Jun 24, 2014 at 4:40 PM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 2014-06-24 15:36, Ted Roche wrote: > >> Refine your scenario. If this is just "the shipping computer needs to know >> if there's more work to do, once an order is posted," then, yes, querying >> a >> queue

Re: Is there a better way...

2014-06-24 Thread mbsoftwaresolutions
On 2014-06-24 15:36, Ted Roche wrote: Refine your scenario. If this is just "the shipping computer needs to know if there's more work to do, once an order is posted," then, yes, querying a queue of work to be done ("SELECT NEXT 1 * from ORDERS WHERE tTimeStamp > ltLastChecked") is the simplest.

Re: Is there a better way...

2014-06-24 Thread mbsoftwaresolutions
On 2014-06-24 14:54, Mike Copeland wrote: Simplified scenario... 2 Windows computers using a VFP9 SP2 application, served by 1 MySQL (MariaDB) server on Linux box What is the best way for computer #1 to "do something" and have computer #2 detect that change? (for example, save a new record on th

Re: Is there a better way...

2014-06-24 Thread Stephen Russell
On Tue, Jun 24, 2014 at 2:35 PM, Mike Copeland wrote: > Thanks Stephen. > > From what I've been able to find (i.e. Google) there may be a way to run a > Python or Perl script on the server that would query the database manager > for whatever change is being monitored, and then somehow (insert mag

Re: Is there a better way...

2014-06-24 Thread Gene Wirchenko
At 11:54 2014-06-24, Mike Copeland wrote: Simplified scenario... 2 Windows computers using a VFP9 SP2 application, served by 1 MySQL (MariaDB) server on Linux box What is the best way for computer #1 to "do something" and have computer #2 detect that change? (for example, save a new record

Re: Is there a better way...

2014-06-24 Thread Mike Copeland
Thanks, Ted. Appreciate the input. Mike Ted Roche wrote: On Tue, Jun 24, 2014 at 2:54 PM, Mike Copeland wrote: Simplified scenario... 2 Windows computers using a VFP9 SP2 application, served by 1 MySQL (MariaDB) server on Linux box What is the best way for computer #1 to "do something" and

Re: Is there a better way...

2014-06-24 Thread Ted Roche
On Tue, Jun 24, 2014 at 2:54 PM, Mike Copeland wrote: > Simplified scenario... > 2 Windows computers using a VFP9 SP2 application, served by 1 MySQL > (MariaDB) server on Linux box > > What is the best way for computer #1 to "do something" and have computer > #2 detect that change? > (for example

Re: Is there a better way...

2014-06-24 Thread Mike Copeland
Thanks Stephen. From what I've been able to find (i.e. Google) there may be a way to run a Python or Perl script on the server that would query the database manager for whatever change is being monitored, and then somehow (insert magic beans here) signal back to 'interested workstations' (i.e.

Re: Is there a better way...

2014-06-24 Thread Stephen Russell
On Tue, Jun 24, 2014 at 2:12 PM, Mike Copeland wrote: > Excellent question! Can MySQL or MariaDB initiate contact with and > "signal" a connected user's process? > > It just occurred to me that IF this is possible, I'll also need to keep a > list on the server of "subscribers" that should be cont

Re: Printing Over RDT

2014-06-24 Thread Paul McNett
I've found in my admittedly limited experience that it may be impossible to correctly install the 64 bit drivers on the 32 bit host so the 64 bit client can download them an connect. It is easier going the other way around. > On Jun 24, 2014, at 9:02, Jeff Johnson wrote: > >> On 6/24/2014 8:5

Re: Is there a better way...

2014-06-24 Thread Mike Copeland
Excellent question! Can MySQL or MariaDB initiate contact with and "signal" a connected user's process? It just occurred to me that IF this is possible, I'll also need to keep a list on the server of "subscribers" that should be contacted. Mike Copeland M Jarvis wrote: On Tue, Jun 24, 2014

Re: Is there a better way...

2014-06-24 Thread Mike Copeland
MariaDB is absolutely multi-user...but I'm not aware of any way for it to communicate, unsolicited, with a user. In other words, #1 "does something" with data on the server, I'm not aware of any way for MariaDB to contact #2 and say "Hey, I've got new stuff man!" (Although that would be pretty

Re: Is there a better way...

2014-06-24 Thread M Jarvis
On Tue, Jun 24, 2014 at 11:54 AM, Mike Copeland wrote: > Simplified scenario... > 2 Windows computers using a VFP9 SP2 application, served by 1 MySQL > (MariaDB) server on Linux box > > What is the best way for computer #1 to "do something" and have computer #2 > detect that change? > (for example

Re: Is there a better way...

2014-06-24 Thread Kurt @ VR-FX
When not generate a small Text file - and then be on the lookout for the existence of that Text file. But, it all begs the question - is Not the MariaDB actually Multi-user capable??? -K- On 6/24/2014 2:54 PM, Mike Copeland wrote: Simplified scenario... 2 Windows computers using a VFP9 SP2 a

Is there a better way...

2014-06-24 Thread Mike Copeland
Simplified scenario... 2 Windows computers using a VFP9 SP2 application, served by 1 MySQL (MariaDB) server on Linux box What is the best way for computer #1 to "do something" and have computer #2 detect that change? (for example, save a new record on the server for a processed shipment) Wha

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Ajoy Khaund
Thanks Dave. So are controls on the form like textboxes bound to the cursor or Thisform.oData_Obj ? Ajoy Khaund On Tue, Jun 24, 2014 at 9:15 PM, Dave Crozier wrote: > First Point to any record of the data held in a cursor (usually done in > the Load of the form where you can get the data struc

Re: [NF] UK address correctness

2014-06-24 Thread Stephen Russell
On Tue, Jun 24, 2014 at 12:08 PM, John Weller wrote: > I think they ask you to exclude full stops and commas as they create havoc > if you are importing data as CSV :-)-- > -- I get straight up xml and it is shoved into a SS report. Looks like this: AARHUS KARLSHAMN UK L

RE: [NF] UK address correctness

2014-06-24 Thread John Weller
I think they ask you to exclude full stops and commas as they create havoc if you are importing data as CSV :-) John Weller 01380 723235 07976 393631 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listin

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Stephen Russell
On Tue, Jun 24, 2014 at 9:51 AM, Ajoy Khaund wrote: > Dave, > Thanks for the write up. I got it going. There were some hiccups ofcourse. > > How do you create a data object? > > Do you create a class with all fields of the table as properties? > > - You might consider making a

RE: [NF] UK address correctness

2014-06-24 Thread Brian Pow
Bit late, maybe, but from Royal Mail, on the preferred way to address letters http://services.royalmail.com/delivery/mail-advice/postcodes-addresses-expla ined#3400054 "ADDRESSIS IT REQUIRED? INFORMATION Mr A Smith When applicable

Re: Printing Over RDT

2014-06-24 Thread Jeff Johnson
On 6/24/2014 8:58 AM, Paul McNett wrote: Let me guess. One machine is 64 bit and the other 32? Paul On Jun 24, 2014, at 6:25, Jeff Johnson wrote: On 6/24/2014 6:22 AM, Peter Cushing wrote: Jeff Johnson wrote: I have a customer that is using remote desktop locally on a "server". The "ser

Re: Printing Over RDT

2014-06-24 Thread Paul McNett
Let me guess. One machine is 64 bit and the other 32? Paul > On Jun 24, 2014, at 6:25, Jeff Johnson wrote: > > >> On 6/24/2014 6:22 AM, Peter Cushing wrote: >> Jeff Johnson wrote: >>> I have a customer that is using remote desktop locally on a "server". The >>> "server" is a Windows 7 comput

RE: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Dave Crozier
The scatter should be on a new line obviously... Dave ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchab

RE: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Dave Crozier
First Point to any record of the data held in a cursor (usually done in the Load of the form where you can get the data structure) * Create a data Object Thisform.AddProperty("oData_Obj", null) * * Populate the data object inc memo fields but with blank data oObj=Thisform.oData_Obj scatter name o

Re: [NF] UK address correctness

2014-06-24 Thread Peter Cushing
Adam Buckland wrote: Working in logistics and having worked in direct marketing for my sins, I would always add the county if you have it. Postcodes can be entered incorrectly and deduced badly by software such as Anadata. When I worked for a direct marketing house for a year we got data from a

Re: [NF] UK address correctness

2014-06-24 Thread Adam Buckland
Working in logistics and having worked in direct marketing for my sins, I would always add the county if you have it. Postcodes can be entered incorrectly and deduced badly by software such as Anadata. When I worked for a direct marketing house for a year we got data from a bureau that had been ³

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Ajoy Khaund
My vfp forms connected to master tables are been coded using this method. I have the controls on a pageframe on the first page with Add,Edit,Delete,find & navigation buttons. In my second page I have the data in a grid of main columns. More then one page I have for say products table etc. Thanks

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Ajoy Khaund
Dave, Thanks for the write up. I got it going. There were some hiccups ofcourse. How do you create a data object? Do you create a class with all fields of the table as properties? Please let me know as I want to make the same form in all the ways possible and then choose which I like best. Init

Re: [NF] UK address correctness

2014-06-24 Thread Stephen Russell
On Tue, Jun 24, 2014 at 8:40 AM, Dave Crozier wrote: > Stephen, > "Upon" as well as "on" and "under" are often used where cities maintain > their old medieval names. > > Newcastle on Tyne, > Newcastle under Lyme > Ashton under Lyne (note: not Lyme) > Stratford on Avon > Kingston upon Hull > > It

RE: [NF] UK address correctness

2014-06-24 Thread Dave Crozier
Oh and another set of prefixes to look for are "upper" and "lower" as well as "Royal" eg Lower Peover Royal Tunbridge Wells http://en.wikipedia.org/wiki/List_of_place_names_with_royal_patronage_in_the_United_Kingdom http://en.wikipedia.org/wiki/List_of_generic_forms_in_place_names_in_the_United

Re: [NF] UK address correctness

2014-06-24 Thread Peter Cushing
Stephen Russell wrote: I appreciate that. Is there a rule for use of the word "upon" in address as well? Looking at Kingston upon Hull HU9 5EX Well didn't know that. Kingston upon Hull is the official name for Hull http://en.wikipedia.org/wiki/Kingston_upon_Hull I'd only heard of Kings

RE: [NF] UK address correctness

2014-06-24 Thread Dave Crozier
Stephen, "Upon" as well as "on" and "under" are often used where cities maintain their old medieval names. Newcastle on Tyne, Newcastle under Lyme Ashton under Lyne (note: not Lyme) Stratford on Avon Kingston upon Hull It is normally used to distinguish their name from other places. For example

Re: [NF] UK address correctness

2014-06-24 Thread Stephen Russell
On Tue, Jun 24, 2014 at 2:58 AM, Dave Crozier wrote: > Yes, > County and Postcode are usually placed together on the last line of the > address > > > > > > > > -- I appreciate that. Is there a rule for use of the word "upon" in address as well? Looking at Kingston upon Hu

Re: Printing Over RDT

2014-06-24 Thread Jeff Johnson
On 6/24/2014 6:22 AM, Peter Cushing wrote: Jeff Johnson wrote: I have a customer that is using remote desktop locally on a "server". The "server" is a Windows 7 computer. They have a printer on their workstation (Windows 8) that has a printer connected to a USB. It is a Brother with all of

Re: Printing Over RDT

2014-06-24 Thread Peter Cushing
Jeff Johnson wrote: I have a customer that is using remote desktop locally on a "server". The "server" is a Windows 7 computer. They have a printer on their workstation (Windows 8) that has a printer connected to a USB. It is a Brother with all of the software installed. The printer and sca

Printing Over RDT

2014-06-24 Thread Jeff Johnson
I have a customer that is using remote desktop locally on a "server". The "server" is a Windows 7 computer. They have a printer on their workstation (Windows 8) that has a printer connected to a USB. It is a Brother with all of the software installed. The printer and scanner work fine local

RE: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Dave Crozier
I meant CursorAdapter not Table Adapter ... too much using C# the last few months!! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of AndyHC Sent: 24 June 2014 12:12 To: profox@leafe.com Subject: Re: Data Entry Form using Sql Server & SPT Dave Crozier

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Eurico Chagas Filho
I use views for all tables that I need to open. Each form has a pageframe, the first page opens a grid that shows, say, all customers in order chosen by the header of the columns. In this first page there three buttons, select, new and exit. In the second page that comes up, in the bottom, there ar

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread AndyHC
Dave Crozier +1 - you could also consider using a CursorAdapter [as a data object]. There is a builder available, and as VFP Help! suggests: see Data Access Management Using CursorAdapters . --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- k

RE: [NF] UK address correctness

2014-06-24 Thread Allen
I was brought up to add county. In fact Sussex was just that when I was young, sigh, and not east or west Sussex. But like I said, in theory all you need is a house name or number and the post code. In practice they still want a whole lot of writing for the sake of it. Al -Original Message

RE: [NF] UK address correctness

2014-06-24 Thread Dave Crozier
oops, My should have read As Andy says, no need for county if you have the postcode. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 24 June 2014 08:58 To: ProFox Email List Subject: RE: [NF] UK address correctness Yes, County and

RE: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Dave Crozier
Ajoy, The usual procedure of using a "data object" which is an object containing the current, or in the case of a new record, a blank set of data is used. You do the changes to the data object by binding the object properties to the form controls (textbox etc) and then you can freely manipulate

Re: [NF] UK address correctness

2014-06-24 Thread AndyHC
According to the post office (and significantly different from what I learned at school): When addressing your UK mail: * avoid using full stops or commas * start each line on the left (do not centre the lines) * you don't need to write the name of the county if you have included the post

Re: [NF] Problem Inst. Old SW on New OS....

2014-06-24 Thread AndyHC
XP Mode /can/ be installed on Home versions of Win7 - Google it (usual caveats on security considerations). On 24/06/2014 02:51, Charles Hart Enzer, M.D. wrote: I solved the problem using VMWare Client with an OS of WIN XP Pro. I gave it a virtual drive of 0.5 G. Fox -- FoxPro Dos and FPW 2.6

RE: [NF] UK address correctness

2014-06-24 Thread Dave Crozier
Yes, County and Postcode are usually placed together on the last line of the address Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: 24 June 2014 02:11 To: ProFox Email List Subject: RE: [NF] UK address correctness At 23:57 2