Re: VFP needs to REST
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: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1344332976.32239.14066701674.4b4b9...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP needs to REST
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. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/02da01cd7493$21b7f190$6527d4b0$@shelbynet.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
web services
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 other idea is firewall. Al ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/003a01cd7497$a2676060$e7362120$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: web services
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, it's also failing on a 2008 server. Only other idea is firewall. Al How is it failing? No connection, or an error creating an object? -- Tracy Sent from my Android phone with K-9 Mail. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/49d26762-21a4-4591-b587-d2eb87639...@email.android.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: web services
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 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 other idea is firewall. Al How is it failing? No connection, or an error creating an object? -- Tracy Sent from my Android phone with K-9 Mail. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/003c01cd749a$f60d3a20$e227ae60$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: web services
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. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/043c5141-107c-4fd0-a218-362c74c8d...@email.android.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: web services
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. -- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/003d01cd749f$a24ed5b0$e6ec8110$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: web services
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 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. -- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/003e01cd74a0$9caf3590$d60da0b0$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: corrupted table and database issues
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 (primary key, default values, field captions, etc.) for that table after adding it back. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James Harvey Sent: Tuesday, August 07, 2012 9:45 AM To: profoxt...@leafe.com Subject: corrupted table and database issues We had a power outage, and apparently this corrupted a table hshealth'. When I try to 'use' the table I get an error: Variable pk_hshealth is not found. This is the name of the primary key field, which is an auto increment field type. If I open the database and validate: Object #55 (Table 'hshealth'): Table is not in a database. I can open and modify the database, and the file appears there? After a number of attempts to rectify this problem I seem to be spinning my tires... 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 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD04420D88E0714@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: corrupted table and database issues
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 will need to re-establish any metadata (primary key, default values, field captions, etc.) for that table after adding it back. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James Harvey Sent: Tuesday, August 07, 2012 9:45 AM To: profoxt...@leafe.com Subject: corrupted table and database issues We had a power outage, and apparently this corrupted a table hshealth'. When I try to 'use' the table I get an error: Variable pk_hshealth is not found. This is the name of the primary key field, which is an auto increment field type. James, It sounds like the table or index is corrupt. Make sure you have a backup as it is now. Delete the associated CDX file and see if the table will open after giving the error that the CDX file is missing. If it does, recreate the indexes. Otherwise, you may need to restore the table from a backup. Tracy Pearson PowerChurch Software ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000301cd74a4$633b1f50$29b15df0$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: corrupted table and database issues
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: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1344348451.20880.14066795258.05d26...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP needs to REST
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 Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1344348519.21089.14066795546.24c2f...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: corrupted table and database issues
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 [mailto:profox-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Tuesday, August 07, 2012 9:56 AM To: profox@leafe.com Subject: RE: corrupted table and database issues 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 will need to re-establish any metadata (primary key, default values, field captions, etc.) for that table after adding it back. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James Harvey Sent: Tuesday, August 07, 2012 9:45 AM To: profoxt...@leafe.com Subject: corrupted table and database issues We had a power outage, and apparently this corrupted a table hshealth'. When I try to 'use' the table I get an error: Variable pk_hshealth is not found. This is the name of the primary key field, which is an auto increment field type. James, It sounds like the table or index is corrupt. Make sure you have a backup as it is now. Delete the associated CDX file and see if the table will open after giving the error that the CDX file is missing. If it does, recreate the indexes. Otherwise, you may need to restore the table from a backup. Tracy Pearson PowerChurch Software [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00a401cd74a8$6f037e00$4d0a7a00$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Update Conflict
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 what to look at? Michael Oke, II 661-349-6221 Contents of this and all messages are intended for their designated recipient. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/2b21377c-f21b-4094-b387-bd14b7e30...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Update Conflict
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 = [othervar] Fred On Tue, Aug 7, 2012 at 10:07 AM, 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 brackets, we get an error: Update Conflict. Anyone have any ideas as to what to look at? Michael Oke, II 661-349-6221 Contents of this and all messages are intended for their designated recipient. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJCBksqXKKUtaE+cyzH2ioqu=fYYyimqo446LqNHTmmKGOz=h...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Update Conflict
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 brackets, we get an error: Update Conflict. Anyone have any ideas as to what to look at? -- [] in MSSQL are containers in that it will contain spaces in a column name tat came from Access. Or it will contain the slash used in an instance [MyServer\theInstance] .dbName.dbo.[Stupid access Table Name] -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmylhthpju0-xlhm_suxpest20djm+vr5uxs1bnrvrfy...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Update Conflict
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 recipient. On Aug 7, 2012, at 10:33 AM, Fred Taylor fbtay...@gmail.com wrote: 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 = [othervar] Fred On Tue, Aug 7, 2012 at 10:07 AM, 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 brackets, we get an error: Update Conflict. Anyone have any ideas as to what to look at? Michael Oke, II 661-349-6221 Contents of this and all messages are intended for their designated recipient. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/93f9cc30-a778-4f3e-9fa0-fcabe1f5e...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP needs to REST
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. John -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, August 07, 2012 9:09 AM To: profox@leafe.com Subject: Re: VFP needs to REST 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 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00b401cd74d8$61f952e0$25ebf8a0$@shelbynet.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Field Width
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 the Help file. Thanks John Weller 01380 723235 07976 393631 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/003801cd74da$4b5756c0$e2060440$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Field Width
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 Subject: Field Width 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 the Help file. Thanks John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD04420D88E0872@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Field Width
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 Weller j...@johnweller.co.uk wrote: 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 the Help file. Thanks John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbkspwb3i9nq6mmlhnqsfa8gfjsrozbg-9bgmmw6vo2ok...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Field Width
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 INTO test (numfield) VALUES (-999.98) INSERT INTO test (numfield) VALUES (-999.9) INSERT INTO test (numfield) VALUES (-999.99) INSERT INTO test (numfield) VALUES (1000) INSERT INTO test (numfield) VALUES (1) INSERT INTO test (numfield) VALUES (10) INSERT INTO test (numfield) VALUES (100) I would have expected an error on the larger numbers. Richard Kaye Vice President, Auction House Systems Artfact/RFC Systems Voice: 617.746.9838 Fax: 617.746.9801 For the fastest response time, please send your support queries to: Technical Support - techsupp...@rfcsystems.com Internet Support - websupp...@rfcsystems.com All Other Requests - requ...@rfcsystems.com - This message has been checked for viruses before sending. - The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, August 07, 2012 4:33 PM To: profoxt...@leafe.com Subject: RE: Field Width 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 Subject: Field Width 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 the Help file. Thanks John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD04420D88E087C@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Field Width
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 needed. At least that's what I remember about it. Fred On Tue, Aug 7, 2012 at 1:37 PM, Richard Kaye rk...@artfact.com wrote: 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 INTO test (numfield) VALUES (-999.98) INSERT INTO test (numfield) VALUES (-999.9) INSERT INTO test (numfield) VALUES (-999.99) INSERT INTO test (numfield) VALUES (1000) INSERT INTO test (numfield) VALUES (1) INSERT INTO test (numfield) VALUES (10) INSERT INTO test (numfield) VALUES (100) I would have expected an error on the larger numbers. Richard Kaye Vice President, Auction House Systems Artfact/RFC Systems Voice: 617.746.9838 Fax: 617.746.9801 For the fastest response time, please send your support queries to: Technical Support - techsupp...@rfcsystems.com Internet Support - websupp...@rfcsystems.com All Other Requests - requ...@rfcsystems.com - This message has been checked for viruses before sending. - The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, August 07, 2012 4:33 PM To: profoxt...@leafe.com Subject: RE: Field Width 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 Subject: Field Width 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 the Help file. Thanks John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbksomu5mpf7-jnrzndv1jf2puko5hnpfpgonjacqt5wo...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Field Width
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 To: profoxt...@leafe.com Subject: RE: Field Width 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 INTO test (numfield) VALUES (-999.98) INSERT INTO test (numfield) VALUES (- 999.9) INSERT INTO test (numfield) VALUES (-999.99) INSERT INTO test (numfield) VALUES (1000) INSERT INTO test (numfield) VALUES (1) INSERT INTO test (numfield) VALUES (10) INSERT INTO test (numfield) VALUES (100) I would have expected an error on the larger numbers. Richard Kaye Vice President, Auction House Systems Artfact/RFC Systems Voice: 617.746.9838 Fax: 617.746.9801 For the fastest response time, please send your support queries to: Technical Support - techsupp...@rfcsystems.com Internet Support - websupp...@rfcsystems.com All Other Requests - requ...@rfcsystems.com - This message has been checked for viruses before sending. - The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech- boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, August 07, 2012 4:33 PM To: profoxt...@leafe.com Subject: RE: Field Width 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 Subject: Field Width 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 the Help file. Thanks John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01cd74df$3b8148f0$b283dad0$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP needs to REST
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 think I need more on what the exact syntax should be. Generally authentication credentials are sent in a header for the request; you'd have to contact the service to get the exact header name they expect. -- Ed Leafe ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/d443623f-0f7d-4037-9f07-e79b175dd...@leafe.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP needs to REST
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 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 think I need more on what the exact syntax should be. Generally authentication credentials are sent in a header for the request; you'd have to contact the service to get the exact header name they expect. -- Ed Leafe [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/010201cd74e6$667e0f50$337a2df0$@shelbynet.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP needs to REST
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: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/8ccad1b2-dccb-49aa-b940-32a3b4690...@leafe.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: corrupted table and database issues
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: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/F9F4E32261F64A8BBB9D5693C7E81EEB@MuriellePC ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.