RE: Update table using SPT

2013-02-14 Thread Dave Crozier
Ajoy, If you are using SPT and you are retrieving a cursor from SQL Server then you set the attributes of the cursor to reflect the update behaviour using cursorsetprop(). You need to set the Keyfieldlist, Tables, UpdatableFieldList, Updatetype and Wheretype properties. Then the cursor will

Re: Update table using SPT

2013-02-14 Thread Ajoy Khaund
Thanks Dave. Finally understood what the MakeUpdateable.prg was all about. I use to see people refering to it but never realized what it was for. Thanks Paul McNett. Is there any problem if the name of the backendtable local alias has the same name. Since I am converting Vfp forms life will be

RE: Update table using SPT

2013-02-14 Thread Dave Crozier
No, the name is irrelevant, you give the result dataset a cursor name of your own choice. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ajoy Khaund Sent: 14 February 2013 14:31 To: profox@leafe.com Subject: Re: Update table using SPT Thanks Dave.

Re: When did MS start requiring logins to MSDN?

2013-02-14 Thread Gene Wirchenko
At 10:56 2013-02-13, Dan Covill dcov...@san.rr.com wrote: [snip] This is spreading like the flu, every place you go you are asked to log in or 'create an account'. I think I understand why they're doing it (to keep the scammers at bay), but it's a real PITA. imdb.com (Internet Movie

Index does not match database

2013-02-14 Thread Jeff Johnson
I am working on a Web Connect application that has an unusual problem. When browsing a file I received an Index does not match database which kicks me out of the browse. When I reissue the browse it is fine. The unusual problem could definitely be related to a mismatched index. I have

RE: Index does not match database

2013-02-14 Thread Richard Kaye
Pathing? Possibly picking up a similarly named index from the wrong place the first time? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Thursday, February 14, 2013 1:14 PM To: profoxt...@leafe.com Subject: Index does not

Re: Index does not match database

2013-02-14 Thread Jeff Johnson
My curdir() is the folder the table is in. Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com www.arelationshipmanager.com On 02/14/2013 11:17 AM, Richard Kaye wrote: Pathing? Possibly picking up a similarly named index from the wrong place the first time? --

Re: Index does not match database

2013-02-14 Thread MB Software Solutions, LLC
On 2/14/2013 1:23 PM, Jeff Johnson wrote: My curdir() is the folder the table is in. Jeff You've got a CDX and not the older IDX, right? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com

[NF] Government Software Controls

2013-02-14 Thread Ken Dibble
A while ago I mentioned that government medical billing software has inadequate controls to protect against fraudulent or invalid billing attempts. I wasn't exaggerating. From a news report: New York State Comptroller Tom DiNapoli’s office has released

Re: Index does not match database

2013-02-14 Thread Jeff Johnson
Yep Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com www.arelationshipmanager.com On 02/14/2013 11:43 AM, MB Software Solutions, LLC wrote: On 2/14/2013 1:23 PM, Jeff Johnson wrote: My curdir() is the folder the table is in. Jeff You've got a CDX and not

Re: Index does not match database

2013-02-14 Thread Sytze de Boer
Delete the CDX and issue the index on command I have seen this on a number of occasions where I have overwritten the DBF's with another set of DBF's without also over-writing the CDX's The issue of Index does not match database may not be immediately apparent to the system. My system traps this

Re: Index does not match database

2013-02-14 Thread Jeff Johnson
Sytze: I agree with everything you've said, but once it does not match it continues not to match until you reindex or re-create like you mentioned before. This one did not match and then seconds later, matched. I have only seen this when copying files but there is no copy function going on.

Re: [NF] Government Software Controls

2013-02-14 Thread MB Software Solutions, LLC
On 2/14/2013 2:05 PM, Ken Dibble wrote: A while ago I mentioned that government medical billing software has inadequate controls to protect against fraudulent or invalid billing attempts. I wasn't exaggerating. From a news report: New York State Comptroller Tom DiNapoli’s office has released

Re: VFP5 question about SUM - Crazy behaviour

2013-02-14 Thread José Olavo Cerávolo
--- I know you can think i'm just silly, but ... assuming that there is a minus operator within calculation, it is possible to reach a zero result ; so, what is the result if you : select sum (ncost - lnFreight) * nshipqty from msambb where cclass = CLASS ? G?rard.  Hi Gerard, I check the

ThisForm.Dock(1) results in a C0000005

2013-02-14 Thread Tracy Pearson
A very strange thing is happening with one customer. Customer states the system is a fresh Windows XP install. It performs like it is. Very little installed on it. Would anyone have any thoughts on why this might be happening? Thank you, Tracy ___

Re: ThisForm.Dock(1) results in a C0000005

2013-02-14 Thread M Jarvis
On Thu, Feb 14, 2013 at 2:20 PM, Tracy Pearson tr...@powerchurch.com wrote: A very strange thing is happening with one customer. Customer states the system is a fresh Windows XP install. It performs like it is. Very little installed on it. Would anyone have any thoughts on why this might be

RE: ThisForm.Dock(1) results in a C0000005

2013-02-14 Thread Tracy Pearson
M Jarvis wrote on 2013-02-14: On Thu, Feb 14, 2013 at 2:20 PM, Tracy Pearson tr...@powerchurch.com wrote: A very strange thing is happening with one customer. Customer states the system is a fresh Windows XP install. It performs like it is. Very little installed on it. Would anyone

Re: [NF] Government Software Controls

2013-02-14 Thread Jerry Wolper
I am not a professionally trained programmer, and I will bet you that the people who created this software are. So much for professional training. We have no idea who wrote the software, or even if the vendor knows. Maybe it was outsourced to someplace really cheap, where the programmers may

Re: ThisForm.Dock(1) results in a C0000005

2013-02-14 Thread Dan Covill
On 02/14/13 02:20 PM, Tracy Pearson wrote: A very strange thing is happening with one customer. Customer states the system is a fresh Windows XP install. It performs like it is. Very little installed on it. Would anyone have any thoughts on why this might be happening? Fresh install? Hm.

Re: [NF] Government Software Controls

2013-02-14 Thread Ken Dibble
I am not a professionally trained programmer, and I will bet you that the people who created this software are. So much for professional training. We have no idea who wrote the software, or even if the vendor knows. Maybe it was outsourced to someplace really cheap, where the programmers

Re: [NF] Government Software Controls

2013-02-14 Thread Ken Dibble
Thanks for sharing, Ken. I'm going to show this to my peers here at the day gig. We do audits on Medicaid payments to providers in some states (but not New York!) and the main app is a VFP app. That's very cool, Michael. Maybe the state will be looking for somebody like you to watch the

Re: VFP5 question about SUM - Crazy behaviour

2013-02-14 Thread Frank Cazabon
Can you post some sample data here and your code? Preferably post the sample data using CREATE and INSERT statements so we can copy and paste the code into a program to test it out. Frank. Frank Cazabon On 14/02/2013 04:52 PM, José Olavo Cerávolo wrote: --- I know you can think i'm just

Re: Office automation

2013-02-14 Thread Frank Cazabon
I think you pass the password in as part of the SaveAs() method. Frank. Frank Cazabon On 14/02/2013 09:35 PM, Sytze de Boer wrote: Does anyone know how to apply a password to an Excel spreadsheet, when creating such a file via VFP ___ Post

Re: ThisForm.Dock(1) results in a C0000005

2013-02-14 Thread Tracy Pearson
Dan Covill dcov...@san.rr.com wrote: why this might be happening? Fresh install? Hm. Were the VFP run-times re'installed' or just re-loaded? I've never done a Dock(), but I assume it docks the form to one border of the window. Was this running in XP before? Dan The installer registers

Re: [NF] Government Software Controls

2013-02-14 Thread MB Software Solutions, LLC
On 2/14/2013 8:30 PM, Ken Dibble wrote: It's a huge corporation that is supposed to be an industry leader. What you are saying is essentially what I'm saying: It doesn't matter what your academic background is, you can still make a catastrophic error that will cost your clients millions of

[NF] The 'New File System' Revisited

2013-02-14 Thread Dan Covill
Remember the 'New File System' that was supposed to be part of Windows Vista, but was scuttled in order to ship something in this century? We all heaved a huge sigh of relief. But what WAS the NFS, an what was it supposed to do for us? I certainly never new, and I suspect most others didn't