Re: VFP needs to REST

2012-08-07 Thread Alan Bourke
I have done some sending of JSON, yes. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

RE: VFP needs to REST

2012-08-07 Thread John Harvey
Alan, Care to share any code? John Harvey -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, August 07, 2012 4:50 AM To: profox@leafe.com Subject: Re: VFP needs to REST I have done some sending of JSON, yes. --

web services

2012-08-07 Thread Allen
Hi foxgang I have a web service and it gets called by an exe. On XP this is fine but on 7 it fails. I assume this is SOAP. Can anyone confirm this and what is required to fix it. It works fine on my 7 laptop but that has VFP on it anyway. Oh yes forgot, it's also failing on a 2008 server. Only

Re: web services

2012-08-07 Thread Tracy Pearson
Allen pro...@gatwicksoftware.com wrote: Hi foxgang I have a web service and it gets called by an exe. On XP this is fine but on 7 it fails. I assume this is SOAP. Can anyone confirm this and what is required to fix it. It works fine on my 7 laptop but that has VFP on it anyway. Oh yes forgot,

RE: web services

2012-08-07 Thread Allen
All I get back from try catch is failing to make the object. I know the web service can be seen as I saw the WSDL in a browser Al -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Hi foxgang I have a web service and it

RE: web services

2012-08-07 Thread Tracy Pearson
Allen pro...@gatwicksoftware.com wrote: All I get back from try catch is failing to make the object. I know the web service can be seen as I saw the WSDL in a browser Al The Mssoap toolkit needs to be installed. -- Tracy Sent from my Android phone with K-9 Mail.

RE: web services

2012-08-07 Thread Allen
Ah ok, thought it might be. Thanks Tracy Al -Original Message- All I get back from try catch is failing to make the object. I know the web service can be seen as I saw the WSDL in a browser Al The Mssoap toolkit needs to be installed. --

RE: web services

2012-08-07 Thread Allen
Tried on the 2008 server and downloaded soap3 and it worked. Al -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Allen Sent: 07 August 2012 15:22 To: profoxt...@leafe.com Subject: RE: web services Ah ok, thought it might be. Thanks

RE: corrupted table and database issues

2012-08-07 Thread Richard Kaye
Did you use the RECOVER option when executing VALIDATE DATABASE? Make sure you have a copy of the table, index and memo, if any. Once the DBC is repaired, you may be able to simply ADD TABLE. If the recover does remove the table reference from the DBC, you will need to re-establish any metadata

RE: corrupted table and database issues

2012-08-07 Thread Tracy Pearson
Richard Kaye wrote on 2012-08-07: Did you use the RECOVER option when executing VALIDATE DATABASE? Make sure you have a copy of the table, index and memo, if any. Once the DBC is repaired, you may be able to simply ADD TABLE. If the recover does remove the table reference from the DBC, you

Re: corrupted table and database issues

2012-08-07 Thread Alan Bourke
Restore to backup ? -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: VFP needs to REST

2012-08-07 Thread Alan Bourke
On Tue, Aug 7, 2012, at 12:52 PM, John Harvey wrote: Alan, Care to share any code? Are you having issues with anything in particular ? -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription

RE: corrupted table and database issues

2012-08-07 Thread James Harvey
I restored a backup, that seems to have repaired the table. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com

Update Conflict

2012-08-07 Thread Michael Oke, II
Strange error happening. VFP 6 application using SQL server backed. We are using remote views to access the data When attempting to save a record that has a text field with special characters in it, such as [ ] square brackets, we get an error: Update Conflict. Anyone have any ideas as to

Re: Update Conflict

2012-08-07 Thread Fred Taylor
Since the square brackets are also string delimiters in VFP, does the code that accesses SQL Server syntax use them as string delimiters? If so, it could confuse the content of the string. ie: m.somevar = [this is a [string in square brackets] would fail] or maybe: m.somevar =

Re: Update Conflict

