RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Ken Dibble
He's really parameter checking with that TYPE test, not checking that the alias is USED. Exactly. But if the alias is not USED(), then he assumes its TYPE() will be "U" so he doesn't have to close it. And I believe it works without having to address work areas, at least within the current d

RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Richard Kaye
He's really parameter checking with that TYPE test, not checking that the alias is USED. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Dibble Sent: Friday, July 17, 2015 8:19 PM To: profoxt...@leafe.com Subject: Re: "File In Use" on USE

Re: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Ken Dibble
procedure closeforsql lparameters thealias if type("alias(thealias)")#T_U use in (thealias) endif return endproc This is kind of similar to what my query class does to clean up after itself. However, my class keeps track of tables/work areas that were open before the

Re: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Ken Dibble
If you want to be CERTAIN that you are getting a new data file on disk/in memory disconnected from the original source, you can: (1) change the structure by adding a field not in the original source, even a .t. as dummyfield, to the field list. (2) use READWRITE or NOFILTER, depending on your n

Re: Best way to do one-way synchronized approach?

2015-07-17 Thread Fernando D. Bozzo
Hi Mike: You may use the same approach that is recommended when using remote views to SQL-Server or other Databases to sync in local, that is using a timestamp field which is used in conjunction with the primary key for quickly obtain the new records, and update your local tables. 2015-07-17

Re: SMB2

2015-07-17 Thread Allen
Thank you Fernando Al -Original Message- From: Fernando D. Bozzo Sent: Friday, July 17, 2015 8:41 PM To: profoxt...@leafe.com Subject: Re: SMB2 Hi Allen: This topic have been discussed many times on various forums, and the latest information I have (I think that from a discussion on F

Re: Best way to do one-way synchronized approach?

2015-07-17 Thread Jean MAURICE
there is another solution not so efficient that the one you want but a lot more simpler. The first time a table is needed for lookup, you download it in the datasession n°1 (for example). I do this using a class with a child class for each table. Using pemstatus( ,5) I can chek if the child cl

Re: Best way to do one-way synchronized approach?

2015-07-17 Thread Kevin Cully
Create a trigger on the insert or update for the lookup table into a checksum table. The trigger could UPDATE CheckSumTable SET TableUUID=UUID(), LastUpdate=NOW() WHERE TRIM(TableName)='LookupTable'; The above code needs to be MariaDB-SQLized but you get the idea. CULLY Technologies, LLC http

Re: Best way to do one-way synchronized approach?

2015-07-17 Thread mbsoftwaresolutions
Sorry...I should have specified: this is NOT a VFP table on the server, but MySQL instead. The local copy would be a Fox table though. On 2015-07-17 15:08, Ted Roche wrote: You can check LUPDATE() on the remote tables. Or create a master table on the server that stores the datetime the tables

Re: Best way to do one-way synchronized approach?

2015-07-17 Thread mbsoftwaresolutions
Hi Kevin! That's what I meant by my CHECKSUM checking comment. Thanks, --Mike On 2015-07-17 14:03, Kevin Cully wrote: I'd probably do an MD5 on the lookup table and save that to a text file. Then compare that to a local file. Example: lookup.dbf ... do an MD5 on lookup.dbf and save that val

RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Kurt Wendt
Pretty funny anecdote there Ken. Reminds me of me. In my case - if people ask if I do Coding/programming or database work outside of my regular job. I say - NO WAY Baby - I do enough of that by Day! So - when I'm not at work - I ONLY do 3D CG or 3D Printing work. One day soon - I hope that's ALL

Re: Best way to do one-way synchronized approach?

2015-07-17 Thread mbsoftwaresolutions
On 2015-07-17 13:24, Gene Wirchenko wrote: At 09:01 2015-07-17, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Say I've got tables on a server that are "lookup" libraries, and by that, I mean the change somewhat infrequently. Instead of always searching those tables on the server, I'd like

Re: Microsoft Date Time Picker properties

2015-07-17 Thread Mike Copeland
I have no idea why it is that way, it just always has been. I have always attributed it to VFP being a red-headed step-child at MSoft...although I'm sure it has a much more technical cause. Mike Joe Yoder wrote: Thanks Mike - I guess I'm not the only one wondering! Joe On Fri, Jul 17, 2015

Re: Best way to do one-way synchronized approach?

2015-07-17 Thread Ted Roche
You can check LUPDATE() on the remote tables. Or create a master table on the server that stores the datetime the tables were last updated. Frankly with current network speeds, disk and RAM caching, I'd be skeptical whether all this overhead would be justified. The only way to be certain, of cours

(Re-sending) Best way to do one-way synchronized approach?

2015-07-17 Thread mbsoftwaresolutions
Ken Dibble -- I never saw my original show up either. Let's try this again. Say I've got tables on a server that are "lookup" libraries, and by that, I mean the change somewhat infrequently. Instead of always searching those tables on the server, I'd like to pull them locally for faster pr

Re: Microsoft Date Time Picker properties

2015-07-17 Thread Joe Yoder
Thanks Mike - I guess I'm not the only one wondering! Joe On Fri, Jul 17, 2015 at 2:58 PM, Mike Copeland wrote: > Joe, > > My experience, right or wrong technically, has been that if the object > exposes the property through the OCX interface (right click on the object > that is shown on a form

Re: Microsoft Date Time Picker properties

2015-07-17 Thread Mike Copeland
Joe, My experience, right or wrong technically, has been that if the object exposes the property through the OCX interface (right click on the object that is shown on a form in the development environment, choose the properties option at the bottom of the popup) then I can access it, set it,

Re: Microsoft Date Time Picker properties

2015-07-17 Thread Joe Yoder
Thanks guys for the pointers with directions and examples! I should be able to find answers going forward now that I can get to the properties. I am still puzzled about how the VFP properties sheet lines up with the active-x control properties. Some of the VPF properties don't seem to work as ex

Re: SMB2

2015-07-17 Thread Fernando D. Bozzo
Hi Allen: This topic have been discussed many times on various forums, and the latest information I have (I think that from a discussion on Foxite) is that this fix is working for many people with the same problem: http://www.alaska-software.com/community/smb2.cxp Regards.- 2015-07-17 14:18

Re: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Ken Dibble
Our email medium here at Profox, otoh, is plain text. It appear fine in a browser, an email client, even emacs! For some definition of "fine" and some definition of "plain text". All email is encoded in some fashion. If you use a device or a service that inserts UTF-8 or some other double-b

Re: Best way to do one-way synchronized approach?

2015-07-17 Thread Kevin Cully
I'd probably do an MD5 on the lookup table and save that to a text file. Then compare that to a local file. Example: lookup.dbf ... do an MD5 on lookup.dbf and save that value to lookup.md5 During the startup of the application, compare the local lookup.md5 with the file on the server. Shoul

Re: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Ted Roche
RTF is an MS proprietary, though unusually well-documented, format for pretty fonts and styles. It requires a word processor to read. Ken's document contained no styles that I could discern, won't be added to the ProFox list archives, and perhaps may even be unreadable by future generations of soci

Re: Best way to do one-way synchronized approach?

2015-07-17 Thread Gene Wirchenko
At 09:01 2015-07-17, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Say I've got tables on a server that are "lookup" libraries, and by that, I mean the change somewhat infrequently. Instead of always searching those tables on the server, I'd like to pull them locally for faster processing

Re: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Gene Wirchenko
At 12:46 2015-07-16, Ted Roche wrote: On Thu, Jul 16, 2015 at 3:09 PM, Ken Dibble wrote: > Okay. Somebody else said SELECTs operate in their own data session. I think Laurie meant something else. In this case what I mean is this, starting from a fresh VFP session: create table temp (field1

Re: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Gene Wirchenko
At 10:04 2015-07-16, Ted Roche wrote: RTF? How... quaint. VFP? How... quaint. I use tools that work. What should quaintness have to do with it? [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Ma

Re: [ADMIN] New post not showing?

2015-07-17 Thread Ken Dibble
I see this one but not the original post (without the Re:) to which this one responds. Ken Dibble www.stic-cil.org At 08:57 AM 7/17/2015 -0700, you wrote: You do exist! Fred On Fri, Jul 17, 2015 at 9:04 AM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > Testing...it appears that my

Re: [NF] Tech skills no longer in demand

2015-07-17 Thread Stephen Russell
On Fri, Jul 17, 2015 at 10:58 AM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > They always says "C" (not C++ or C#) tops the list! > -- Some of the differences between all those zany C languages. http://www.cplusplus.com/forum/general/75807/ -- Stephen Russell Sr. Anal

Re: Corrupted CDXs - major headache

2015-07-17 Thread Alan Bourke
If Server 2008 and Windows 7 then ensure all are service-packed up, and up to date, and install the Microsoft Enterprise Hotfix Rollup on both. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Ma

Re: SMB2

2015-07-17 Thread Allen
No your right Ted it's c:/users/#username#/appdata/local/gsl/coordm/flt2.dbf But I didn't feel it worth spelling out. I will try a few things when I get a chance and report if I find anything. AL -Original Message- From: Ted Roche Sent: Friday, July 17, 2015 5:56 PM To: profoxt...@leaf

RE: [ADMIN] New post not showing?

2015-07-17 Thread mbsoftwaresolutions
Thanks, guys. Problem must be on my end. On 2015-07-17 12:02, Kurt Wendt wrote: Yes Mike - I saw it! -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Friday, July 17, 2015 12:07 PM To: profoxt...@le

Re: [ADMIN] Help Garrett Fitzgerald

2015-07-17 Thread mbsoftwaresolutions
Only saw this now. Donation made! Good luck, Garrett. On 2015-06-16 10:14, Garrett Fitzgerald wrote: Thanks, Ed. It's very frustrating putting "days at Microsoft" and begging for help in the same post. I really appreciate all the assistance I've gotten over the past week -- it's done a lot fo

RE: [ADMIN] New post not showing?

2015-07-17 Thread Kurt Wendt
Yes Mike - I saw it! -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Friday, July 17, 2015 12:07 PM To: profoxt...@leafe.com Subject: Re: [ADMIN] New post not showing? Thanks, Fred! Did you see the

Re: [ADMIN] New post not showing?

2015-07-17 Thread Fred Taylor
Yep, saw that one too. Fred On Fri, Jul 17, 2015 at 9:06 AM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > Thanks, Fred! Did you see the thread I (tried to) post recently on using > CHECKSUM to do a 1-way synch on a table? > > > > On 2015-07-17 11:57, Fred Taylor wrote: > >> You do ex

Re: [ADMIN] New post not showing?

2015-07-17 Thread mbsoftwaresolutions
Thanks, Fred! Did you see the thread I (tried to) post recently on using CHECKSUM to do a 1-way synch on a table? On 2015-07-17 11:57, Fred Taylor wrote: You do exist! Fred On Fri, Jul 17, 2015 at 9:04 AM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: Testing...it appears that my

Re: [ADMIN] New post not showing?

2015-07-17 Thread Fred Taylor
You do exist! Fred On Fri, Jul 17, 2015 at 9:04 AM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > Testing...it appears that my replies go to the list, but not new posts. > > tap-tap-tapis this thing on? Is anybody out there? Just nod (and > reply) if you can hear me(and now t

[ADMIN] New post not showing?

2015-07-17 Thread mbsoftwaresolutions
Testing...it appears that my replies go to the list, but not new posts. tap-tap-tapis this thing on? Is anybody out there? Just nod (and reply) if you can hear me(and now that song is in your head). :-) lol ___ Post Messages to: ProFox@le

Re: SMB2

2015-07-17 Thread Ted Roche
On Fri, Jul 17, 2015 at 11:22 AM, Allen wrote: > An idea Peter. I have got over the issue at the moment by running what I > need to on another machine. But I would like to know why it fails. > Al > me, too. > if file(blar) >delete blar > endif IME, when I get this wrong, it's usually becau

Re: [NF] Tech skills no longer in demand

2015-07-17 Thread mbsoftwaresolutions
:D And they all said to dump the Fox 10+ years ago. ha! On 2015-07-16 15:43, Mike Copeland wrote: Whew! Looks like we made a good choice in skill sets to acquire after all... Mike Stephen Russell wrote: Fox is not on the list! http://readwrite.com/2013/05/01/10-technology-skills-no-longe

Best way to do one-way synchronized approach?

2015-07-17 Thread mbsoftwaresolutions
Say I've got tables on a server that are "lookup" libraries, and by that, I mean the change somewhat infrequently. Instead of always searching those tables on the server, I'd like to pull them locally for faster processing---BUT I DON'T WANT TO PULL THEM EVERY TIME WHEN NOTHING HAS CHANGED. W

Re: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Ted Roche
On Fri, Jul 17, 2015 at 11:32 AM, Ken Dibble wrote: > > My previous understanding was that if there is a WHERE clause or an ORDER BY > clause in the query, then VFP always creates the temp file on disk. > My belief is very similar to yours, but a little different. If the SQL engine can give you t

Re: SMB2

2015-07-17 Thread Allen
Having noticed windows 8.1 slow releasing a flash drive I can believe this could happen. Al -Original Message- From: Peter Cushing Sent: Friday, July 17, 2015 5:35 PM To: profoxt...@leafe.com Subject: Re: SMB2 On 17/07/2015 16:22, Allen wrote: An idea Peter. I have got over the issue

Re: [NF] Tech skills no longer in demand

2015-07-17 Thread mbsoftwaresolutions
(For IN-demand, I mean) On 2015-07-17 11:58, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: They always says "C" (not C++ or C#) tops the list! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listin

Re: [NF] Tech skills no longer in demand

2015-07-17 Thread mbsoftwaresolutions
They always says "C" (not C++ or C#) tops the list! On 2015-07-16 15:35, Stephen Russell wrote: Fox is not on the list! http://readwrite.com/2013/05/01/10-technology-skills-no-longer-in-demand -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime

Re: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Ken Dibble
This may not be relevant but you can get all sorts of horrors if you have a dangling private datasession with open cursors. Thank you Laurie. Please see my response to Charlie. I don't use any private datasessions. Ken ___ Post Messages to: Pro

RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Ken Dibble
READWRITE can also be used to guarantee you are not getting a filtered view. Thank you Richard. Please see my response to Charlie, below. The query in the described scenario contains a JOIN and does not produce a filtered view. Ken ___ Post M

Re: SMB2

2015-07-17 Thread Peter Cushing
On 17/07/2015 16:22, Allen wrote: An idea Peter. I have got over the issue at the moment by running what I need to on another machine. But I would like to know why it fails. Al I would check if windows is just slow letting go of the file first but putting in an inkey(5) before the delete to se

RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Ken Dibble
Charlie, thank you. This is helpful, and I have some responses in-line. AUSED() - can return an array of all aliases in use (and you can specify a datasession if you want) DBC() - returns the path and name of the actual "file" that us associated with an alias So, if you build an array of alia

Re: SMB2

2015-07-17 Thread Allen
An idea Peter. I have got over the issue at the moment by running what I need to on another machine. But I would like to know why it fails. Al -Original Message- From: Peter Cushing Sent: Friday, July 17, 2015 4:25 PM To: profoxt...@leafe.com Subject: Re: SMB2 On 17/07/2015 14:40, All

RE: Corrupted CDXs - major headache

2015-07-17 Thread mbsoftwaresolutions
Good point, RK. Is it possible the anti-virus or similar software is getting in the way too, causing something to fall out of sync? I'd definitely configure your A/V and other scanning softwares to ignore DBF/CDX/FPT files for sure. Glad I no longer use DBFs as my main data storage. (I use

RE: Corrupted CDXs - major headache

2015-07-17 Thread Richard Kaye
This reeks of SMB2/3 issues. Some folks here have claimed that the latest and greatest SPs and enterprise rollups, etc have eliminated their corruption issues but I still recommend that my clients put in the necessary changes to fall back to SMB1. It's been thoroughly discussed here so I'd take

Re: Microsoft Date Time Picker properties

2015-07-17 Thread Philip Borkholder
Joe, Doug Henning has a good posting on the use of it here: http://doughennig.blogspot.com/2008/06/using-microsoft-date-and-time-picker.html And here's a good article on using it in a grid http://weblogs.foxite.com/sandstorm36/2009/08/25/datetime-picker-in-a-grid-how-toupdated/ -Philip On 7/16/

Re: Microsoft Date Time Picker properties

2015-07-17 Thread Philip Borkholder
Hi Joe, That would be under Tools Object Browser Open Hit the tab Com Libraries Scroll down till you find Microsoft Date and Time Picker Control n.0 (SPn) Check the check box and it will display the methods and properties in the Classes & Members section of the Object Bro

Re: RTRIM() of cursor data using _VFP.DataToClip() ?

2015-07-17 Thread Ted Roche
Laurie: On Fri, Jul 17, 2015 at 5:50 AM, Laurie Alvey wrote: > When I posted the CTOV function, you quite rightly pointed out that it > wouldn't solve the DataToClip problem. I meant to say the code should look > something like this: > SELECT something FROM somewhere INTO CURSOR somecursor > CTOV

RE: Corrupted CDXs - major headache

2015-07-17 Thread Dave Crozier
What machine are you using as a central data server? If it is a windows 7 or 8.1 machine then get it changed for a proper server O/S Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Wes Wilson Sent: 17 July 2015 15:52 To: profox@leafe.com Subject: Corr

Re: Rich test in VFP Report

2015-07-17 Thread Fred Taylor
Sure looks like Bo's site is still up: http://www.moxiedata.com/ Fred On Fri, Jul 17, 2015 at 1:30 AM, Dave Crozier wrote: > I remember somewhere in the distant past that Bo produced a component to > allow Rich text in a VFP report. > > I have a requirement to do the same think without using

Corrupted CDXs - major headache

2015-07-17 Thread Wes Wilson
We are getting intermittent "corrupted index" problems.    Visual FoxPro 9.0 sp2;   5 operators; not a very busy system. When adding invoices, about every 50 times, the program freezes.  If it freezes on ABC Company, it will always freeze on ABC.  The operator can then go on and successfully add

Re: SMB2

2015-07-17 Thread Peter Cushing
On 17/07/2015 14:40, Allen wrote: Hi Alan the flt2 table is only used by the local machine and after the use it appears as if it is still used for a few seconds (maybe I dont know) and the delete comes back with the error. Like its still open. If this table is only used by the local machine

RE: Poblems with stonefield database

2015-07-17 Thread Richard Kaye
Are there other include files included by SDT.H? Header files can refer to other header files using the #INCLUDE directive. Based on the error still occurring that may be the case. You also may need to explicitly recompile any source code that refers to that header. Have you done a search for

RE: Poblems with stonefield database

2015-07-17 Thread jerry foote
This has gotten beyond me. I compile the project with a file named SDT.H in the text section and when the program runs "oMeta = CREATEOBJECT('MetaMgr' , .F. , oApp.dataPath )" the program hangs with "varible CCMSG_ERROR_NUM not found" I need to talk with someone who is familiar with stonefield data

RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Kurt Wendt
Yeah - that surely is a bummer - as I know it makes it MUCH Harder if you can't easily re-create the error. I wish you the best of luck on trying to solve this problem - as Luck you will Surely need! -K- -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behal

Re: SMB2

2015-07-17 Thread Allen
ah norton and the like. ok thanks Tracy Al -Original Message- If the Server is doing it locally, SMB2 is not part of the equation. I would investigate anti-virus and backup tools. ___ Post Messages to: ProFox@leafe.com Subscription Maintena

Re: SMB2

2015-07-17 Thread Allen
Hi Alan Its an exe. A part of the exe does a consolidation of data before presenting it. This means selecting data from the same server and working with it using a created dbf in the users appdata/local. This is the one causing problems. DoEvents (no brackets) is supposed to get windows to do it

RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Ken Dibble
So - I'm curious. I know below you mentioned you talked to the user about the issue. And, sorry if you mentioned it in another response. But, is the error repeatable? Were you able to confirm the exact steps a user took - that would cause the error - and you can successfully make the error ha

RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Kurt Wendt
Ken - I'm reading thru your RTF file - as you saw in my previous posting. And, I had a question. I decided to go back to your initial thread - and see if you already answered it - but, its not clear if you did. So - I'm curious. I know below you mentioned you talked to the user about the issue.

RE: SMB2

2015-07-17 Thread Tracy Pearson
Allen wrote on 2015-07-17: > Hi Foxgang. > I have an issue of a file not deleting after close. > There is a server 2008, this is used for data and any pc can work with it > ok. No problems. However the server also does some work. In this instance it > needs to work with a local dbf placed in

RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Kurt Wendt
Yes - I was VERY Afraid to read your RTF. Although - maybe just nit picking - but, you should not have put a black in the file name - as it comes up in this forum thread as an incomplete link - and a bad link if you click on it. But, no biggie - I just cut&pasted the whole thing. Wow - it sure

Re: SMB2

2015-07-17 Thread Alan Bourke
I'm unclear as to why DoEvents() would have anything to do with closing files. Regarding drive caching, I haven't had to touch that since Windows 2000 days so I doubt that's an issue. You also really don't want to turn SMB2 off and shouldn't have to these days, assuming your server and workstatio

RE: Poblems with stonefield database

2015-07-17 Thread Richard Kaye
If you have the project available just add the .h file to the Text files section in the project. You can also exclude any header files from the app or exe as they are only used at compile time. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of

RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Richard Kaye
READWRITE can also be used to guarantee you are not getting a filtered view. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Charlie Sent: Thursday, July 16, 2015 7:22 PM To: profoxt...@leafe.com Subject: Re: "File In Use" on USE "during" SQL S

RE: Microsoft Date Time Picker properties

2015-07-17 Thread Richard Kaye
Try pulling up the type library for the control in the Object Browser. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder Sent: Thursday, July 16, 2015 7:57 PM To: profoxt...@leafe.com Subject: Microsoft Date Time Picker properties I ha

SMB2

2015-07-17 Thread Allen
Hi Foxgang. I have an issue of a file not deleting after close. There is a server 2008, this is used for data and any pc can work with it ok. No problems. However the server also does some work. In this instance it needs to work with a local dbf placed in appdata/local. At one point I close the

Re: Rich test in VFP Report

2015-07-17 Thread Laurie Alvey
I found this link on Fox Wiki: http://www.sand-berg.de/RTF-Listener/ Laurie On 17 July 2015 at 11:13, Dave Crozier wrote: > Ah, web address changed from what I had Al... I'll drop him an email... > > Thanks > > Dave > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com]

Re: Another M$ turnaround ....

2015-07-17 Thread Alan Bourke
On a more serious note though - accusations of Microsoft 'turnarounds' are somewhat unfair sometimes. Silverlight, Windows Phone, and so on - they gambled and lost, so what are they supposed to do? Throw money indefinitely at something that didn't take off? All big tech companies shitcan less popul

Re: Another M$ turnaround ....

2015-07-17 Thread Alan Bourke
I think the Windows Phone 10 release is some way behind the desktop version so the sky might remain in place briefly. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.lea

RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Dave Crozier
Ted, I thought the space had been put there my profox reformatting and was only a "phantom"... got it now thanks! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: 17 July 2015 12:02 To: profox@leafe.com Subject: Re: "File In Use" on USE

Re: RTRIM() of cursor data using _VFP.DataToClip() ?

2015-07-17 Thread Ted Roche
I'll have to try this again. I thought I found varchar fields were right-padded in the DataToClip function, but perhaps I messed up the testing. On Fri, Jul 17, 2015 at 5:50 AM, Laurie Alvey wrote: > When I posted the CTOV function, you quite rightly pointed out that it > wouldn't solve the Data

Re: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Ted Roche
Try replacing the space before the 3 with the percentsign-two-zero, On Fri, Jul 17, 2015 at 3:23 AM, Dave Crozier wrote: > Can't get anything on that link - File not Found, even when I manually type > it. > > Dave > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On

Re: Another M$ turnaround ....

2015-07-17 Thread Ted Roche
On Fri, Jul 17, 2015 at 6:46 AM, Alan Bourke wrote: > Ah, the glories of FUD, clickbait articles and not actually bothering to > read things before jumping on the ZOMG M$ EVUL EMPIRE bandwagon. > > It's dated 2013, and yes they did go ahead and stop supporting Windows > Phone 8. However they updat

Re: Another M$ turnaround ....

2015-07-17 Thread Alan Bourke
Ah, the glories of FUD, clickbait articles and not actually bothering to read things before jumping on the ZOMG M$ EVUL EMPIRE bandwagon. It's dated 2013, and yes they did go ahead and stop supporting Windows Phone 8. However they updated it to Windows Phone 8.1 which remains supported for the for

Re: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Laurie Alvey
This may not be relevant but you can get all sorts of horrors if you have a dangling private datasession with open cursors. Laurie On 17 July 2015 at 08:23, Dave Crozier wrote: > Can't get anything on that link - File not Found, even when I manually > type it. > > Dave > > -Original Message

RE: Rich test in VFP Report

2015-07-17 Thread Dave Crozier
Ah, web address changed from what I had Al... I'll drop him an email... Thanks Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Allen Sent: 17 July 2015 11:09 To: profox@leafe.com Subject: Re: Rich test in VFP Report moxiedata.com is live Dave Al

Re: Rich test in VFP Report

2015-07-17 Thread Allen
moxiedata.com is live Dave Al -Original Message- Al, Tried that but the text I want to display is dynamic and hence you have to load it up into the general field which is a pain and takes for ages. Looking at 1001 things at the moment and the section where you can load up the .rtf d

RE: Rich test in VFP Report

2015-07-17 Thread Dave Crozier
Al, Tried that but the text I want to display is dynamic and hence you have to load it up into the general field which is a pain and takes for ages. Looking at 1001 things at the moment and the section where you can load up the .rtf data into a memo field and then append it into the General fiel

Re: RTRIM() of cursor data using _VFP.DataToClip() ?

2015-07-17 Thread Laurie Alvey
When I posted the CTOV function, you quite rightly pointed out that it wouldn't solve the DataToClip problem. I meant to say the code should look something like this: SELECT something FROM somewhere INTO CURSOR somecursor CTOV(somecursor) _VFP.DataToClip(somecursor,3) Laurie On 16 July 2015 at 15

Re: Rich test in VFP Report

2015-07-17 Thread Allen
Dont know about that but the Rich Text control works ok if you dont mind ocx Al -Original Message- I remember somewhere in the distant past that Bo produced a component to allow Rich text in a VFP report. I have a requirement to do the same think without using General objects and lo

Rich test in VFP Report

2015-07-17 Thread Dave Crozier
I remember somewhere in the distant past that Bo produced a component to allow Rich text in a VFP report. I have a requirement to do the same think without using General objects and loading them with rtf "code" as in Cathy's book on the VFP report writer as it is SLOW, SLOW, SLOW!! Would anyon

RE: Another M$ turnaround ....

2015-07-17 Thread Dave Crozier
Just looked at that article again. How come this says 2014 seeing as how we are in 2015 unless I am living in a time warp.. H! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 17 July 2015 08:28 To: ProFox Email List Subje

Re: Another M$ turnaround ....

2015-07-17 Thread Allen
oh well, that saves bothering to learn programming for windows phones. Al -Original Message- http://readwrite.com/2013/03/18/microsoft-will-cease-support-of-windows-phone-8-in-2014 ___ Post Messages to: ProFox@leafe.com Subscription Mainten

RE: Poblems with stonefield database

2015-07-17 Thread Dave Crozier
Include them in the Other Files section (You can change the search extension to all files). Also look out for forms which have an include file associated with them (As in Form/Include file) which location may well go astray. Include that as well. Dave -Original Message- From: ProFox [

Another M$ turnaround ....

2015-07-17 Thread Dave Crozier
http://readwrite.com/2013/03/18/microsoft-will-cease-support-of-windows-phone-8-in-2014 or http://tinyurl.com/omh9kdo So not only are they dumping the hardware (as in a previous thread), but now the code base is going! Dave --- StripMime Report -- processed MIME parts --- multipart/alternati

RE: "File In Use" on USE "during" SQL SELECT Execution

2015-07-17 Thread Dave Crozier
Can't get anything on that link - File not Found, even when I manually type it. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ken Dibble Sent: 16 July 2015 17:41 To: profox@leafe.com Subject: Re: "File In Use" on USE "during" SQL SELECT Execution >I