Re: So, about this VFPA thing...
On Mon, 25 Nov 2019, at 5:39 PM, Koen Piller wrote: > *my motto of the day: *Those who insist that VFPA is a hacked version > of VFP9 have no knowledge of Visual FoxPro. I've been working with FoxPro since 1991, so spare me your motto. This thing alters the binaries, and is therefore a hack in the classic sense of the term. Having said that I'm sure it's all fine and legit, if anyone wants to take a gamble on it. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/f7e18263-69a7-4130-82c5-810b67158...@www.fastmail.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: AW: So, about this VFPA thing...
On 25/11/2019 17:36, Jürgen Wondzinski wrote: > Sometimes it would help to get off that Trump-level paranoia :) > > wOOdy > "Just because you are paranoid doesn't mean Trump isn't out to get you" ;-) Peter This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/2c1dce77-0420-a206-091b-a50a4963b...@whisperingsmith.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: So, about this VFPA thing...
On 11/26/2019 4:26 AM, Alan Bourke wrote: On Mon, 25 Nov 2019, at 5:39 PM, Koen Piller wrote: *my motto of the day: *Those who insist that VFPA is a hacked version of VFP9 have no knowledge of Visual FoxPro. I've been working with FoxPro since 1991, so spare me your motto. This thing alters the binaries, and is therefore a hack in the classic sense of the term. Having said that I'm sure it's all fine and legit, if anyone wants to take a gamble on it. Yeah, Koen...Alan's been here a long time and is well respected. Any alteration as he says is truly a "hack" but the mere words are not meant to convey anything nefarious or illegal (although I restate my surprise at M$ not objecting...but as we said, it's not the ballmer era anymore). ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/2899ef7a-9420-1ca2-280d-e6eb4b1e1...@mbsoftwaresolutions.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: AW: So, about this VFPA thing...
On 11/26/2019 7:20 AM, Peter Cushing wrote: On 25/11/2019 17:36, Jürgen Wondzinski wrote: Sometimes it would help to get off that Trump-level paranoia :) wOOdy "Just because you are paranoid doesn't mean Trump isn't out to get you" ;-) Too many negatives in that sentence...I'm not sure. LOL ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/c175b237-7931-7d28-9c42-6b37fc427...@mbsoftwaresolutions.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: AW: How common is Table Buffering with DBFs??
That said...I do use buffering on those local cursors to allow me to revert to what it was prior to my changes (as per the last query). On 11/25/2019 5:29 PM, MB Software Solutions, LLC wrote: All are saying the same thing...but I know I use the method Charlie Coleman showed me probably 20 years ago using local cursors and having my n-tier framework code handle the updates. I basically get the data into a VFP cursor. For add/edit mode, I scatter the cursor into an object and my edit forms use thisform.oRecord.Whatever for control sources. If user wants to save, edit form sends back signal to calling form which then passes the MyEditForm.oRecord object to the backend for INSERT INTO or SEEK-and-GATHER for update operations. That's a simplified process but that's basically it. But to be fair, I haven't use DBFs in my designs since seeing Bob Lee's n-tier demo at WhilFest in 2002 or 2003. Prior to that, I used local VFP views (table-buffered) for my apps. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/01670f55-a53d-7f26-959f-7214a639d...@mbsoftwaresolutions.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: AW: So, about this VFPA thing...
I address the security concerns in my whitepaper, which I'll share as soon as I can, but hundreds of people use VFPA. I believe if anything nefarious were happening (data pilfering, e.g.) it would have been discovered and the entire project would immediately collapse. Wireshark could easily sniff packets trying to be sent out to unauthorized places. Chen is staking his reputation on his integrity and so far there's no reason to question it. Eric On Tue, Nov 26, 2019 at 9:32 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 11/26/2019 7:20 AM, Peter Cushing wrote: > > On 25/11/2019 17:36, Jürgen Wondzinski wrote: > >> Sometimes it would help to get off that Trump-level paranoia :) > >> > >> wOOdy > >> > > "Just because you are paranoid doesn't mean Trump isn't out to get you" > ;-) > > > Too many negatives in that sentence...I'm not sure. LOL > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAAwxvU=o7mn0czumqepvsswvvp-_i5bh2osek5kb+q012ct...@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: So, about this VFPA thing...
OK alright. My first impression on Alan's remark was a negative, meaning negative in the sense of the product, like this product is a hack, it is no good to use. Now meanwhile I have looked around and found on Wiki an explication of 'hack' :* Hacking is finding applications that are not intended by the creator of the resource, especially with regard to computers. Complexity does not play a role here, on the contrary, easy and fast alternative solutions are preferred. The use of a clothes peg to prevent a trouser leg from coming between a bicycle chain is basically a hack. "Normal" inventions and improvements are therefore not hacks, as long as they are used for what they are made for.* This makes me think Alan is not correct and I conclude VFPA is an improvement. Besides, the history of Alan's use: since 1991, I am proud to tell you I was there before 1990, started with dBaseII jumped from dBaseIV to FoxPro for DOS into now VFP9SP2. Regards, Koen Op di 26 nov. 2019 om 16:32 schreef MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com>: > On 11/26/2019 4:26 AM, Alan Bourke wrote: > > On Mon, 25 Nov 2019, at 5:39 PM, Koen Piller wrote: > >> *my motto of the day: *Those who insist that VFPA is a hacked version > >> of VFP9 have no knowledge of Visual FoxPro. > > I've been working with FoxPro since 1991, so spare me your motto. This > thing alters the binaries, and is therefore a hack in the classic sense of > the term. Having said that I'm sure it's all fine and legit, if anyone > wants to take a gamble on it. > > > > Yeah, Koen...Alan's been here a long time and is well respected. Any > alteration as he says is truly a "hack" but the mere words are not meant > to convey anything nefarious or illegal (although I restate my surprise > at M$ not objecting...but as we said, it's not the ballmer era anymore). > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CACUu1Svve_B3VidMWUvz4qF6g=ybw6jlewven5vve26kdk-...@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: So, about this VFPA thing...
Think i started with foxbase On Tue, Nov 26, 2019 at 5:07 PM Koen Piller wrote: > OK alright. My first impression on Alan's remark was a negative, meaning > negative in the sense of the product, like this product is a hack, it is no > good to use. Now meanwhile I have looked around and found on Wiki an > explication of 'hack' :* Hacking is finding applications that are not > intended by the creator of the resource, especially with regard to > computers. Complexity does not play a role here, on the contrary, easy and > fast alternative solutions are preferred. The use of a clothes peg to > prevent a trouser leg from coming between a bicycle chain is basically a > hack. "Normal" inventions and improvements are therefore not hacks, as long > as they are used for what they are made for.* > This makes me think Alan is not correct and I conclude VFPA is an > improvement. > Besides, the history of Alan's use: since 1991, I am proud to tell you I > was there before 1990, started with dBaseII jumped from dBaseIV to FoxPro > for DOS into now VFP9SP2. > Regards, > Koen > > > > Op di 26 nov. 2019 om 16:32 schreef MB Software Solutions, LLC < > mbsoftwaresoluti...@mbsoftwaresolutions.com>: > > > On 11/26/2019 4:26 AM, Alan Bourke wrote: > > > On Mon, 25 Nov 2019, at 5:39 PM, Koen Piller wrote: > > >> *my motto of the day: *Those who insist that VFPA is a hacked version > > >> of VFP9 have no knowledge of Visual FoxPro. > > > I've been working with FoxPro since 1991, so spare me your motto. This > > thing alters the binaries, and is therefore a hack in the classic sense > of > > the term. Having said that I'm sure it's all fine and legit, if anyone > > wants to take a gamble on it. > > > > > > > Yeah, Koen...Alan's been here a long time and is well respected. Any > > alteration as he says is truly a "hack" but the mere words are not meant > > to convey anything nefarious or illegal (although I restate my surprise > > at M$ not objecting...but as we said, it's not the ballmer era anymore). > > > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/capqlobyztb1vukaqzs9odk04+r0kw8e6vfbfvzw4dqhvayk...@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: So, about this VFPA thing...
Technically, what VPA is doing is actually not intended by its owner, MS. So I think the term hack does apply. If it were an open source tool, then I would say it would not be a hack. Like others have said, the work 'hack' draws out negative connotations (for us developers). But consider other terms we hear like "Life hacks" that offer creative ways of using products for unexpected things. But hack or not, all the points are valid. Someone modified binaries which we usually do not look at and which we probably would have a very hard time analyzing (since we do not have the source code of VFP itself). Also, folks have been using it without any reported incident of suspicious behavior. All it would take is one substantiated, repeatable report and that news would spread rapidly. And having worked for the gov, I have to add the usual paranoia regarding foreign entities creating something I would build on - especially if that something deals with "data". But again, here, this is not a foreign government providing something, it is an individual. Could his government storm his house, and take over his work? Sure, it's China - it's gov does that kind of thing - most communist nations do (our gov might do it in the future if we don't pay attention). But again, such things would probably get out quickly. Maybe he should work out a fail-safe, dead-man trigger or something so that we would know if such an event transpired. Anyway, it is definitely interesting enough that I plan on working with it. I would love larger DBF capacities too, but I will not quibble. The guy is doing some amazing stuff. I hope he reaps big rewards from it somehow. -Charlie On Tue, Nov 26, 2019 at 11:07 AM Koen Piller wrote: > OK alright. My first impression on Alan's remark was a negative, meaning > negative in the sense of the product, like this product is a hack, it is no > good to use. Now meanwhile I have looked around and found on Wiki an > explication of 'hack' :* Hacking is finding applications that are not > intended by the creator of the resource, especially with regard to > computers. Complexity does not play a role here, on the contrary, easy and > fast alternative solutions are preferred. The use of a clothes peg to > prevent a trouser leg from coming between a bicycle chain is basically a > hack. "Normal" inventions and improvements are therefore not hacks, as long > as they are used for what they are made for.* > This makes me think Alan is not correct and I conclude VFPA is an > improvement. > Besides, the history of Alan's use: since 1991, I am proud to tell you I > was there before 1990, started with dBaseII jumped from dBaseIV to FoxPro > for DOS into now VFP9SP2. > Regards, > Koen > > > > Op di 26 nov. 2019 om 16:32 schreef MB Software Solutions, LLC < > mbsoftwaresoluti...@mbsoftwaresolutions.com>: > > > On 11/26/2019 4:26 AM, Alan Bourke wrote: > > > On Mon, 25 Nov 2019, at 5:39 PM, Koen Piller wrote: > > >> *my motto of the day: *Those who insist that VFPA is a hacked version > > >> of VFP9 have no knowledge of Visual FoxPro. > > > I've been working with FoxPro since 1991, so spare me your motto. This > > thing alters the binaries, and is therefore a hack in the classic sense > of > > the term. Having said that I'm sure it's all fine and legit, if anyone > > wants to take a gamble on it. > > > > > > > Yeah, Koen...Alan's been here a long time and is well respected. Any > > alteration as he says is truly a "hack" but the mere words are not meant > > to convey anything nefarious or illegal (although I restate my surprise > > at M$ not objecting...but as we said, it's not the ballmer era anymore). > > > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAJGvLx3XO4w6nL=k5qQSBwC4goYS4m5Ht=62nqzirktmd6c...@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.
Using XML String as part of query in SQL Server
Hi, I need to write an SQL Server Stored Procedure or just a simple SELECT Query that accepts an XML string which is basically a list of IDs that I want to use to filter data from a table. Example XML (created using CURSORTOXML): http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="mySchema.xsd"> 1 2 3 4 5 I then need to: SELECT iMemoNumber, AgreementDate, Amount FROM Agreements WHERE iMemoNumber IN (<>) Or maybe SELECT iMemoNumber, AGreementDate, Amount FROM Agreements INNER JOIN << my XML data on the iMemoNumber >> My Google search terms have failed to produce what I am looking for. Anybody have the solution? -- Frank. Frank Cazabon ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/d24f6592-0c0d-3ad5-dffd-6e5fa0f15...@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: So, about this VFPA thing...
On 11/26/2019 12:32 PM, Charlie Coleman wrote: Technically, what VPA is doing is actually not intended by its owner, MS. ...which is why I was surprised M$ did nothing to stop it. Anyway, it is definitely interesting enough that I plan on working with it. I would love larger DBF capacities too, but I will not quibble. The guy is doing some amazing stuff. I hope he reaps big rewards from it somehow. Wait...does it allow the 2GB ceiling per file (DBF, CDX, FPT, etc.) to be lifted? I missed that if so. ??? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/a12f7c05-d070-24e3-7f91-447c35982...@mbsoftwaresolutions.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: So, about this VFPA thing...
Charlie, To respond to your wish for larger DBF capacities. Out at SWFox, the guys from X# explained the limitation isn't in VFP, it's in the header of the DBF. To change the header, means no VFP 9 tools will be able to use the table. (OLEDB and ODBC included) I like the idea, I haven't been given permission to work with VFPA at the office yet. Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Charlie Coleman Sent: Tuesday, November 26, 2019 12:33 PM To: profoxt...@leafe.com Subject: Re: So, about this VFPA thing... Technically, what VPA is doing is actually not intended by its owner, MS. So I think the term hack does apply. If it were an open source tool, then I would say it would not be a hack. Like others have said, the work 'hack' draws out negative connotations (for us developers). But consider other terms we hear like "Life hacks" that offer creative ways of using products for unexpected things. But hack or not, all the points are valid. Someone modified binaries which we usually do not look at and which we probably would have a very hard time analyzing (since we do not have the source code of VFP itself). Also, folks have been using it without any reported incident of suspicious behavior. All it would take is one substantiated, repeatable report and that news would spread rapidly. And having worked for the gov, I have to add the usual paranoia regarding foreign entities creating something I would build on - especially if that something deals with "data". But again, here, this is not a foreign government providing something, it is an individual. Could his government storm his house, and take over his work? Sure, it's China - it's gov does that kind of thing - most communist nations do (our gov might do it in the future if we don't pay attention). But again, such things would probably get out quickly. Maybe he should work out a fail-safe, dead-man trigger or something so that we would know if such an event transpired. Anyway, it is definitely interesting enough that I plan on working with it. I would love larger DBF capacities too, but I will not quibble. The guy is doing some amazing stuff. I hope he reaps big rewards from it somehow. -Charlie On Tue, Nov 26, 2019 at 11:07 AM Koen Piller wrote: > OK alright. My first impression on Alan's remark was a negative, meaning > negative in the sense of the product, like this product is a hack, it is no > good to use. Now meanwhile I have looked around and found on Wiki an > explication of 'hack' :* Hacking is finding applications that are not > intended by the creator of the resource, especially with regard to > computers. Complexity does not play a role here, on the contrary, easy and > fast alternative solutions are preferred. The use of a clothes peg to > prevent a trouser leg from coming between a bicycle chain is basically a > hack. "Normal" inventions and improvements are therefore not hacks, as long > as they are used for what they are made for.* > This makes me think Alan is not correct and I conclude VFPA is an > improvement. > Besides, the history of Alan's use: since 1991, I am proud to tell you I > was there before 1990, started with dBaseII jumped from dBaseIV to FoxPro > for DOS into now VFP9SP2. > Regards, > Koen > > > > Op di 26 nov. 2019 om 16:32 schreef MB Software Solutions, LLC < > mbsoftwaresoluti...@mbsoftwaresolutions.com>: > > > On 11/26/2019 4:26 AM, Alan Bourke wrote: > > > On Mon, 25 Nov 2019, at 5:39 PM, Koen Piller wrote: > > >> *my motto of the day: *Those who insist that VFPA is a hacked version > > >> of VFP9 have no knowledge of Visual FoxPro. > > > I've been working with FoxPro since 1991, so spare me your motto. This > > thing alters the binaries, and is therefore a hack in the classic sense > of > > the term. Having said that I'm sure it's all fine and legit, if anyone > > wants to take a gamble on it. > > > > > > > Yeah, Koen...Alan's been here a long time and is well respected. Any > > alteration as he says is truly a "hack" but the mere words are not meant > > to convey anything nefarious or illegal (although I restate my surprise > > at M$ not objecting...but as we said, it's not the ballmer era anymore). > > > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000301d5a48a$77e89130$67b9b390$@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.
AW: So, about this VFPA thing...
The reason why MS doesn't care about VFPA is simple. For example in Germany we have a law, that the user is allowed to fix bugs by himself, if the vendor is not willing to do so. Similar law seems to exist in USA ("Right to repair act"). If MS would go against it, they would have to fix those bugs, which is contrary to their habits. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/01d401d5a48f$2ea71c80$8bf55580$@wondzinski.de ** 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.
AW: So, about this VFPA thing...
The 2Gb limitation is in the DBF structure. DBFs and CDX could grow into Terabytes without problems. It's just that good old dBase has decided to set the maximum filesize to 2Gb (which was the max harddisk size at that time). You may have heard about "Advantage Database Server", originally from Extended Systems, later on acquired by Sybase, later on acquired by SAP. That ADS server is based on DBFs as internal datastructure. They have two modes: VFP compatible (then you can add a true MultiTier Server on top of your existing DBC/DBF/CDX), and the extended version, which alters the DBF-header (and renames them to ADT) and is then limited at only disksize (or 2 billion records at 65k each = 6.55e+16 tablesize) I once spoke with one of the developers of Extended Systems, why they stil use the DBF file structure. He told me that the VFP tables and indices are stil the fastest ISAM based structure, and together with their own SQL engine based on top of that (they also have their own Rushmore-like optimizer) they are stil faster than traditional better-known Dataservers. Unfortunately, MS prohibits publishing of speedtests in their license, but one should think why SAP has acquired them... For more info: https://www.sap.com/products/advantage-database-server.html wOOdy -Ursprüngliche Nachricht- Von: ProFox Im Auftrag von MB Software Solutions, LLC Gesendet: Dienstag, 26. November 2019 19:31 An: profox@leafe.com Betreff: Re: So, about this VFPA thing... On 11/26/2019 12:32 PM, Charlie Coleman wrote: > Technically, what VPA is doing is actually not intended by its owner, MS. ...which is why I was surprised M$ did nothing to stop it. > > Anyway, it is definitely interesting enough that I plan on working with it. > I would love larger DBF capacities too, but I will not quibble. The > guy is doing some amazing stuff. I hope he reaps big rewards from it somehow. Wait...does it allow the 2GB ceiling per file (DBF, CDX, FPT, etc.) to be lifted? I missed that if so. ??? [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/01d901d5a492$749770c0$5dc65240$@wondzinski.de ** 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: Using XML String as part of query in SQL Server
Not tested but something similar to ... CREATE PROCEDURE [dbo].[spFindByXML] ( @Array xml ) AS SET NOCOUNT ON; -- SELECT iMemoNumber, AgreementDate, Amount FROM Agreements WHERE iMemoNumber IN (SELECT xmlArray.value('@imemonumber ','integer') FROM @Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray)) -- SET NOCOUNT OFF; -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Wednesday, 27 November 2019 5:16 AM To: profoxt...@leafe.com Subject: Using XML String as part of query in SQL Server Hi, I need to write an SQL Server Stored Procedure or just a simple SELECT Query that accepts an XML string which is basically a list of IDs that I want to use to filter data from a table. Example XML (created using CURSORTOXML): http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="mySchema.xsd"> 1 2 3 4 5 I then need to: SELECT iMemoNumber, AgreementDate, Amount FROM Agreements WHERE iMemoNumber IN (<>) Or maybe SELECT iMemoNumber, AGreementDate, Amount FROM Agreements INNER JOIN << my XML data on the iMemoNumber >> My Google search terms have failed to produce what I am looking for. Anybody have the solution? -- Frank. Frank Cazabon [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/003801d5a493$e5db4d00$b191e700$@ozemail.com.au ** 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: Using XML String as part of query in SQL Server
Thanks Darren, I'm not getting anything returned and don't understand the syntax yet to be sure how to fix your example. I've tried this: declare @array xml = ' http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="mySchema.xsd"> 17153 2 3 4 5 ' /* SELECT iMemoNumber FROM Agreements WHERE iMemoNumber IN ( */ SELECT xmlArray.value('@imemonumber ','integer') FROM @Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray) --) And get nothing returned. If I change it to this (add in VFPData): SELECT xmlArray.value('@imemonumber ','integer') FROM @Array.nodes('/VFPData/c_agreements/imemonumber') AS TEMPTABLE(xmlArray) I get 5 rows back but they are all null. Any ideas what's wrong? On 26 November 2019 15:58:39 GMT-04:00, Darren wrote: >Not tested but something similar to ... > >CREATE PROCEDURE [dbo].[spFindByXML] > ( > @Array xml > ) >AS > >SET NOCOUNT ON; >-- >SELECT iMemoNumber, AgreementDate, Amount >FROM Agreements WHERE iMemoNumber IN (SELECT >xmlArray.value('@imemonumber ','integer') FROM >@Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray)) >-- >SET NOCOUNT OFF; > >-Original Message- >From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >Frank Cazabon >Sent: Wednesday, 27 November 2019 5:16 AM >To: profoxt...@leafe.com >Subject: Using XML String as part of query in SQL Server > >Hi, > >I need to write an SQL Server Stored Procedure or just a simple SELECT >Query that accepts an XML string which is basically a list of IDs that >I >want to use to filter data from a table. > >Example XML (created using CURSORTOXML): > > >http://www.w3.org/2001/XMLSchema-instance"; >xsi:noNamespaceSchemaLocation="mySchema.xsd"> > > 1 > > > 2 > > > 3 > > > 4 > > > 5 > > > >I then need to: > >SELECT iMemoNumber, AgreementDate, Amount > >FROM Agreements > >WHERE iMemoNumber IN (<>) > > >Or maybe > >SELECT iMemoNumber, AGreementDate, Amount > >FROM Agreements > >INNER JOIN << my XML data on the iMemoNumber >> > > >My Google search terms have failed to produce what I am looking for. > >Anybody have the solution? > >-- > >Frank. > >Frank Cazabon > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/cf583317-7ffd-4da9-9f20-da9e4dfcc...@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: Using XML String as part of query in SQL Server
I got it doing it like this: SELECT iMemoNumber, DAGREEMENTDATE FROM Agreements WHERE iMemoNumber IN ( SELECT imemo = x.Rec.query('./imemonumber').value('.','integer') -- xmlArray.value('@imemonumber ','integer') FROM @Array.nodes('/VFPData/c_agreements') AS x(Rec) -- TEMPTABLE(xmlArray) ) Thanks for the help On 26 November 2019 18:32:12 GMT-04:00, Frank Cazabon wrote: >Thanks Darren, > >I'm not getting anything returned and don't understand the syntax yet >to be sure how to fix your example. > >I've tried this: > >declare @array xml = 'standalone="yes"?> >http://www.w3.org/2001/XMLSchema-instance"; >xsi:noNamespaceSchemaLocation="mySchema.xsd"> > > 17153 > > > 2 > > > 3 > > > 4 > > > 5 > >' >/* >SELECT iMemoNumber >FROM Agreements > WHERE iMemoNumber IN ( > */ > SELECT xmlArray.value('@imemonumber ','integer') > FROM @Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray) > --) > >And get nothing returned. > >If I change it to this (add in VFPData): > >SELECT xmlArray.value('@imemonumber ','integer') >FROM @Array.nodes('/VFPData/c_agreements/imemonumber') AS >TEMPTABLE(xmlArray) > >I get 5 rows back but they are all null. > >Any ideas what's wrong? > >On 26 November 2019 15:58:39 GMT-04:00, Darren >wrote: >>Not tested but something similar to ... >> >>CREATE PROCEDURE [dbo].[spFindByXML] >> ( >> @Array xml >> ) >>AS >> >>SET NOCOUNT ON; >>-- >>SELECT iMemoNumber, AgreementDate, Amount >>FROM Agreements WHERE iMemoNumber IN (SELECT >>xmlArray.value('@imemonumber ','integer') FROM >>@Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray)) >>-- >>SET NOCOUNT OFF; >> >>-Original Message- >>From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >>Frank Cazabon >>Sent: Wednesday, 27 November 2019 5:16 AM >>To: profoxt...@leafe.com >>Subject: Using XML String as part of query in SQL Server >> >>Hi, >> >>I need to write an SQL Server Stored Procedure or just a simple SELECT > >>Query that accepts an XML string which is basically a list of IDs that >>I >>want to use to filter data from a table. >> >>Example XML (created using CURSORTOXML): >> >> >>http://www.w3.org/2001/XMLSchema-instance"; >>xsi:noNamespaceSchemaLocation="mySchema.xsd"> >> >> 1 >> >> >> 2 >> >> >> 3 >> >> >> 4 >> >> >> 5 >> >> >> >>I then need to: >> >>SELECT iMemoNumber, AgreementDate, Amount >> >>FROM Agreements >> >>WHERE iMemoNumber IN (<>) >> >> >>Or maybe >> >>SELECT iMemoNumber, AGreementDate, Amount >> >>FROM Agreements >> >>INNER JOIN << my XML data on the iMemoNumber >> >> >> >>My Google search terms have failed to produce what I am looking for. >> >>Anybody have the solution? >> >>-- >> >>Frank. >> >>Frank Cazabon >> >> [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/2e77d933-4456-4c5c-8095-148ddb165...@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: Using XML String as part of query in SQL Server
Thanks Frank - sorry I just now saw your first reply. Was out. Good to see you got it working. Cheers -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Wednesday, 27 November 2019 10:16 AM To: profoxt...@leafe.com Subject: RE: Using XML String as part of query in SQL Server I got it doing it like this: SELECT iMemoNumber, DAGREEMENTDATE FROM Agreements WHERE iMemoNumber IN ( SELECT imemo = x.Rec.query('./imemonumber').value('.','integer') -- xmlArray.value('@imemonumber ','integer') FROM @Array.nodes('/VFPData/c_agreements') AS x(Rec) -- TEMPTABLE(xmlArray) ) Thanks for the help On 26 November 2019 18:32:12 GMT-04:00, Frank Cazabon wrote: >Thanks Darren, > >I'm not getting anything returned and don't understand the syntax yet >to be sure how to fix your example. > >I've tried this: > >declare @array xml = 'standalone="yes"?> >http://www.w3.org/2001/XMLSchema-instance"; >xsi:noNamespaceSchemaLocation="mySchema.xsd"> > > 17153 > > > 2 > > > 3 > > > 4 > > > 5 > >' >/* >SELECT iMemoNumber >FROM Agreements > WHERE iMemoNumber IN ( > */ > SELECT xmlArray.value('@imemonumber ','integer') > FROM @Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray) > --) > >And get nothing returned. > >If I change it to this (add in VFPData): > >SELECT xmlArray.value('@imemonumber ','integer') >FROM @Array.nodes('/VFPData/c_agreements/imemonumber') AS >TEMPTABLE(xmlArray) > >I get 5 rows back but they are all null. > >Any ideas what's wrong? > >On 26 November 2019 15:58:39 GMT-04:00, Darren >wrote: >>Not tested but something similar to ... >> >>CREATE PROCEDURE [dbo].[spFindByXML] >> ( >> @Array xml >> ) >>AS >> >>SET NOCOUNT ON; >>-- >>SELECT iMemoNumber, AgreementDate, Amount >>FROM Agreements WHERE iMemoNumber IN (SELECT >>xmlArray.value('@imemonumber ','integer') FROM >>@Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray)) >>-- >>SET NOCOUNT OFF; >> >>-Original Message- >>From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of >>Frank Cazabon >>Sent: Wednesday, 27 November 2019 5:16 AM >>To: profoxt...@leafe.com >>Subject: Using XML String as part of query in SQL Server >> >>Hi, >> >>I need to write an SQL Server Stored Procedure or just a simple SELECT > >>Query that accepts an XML string which is basically a list of IDs that >>I >>want to use to filter data from a table. >> >>Example XML (created using CURSORTOXML): >> >> >>http://www.w3.org/2001/XMLSchema-instance"; >>xsi:noNamespaceSchemaLocation="mySchema.xsd"> >> >> 1 >> >> >> 2 >> >> >> 3 >> >> >> 4 >> >> >> 5 >> >> >> >>I then need to: >> >>SELECT iMemoNumber, AgreementDate, Amount >> >>FROM Agreements >> >>WHERE iMemoNumber IN (<>) >> >> >>Or maybe >> >>SELECT iMemoNumber, AGreementDate, Amount >> >>FROM Agreements >> >>INNER JOIN << my XML data on the iMemoNumber >> >> >> >>My Google search terms have failed to produce what I am looking for. >> >>Anybody have the solution? >> >>-- >> >>Frank. >> >>Frank Cazabon >> >> [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/001201d5a4ba$756ce200$6046a600$@ozemail.com.au ** 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.