2012-08-07 Thread Stephen Russell
On Tue, Aug 7, 2012 at 12:07 PM, Michael Oke, II oke...@gmail.com wrote: Strange error happening. VFP 6 application using SQL server backed. We are using remote views to access the data When attempting to save a record that has a text field with special characters in it, such as [ ] square

Re: Update Conflict

2012-08-07 Thread Michael Oke, II
Except the same code, on a different but similar table, does not show the same issue. It is the TableUpdate that throws this error and I'm just trying to narrow down any possible causes. Michael Oke, II 661-349-6221 Contents of this and all messages are intended for their designated

RE: VFP needs to REST

2012-08-07 Thread John Harvey
I need to see how you send client side certs up to the server for LexisNexis (Accurint) and was hoping someone had some experience with that. I've been looking through Rick Strahl's wwhttp class and I see he has the addpostkey() method, but I think I need more on what the exact syntax should be.

Field Width

2012-08-07 Thread John Weller
I'm having a senior moment! What is the maximum value a numeric field of size 6,2 in a dbf can hold? Is it .99 or 999.99 - in other words, do I have to make an allowance for the decimal point? Also, if it is .99 can it also hold -.99? This is so fundamental that I can't find it in

RE: Field Width

2012-08-07 Thread Richard Kaye
I believe the 6 would include the decimal point so for positive values it should be 999.99. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Weller Sent: Tuesday, August 07, 2012 4:22 PM To: profoxt...@leafe.com

Re: Field Width

2012-08-07 Thread Fred Taylor
999.99 or -99.99 The width includes any sign and decimal point. Beware that if you try to put in .99 you'l get 1 and 9.99 you'l get 10. -999.99 will get you -1000 and -.99 will get you -1. 6 total significant characters. Fred On Tue, Aug 7, 2012 at 1:21 PM, John

RE: Field Width

2012-08-07 Thread Richard Kaye
You got me curious so I tried a few things and precision makes things even stranger. CREATE CURSOR test (numfield n(6,2)) SET DECIMALS TO 8 Browse Normal INSERT INTO test (numfield) VALUES (999.99) INSERT INTO test (numfield) VALUES (-999.99) INSERT INTO test (numfield) VALUES (-999.99) INSERT

Re: Field Width

2012-08-07 Thread Fred Taylor
I don't think you get any errors on the insert, but you do lose your values. You'll actually get *'s in the field. Interesting. In the browse, on the non-active row, they show as 9.E+7. VFP stores type N fields as character in the actual file. It's converted back and forth text/numeric as

RE: Field Width

2012-08-07 Thread John Weller
Thanks Fred and Richard. It was as I thought but you've confirmed it. I just could not remember!! John Weller 01380 723235 07976 393631 -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech- boun...@leafe.com] On Behalf Of Richard Kaye Sent: 07 August 2012 21:37

Re: VFP needs to REST

2012-08-07 Thread Ed Leafe
On Aug 7, 2012, at 3:08 PM, John Harvey wrote: I need to see how you send client side certs up to the server for LexisNexis (Accurint) and was hoping someone had some experience with that. I've been looking through Rick Strahl's wwhttp class and I see he has the addpostkey() method, but I

RE: VFP needs to REST

2012-08-07 Thread John Harvey
Yep, I've got a conference call with them tomorrow. John -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Ed Leafe Sent: Tuesday, August 07, 2012 4:15 PM To: ProFox Email List Subject: Re: VFP needs to REST On Aug 7, 2012, at 3:08 PM, John

Re: VFP needs to REST

2012-08-07 Thread Ed Leafe
On Aug 7, 2012, at 4:48 PM, John Harvey wrote: Yep, I've got a conference call with them tomorrow. Generally, API calls should be documented somewhere. Do they keep the docs a secret? ;-) -- Ed Leafe ___ Post Messages to:

Re: corrupted table and database issues

2012-08-07 Thread GĂ©rard Lochon
Fix it with CM Repair http://www.cmstory.com/index.php?module=Pagestype=userfunc=displaypageid=5lang=en ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: