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:
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) --
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
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')
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
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
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
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
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;
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
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
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
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
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
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.
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
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.
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
18 matches
Mail list logo