Re: exporting to text delimited

2013-10-29 Thread Dan Covill
On 10/29/13 07:31 PM, Gary Jeurink wrote: COPY TO c:\alldat2\special\tmppfbstats.txt FOR pfbstats2.year=2013 FIELDS Pfbstats2.tmid, Pfbstats2.year, ... use FIELDS Pfbstats2.tmid, str(Pfbstats2.year,4) as Cyear, . etc Then the DELIMITED will put quotes around it. Dan

RE: exporting to text delimited

2013-10-29 Thread Virgil Bierschwale
I'm rusty, but it is probably dtoc("pfbstats2.year") You might have to do something along these lines alltrim(dtoc("pfbstats2.year")) Ltrim() will work as well, or rtrim() depending on which way you need to go As for the rest, I don't know what your fields are, but you will need to build it M_Y

exporting to text delimited

2013-10-29 Thread Gary Jeurink
Long ago I learned how to create data dump to text file snippets by browsing a table and then using the export option to build the statement for me and then copy it out of the command window and make it into a procedure. any way I need to export the football season (a 4-digit) integer as a string w

Re: [NF] Change URL in desktop shortcuts and or IE bookmarks?

2013-10-29 Thread Stephen Russell
On Tue, Oct 29, 2013 at 4:41 PM, Richard Kaye wrote: > What games do you play? ;-) > > -- > :) -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME par

RE: [NF] Change URL in desktop shortcuts and or IE bookmarks?

2013-10-29 Thread Richard Kaye
What games do you play? ;-) Just curious. Thanks. You could write a VFP program to update those bookmarks for you. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, October 29, 2013 5:37 PM To: profoxt...@leaf

Re: [NF] Change URL in desktop shortcuts and or IE bookmarks?

2013-10-29 Thread Stephen Russell
1. That server is going to the grave. 2. We don't play that game. 3. Our DNS has way too many false pointers as it is. On Tue, Oct 29, 2013 at 4:26 PM, Richard Kaye wrote: > Why not just add a permanent redirect in your web server(s)? > > -- > rk > > -Original Message- > From: ProfoxTec

RE: [NF] Change URL in desktop shortcuts and or IE bookmarks?

2013-10-29 Thread Richard Kaye
Why not just add a permanent redirect in your web server(s)? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, October 29, 2013 5:17 PM To: profoxt...@leafe.com Subject: [NF] Change URL in desktop shortcuts and or

[NF] Change URL in desktop shortcuts and or IE bookmarks?

2013-10-29 Thread Stephen Russell
We are going to demote an older web server and we know that users have bookmarks wherever they can hide them. Anybody done a script in powershell or vbscript to search for: http://OldServerName/AppPathHere to replace with http://NewServerName/AppPathHere? TIA -- Stephen Russell Sr. Analyst Rin

RE: Grid Column References

2013-10-29 Thread Richard Kaye
In addition you should look at the BeforeRowColChange and AfterRowColChange events and RowColChange property. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Tuesday, October 29, 2013 2:20 PM To: profoxt...@leafe.com Su

RE: Grid Column References

2013-10-29 Thread Tracy Pearson
Gene Wirchenko wrote on 2013-10-29: > Dear Vixens and Reynards: >What is the best way to define a fixed reference to a column? > >When the operator tries to move away from the current row, I > want the current control's validation to be done, and if that > succeeds, then

Re: Grid Column References

2013-10-29 Thread Rafael Copquin
You should take a look at the sequence of events. In a textbox it goes like this: when-gotfocus-keypress-valid-lostfocus. I have a little form that shows you in what order events fire, which I can send to you if you want. You should program your validation code in the textboxes of the columns

Grid Column References

2013-10-29 Thread Gene Wirchenko
Dear Vixens and Reynards: What is the best way to define a fixed reference to a column? When the operator tries to move away from the current row, I want the current control's validation to be done, and if that succeeds, then the row-level validation to be done. If the row-level va

Re: Grids and Form Closing

2013-10-29 Thread Peter Cushing
Gene Wirchenko wrote: Dear Vixens and Reynards: The scenario: you have a form with a grid on it. The user closes the form. There is a validation error, and in that case, you want the form to not close. My solution was to add a property to the form called .griderror. In the cont

Re: Grids and Form Closing

2013-10-29 Thread Gene Wirchenko
At 10:43 2013-10-26, Rafael Copquin wrote: What about using a try-catch construct wherever there is a posibility of an error being generated? I am talking about validation errors, not run-time errors. [snip] Sincerely, Gene Wirchenko ___ Po