Re: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Paul Hill

On 7/30/06, Michael Madigan [EMAIL PROTECTED] wrote:

Goofed my ass, they were shooting rockets from that
building.


Were the UN inspectors firing rockets too?

--
Paul


___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Michael Madigan
Here's the explanation.

http://www.canada.com/ottawacitizen/news/story.html?id=37278180-a261-421d-84a9-7f94d5fc6d50

--- Paul Hill [EMAIL PROTECTED] wrote:

 On 7/30/06, Michael Madigan [EMAIL PROTECTED]
 wrote:
  Goofed my ass, they were shooting rockets from
 that
  building.
 
 Were the UN inspectors firing rockets too?
 
 -- 
 Paul
 
 
 ___
 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
 ** 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.
 


Hezbollah Human Shields  http://www.cafepress.com/rightwingmike/1688255
Right Wing Stuff at http://www.cafepress.com/rightwingmike
Horse Racing Photos at http://www.HorseRacingPix.com


___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Paul Hill

Irrelevant.  I suppose the 37 children Israelis killed yesterday in
Qana was OK too?  After all, they're only Muslims right?

On 7/31/06, Michael Madigan [EMAIL PROTECTED] wrote:

Here's the explanation.

http://www.canada.com/ottawacitizen/news/story.html?id=37278180-a261-421d-84a9-7f94d5fc6d50

--- Paul Hill [EMAIL PROTECTED] wrote:

 On 7/30/06, Michael Madigan [EMAIL PROTECTED]
 wrote:
  Goofed my ass, they were shooting rockets from
 that
  building.

 Were the UN inspectors firing rockets too?



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Dominic Burford
Quotes from myself to Michael on another, related thread:


The US will never openly condemn Israel.  It is no coincidence that your
news coverage always seems to paint Israel's enemies as the bad guys
(Palestine, Lebanon, getting the picture yet?)


And...


Israel fire at who they like, and act with impunity, because they know
that their bigger brother - the US - will always defend them.   

 
It seems many people have been brainwashed by their media and
politicians.  The simple minded folk on this list who defend Israel do
so using the antiquated straw man analogy that we must all be extreme
liberals who would love to hug a terrorist.  That would be funny if it
were not so pathetic.  Hiding behind such a straw man is an excuse so
that they do not have to come out and debate the real issues.  They
cower and hide hehind their whimsical caricatures instead, and their
infantile little tag lines such as 'Liberalism is a mental disorder'
(yawn).

Cowardice of the worst kind.

Regads

Dominic Burford BSc Hons MBCS CITP
Third Party Developer Program Senior Software Engineer 

* Tel: +44 (0) 1536 495074
* [EMAIL PROTECTED] 

I conclude that there are two ways of constructing a software design:
One way is to make it so simple there are obviously no deficiencies, and
the other way is to make it so complicated that there are no obvious
deficiencies. -- Tony Hoare, Turing Award Lecture 1980


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul Hill
Sent: 31 July 2006 09:08
To: ProFox Email List
Subject: Re: [OT] The savages are breaking into the UN offices in Beirut

Irrelevant.  I suppose the 37 children Israelis killed yesterday in Qana
was OK too?  After all, they're only Muslims right?

On 7/31/06, Michael Madigan [EMAIL PROTECTED] wrote:
 Here's the explanation.

 http://www.canada.com/ottawacitizen/news/story.html?id=37278180-a261-4
 21d-84a9-7f94d5fc6d50

 --- Paul Hill [EMAIL PROTECTED] wrote:

  On 7/30/06, Michael Madigan [EMAIL PROTECTED]
  wrote:
   Goofed my ass, they were shooting rockets from
  that
   building.
 
  Were the UN inspectors firing rockets too?


___
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
** 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.

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__

__
Pegasus Software Limited is a member of the Systems Union Group plc

Registered Office:  Systems Union House, 1 Lakeside Road, Aerospace Centre, 
Farnborough, Hampshire GU14 6XP  Registered No: 1601542

This e-mail is from Pegasus Software Limited. The e-mail and any files 
transmitted with it are confidential and intended solely for the use of the 
individual or entity to whom it is addressed. If you have received this e-mail 
in error you must not copy, distribute or take any action in reliance on it. 
Please notify the sender by e-mail or telephone.

Pegasus Software Limited utilises an anti-virus system and therefore any files 
sent via e-mail will have been checked for known viruses. You are however 
advised to run your own virus check before opening any attachments received as 
Pegasus Software Limited will not in any event accept any liability whatsoever 
once an e-mail and/or any attachment is received.

This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__


___
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
** 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: [NF] Views in SQL Server

2006-07-31 Thread Andy Davies
M$ never adopted [packages], I can't understand why (unless it's a
copyright issue or something)??

--Michael

not copyright - iirc packages are part of the ansi standard - ms said there
was 'no demand'.

Andrew Davies  MBCS CITP
  - AndyD    8-)#


**

This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by 
MIMEsweeper for the presence of computer viruses.

Please contact [EMAIL PROTECTED] with any queries.

**



___
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
** 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.


Wierd SQL Error - Any Ideas?

2006-07-31 Thread Dave Crozier
To All,
I had a WEIRD error come up over the weekend in a set of programs that have
been working for ages. I managed to tie the problem down to what I think is
an error in VFP and wonder what you all think.

Run the program below and you should find that the first and second select
statement works OK and the third one doesn't!
My question is WHY? 
I can't come up with a reasonable answer here other than the fact that in
(3) VFP seems to be trying to pre process or parse the Date() expression
with a dataset containing null records (maybe?) caused by the Join.

As the only difference is the Join in statement (3), this is obviously the
culprit but WHY?

Important Note:
If you replace the date() statement with   
Ctod(Substr(curTemp.cDate,1,8)) ;
as Date ;

Then ALL the statements work.

Surely this is a deep error with the Date() - or am I missing something
obvious here. All I know is that it ate up 4 hours to find the problem!

***
* Start of Program
*
Close Tables all

Set Date British DD/MM/YY
Create Cursor curTemp (FK1 I, F1 C(10), cDate C(8))

Insert Into curTemp Values (1, A01,01/01/06)
Insert Into curTemp Values (1, A02,02/01/06)
Insert Into curTemp Values (2, A03,03/01/06)
Insert Into curTemp Values (2, A04,04/01/06)
Insert Into curTemp Values (1, A05,05/01/06)

Create Cursor curTemp2 (PK I, F1 C(10))
Insert Into curTemp2 Values (1, Lookup)

* (1) This statement works OK it has one record
Select All ;
  Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
   Val(Substr(curTemp.cDate,4,2)), ;
   Val(Substr(curTemp.cDate,1,2))) ;
as Date ;
   From curTemp ;
   Where curTemp.F1=A01 ;
   Into Cursor curResult
*
Browse

* (2) This is OK, no records
Select All ;
   Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
Val(Substr(curTemp.cDate,4,2)),;
Val(Substr(curTemp.cDate,1,2))) ;
 as Date ;
   From curTemp ;
   Where curTemp.F1=A99 ;
   Into Cursor curResult
*
Browse

* (3) This errors. Also No records
Select All ;
   Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
Val(Substr(curTemp.cDate,4,2)), ;
Val(Substr(curTemp.cDate,1,2))) ;
 as Date ;
   From curTemp ;
   Join curTemp2 on curTemp2.PK=curTemp.FK1 ;
   Where curTemp.F1=A01 ;
   Into Cursor curResult
*
Browse
*
* End of Program

 
Dave Crozier
The best way to make a Million pounds in computing.
...Start with 5 million!

 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date: 28/07/2006
 




___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread petetheisen

Dominic Burford wrote:

Hi Dominic!

I don't know how much more real the issue can be than that of hugging 
terrorists, hating America and hating Israel can be. Real issues indeed. 
If treason is not an issue, then there are no issues.


The argument of real issues other than these is the straw man.

Regards,

Pete

Quotes from myself to Michael on another, related thread:

The US will never openly condemn Israel.  It is no coincidence that your
news coverage always seems to paint Israel's enemies as the bad guys
(Palestine, Lebanon, getting the picture yet?)


Israel fire at who they like, and act with impunity, because they know
that their bigger brother - the US - will always defend them.   


It seems many people have been brainwashed by their media and
politicians.  The simple minded folk on this list who defend Israel do
so using the antiquated straw man analogy that we must all be extreme
liberals who would love to hug a terrorist.



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Dominic Burford
 hugging terrorists, hating America and hating Israel

These are complex issues which have been simplified into infantile tags.
It is easier to churn out these (and hundreds more like them) that to
discuss the real issues.  The irony is, you have done exactly what I
have described you would do.  You have hidden behind your caricatures,
because you are incapable of discussing the real issues.

Go ahead and throw your caricatures and tag lines around

___
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
** 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: Wierd SQL Error - Any Ideas?

2006-07-31 Thread Alan Bourke
What version of VFP Dave?
-- 
  Alan Bourke
  [EMAIL PROTECTED]

-- 
http://www.fastmail.fm - IMAP accessible web-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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Stephen the Cook
petetheisen  wrote:
 Stephen the Cook wrote:
 Michael Madigan  wrote:
 
 Lie down with terrorists, wake up dead.
 
 
 
 Live 2 blocks away and find your building was blown up because the
 Israelis goofed.  To bad your wife and kids were there.  Sucks for
 them.
 
 Hi Stephen!
 
 The Israelis told the civilians to clear out before they started
 shooting. The ones shot evidently chose to tempt fate. 

Would you really listen to the enemy?  Come on Pete.  You would have had
your gun drawn and a few boxes of ammo handy.



Stephen Russell
DBA / Operations Developer

Memphis TN 38115
901.246-0159

http://spaces.msn.com/members/srussell/

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date: 7/28/2006
 



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Stephen the Cook
petetheisen  wrote:
 Stephen the Cook wrote:
 Michael Madigan  wrote:
 
 Lie down with terrorists, wake up dead.
 
 
 
 Live 2 blocks away and find your building was blown up because the
 Israelis goofed.  To bad your wife and kids were there.  Sucks for
 them.
 
 Hi Stephen!
 
 The Israelis told the civilians to clear out before they started
 shooting. The ones shot evidently chose to tempt fate. 

Would you really listen to the enemy?  Come on Pete.  You would have had
your gun drawn and a few boxes of ammo handy.



Stephen Russell
DBA / Operations Developer

Memphis TN 38115
901.246-0159

http://spaces.msn.com/members/srussell/

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date: 7/28/2006
 



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Stephen the Cook
Michael Madigan  wrote:
 Too bad the 911 victims didn't get any flyers to clear out.

My brother in law's company was on the 3? Floor of the second tower hit.
When the first building was struck the management told the staff to leave.
I'd say that would not be the norm for most of the other businesses.

Mark runs the Denver office and flies between NY and CO every other week.
Lucky for him that it was his off week.  Oppenheimer Funds, Inc. is his
employer.

Stephen Russell
DBA / Operations Developer

Memphis TN 38115
901.246-0159

http://spaces.msn.com/members/srussell/

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date: 7/28/2006
 



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread petetheisen

Stephen the Cook wrote:

petetheisen  wrote:


Stephen the Cook wrote:


Michael Madigan  wrote:


Lie down with terrorists, wake up dead.


Live 2 blocks away and find your building was blown up because the
Israelis goofed.  To bad your wife and kids were there.  Sucks for
them.


Hi Stephen!

The Israelis told the civilians to clear out before they started
shooting. The ones shot evidently chose to tempt fate. 



Would you really listen to the enemy?  Come on Pete.  You would have had
your gun drawn and a few boxes of ammo handy.


Hi Stephen!

I would have sent my wife and for God's sake my children to safety 
should I have chosen to resist.


Regards,

Pete


___
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
** 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: Wierd SQL Error - Any Ideas?

2006-07-31 Thread Dave Crozier
VFP 9 SP1 


Dave Crozier
 The secret to staying young is to live honestly, eat slowly, and to lie
about your age 

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Crozier
Sent: 31 July 2006 11:04
To: 'ProFox Email List'
Subject: Wierd SQL Error - Any Ideas?

To All,
I had a WEIRD error come up over the weekend in a set of programs that have
been working for ages. I managed to tie the problem down to what I think is
an error in VFP and wonder what you all think.

Run the program below and you should find that the first and second select
statement works OK and the third one doesn't!
My question is WHY? 
I can't come up with a reasonable answer here other than the fact that in
(3) VFP seems to be trying to pre process or parse the Date() expression
with a dataset containing null records (maybe?) caused by the Join.

As the only difference is the Join in statement (3), this is obviously the
culprit but WHY?

Important Note:
If you replace the date() statement with   
Ctod(Substr(curTemp.cDate,1,8)) ;
as Date ;

Then ALL the statements work.

Surely this is a deep error with the Date() - or am I missing something
obvious here. All I know is that it ate up 4 hours to find the problem!

***
* Start of Program
*
Close Tables all

Set Date British DD/MM/YY
Create Cursor curTemp (FK1 I, F1 C(10), cDate C(8))

Insert Into curTemp Values (1, A01,01/01/06) Insert Into curTemp Values
(1, A02,02/01/06) Insert Into curTemp Values (2, A03,03/01/06)
Insert Into curTemp Values (2, A04,04/01/06) Insert Into curTemp Values
(1, A05,05/01/06)

Create Cursor curTemp2 (PK I, F1 C(10))
Insert Into curTemp2 Values (1, Lookup)

* (1) This statement works OK it has one record Select All ;
  Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
   Val(Substr(curTemp.cDate,4,2)), ;
   Val(Substr(curTemp.cDate,1,2))) ;
as Date ;
   From curTemp ;
   Where curTemp.F1=A01 ;
   Into Cursor curResult
*
Browse

* (2) This is OK, no records
Select All ;
   Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
Val(Substr(curTemp.cDate,4,2)),;
Val(Substr(curTemp.cDate,1,2))) ;
 as Date ;
   From curTemp ;
   Where curTemp.F1=A99 ;
   Into Cursor curResult
*
Browse

* (3) This errors. Also No records
Select All ;
   Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
Val(Substr(curTemp.cDate,4,2)), ;
Val(Substr(curTemp.cDate,1,2))) ;
 as Date ;
   From curTemp ;
   Join curTemp2 on curTemp2.PK=curTemp.FK1 ;
   Where curTemp.F1=A01 ;
   Into Cursor curResult
*
Browse
*
* End of Program

 
Dave Crozier
The best way to make a Million pounds in computing.
...Start with 5 million!

 

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date: 28/07/2006
 




[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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread petetheisen

Dominic Burford wrote:

 hugging terrorists, hating America and hating Israel

These are complex issues


Hi Dominic!

The issues in fact are *very* simple. It is the straw man argument to 
paint them as having nuances or whatever.


The Ts are firing rockets into Israel. It just doesn't get much simpler 
than that. OK, 911 is simpler.


In response, Israel, the US and any other right thinking nation 
eliminates the terrorists. If eliminating the terrorists means killing 
every male muslim who does not surrender with his hands up, then that is 
what has to happen. Complex indeed.


Regards,

Pete


___
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
** 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: Wierd SQL Error - Any Ideas?

2006-07-31 Thread Sietse Wijnker
Hmm. strange indeed.

What I'm seeing: The 1st call to the date function, the curTemp.cDate
contains an empty value! I'm not sure but I'm bettiong it has to do with
optimization of the query.
I've seen this result by using an UDF that accepts 1 param and prints it out
to the screen.
Then include that UDF as a column, passing the curTemp.cDate as the param

The solution:
use EVL() in the expression:
Date(2000+Val(Substr(EVL(curTemp.cDate, 01/01/00),7,2)), ;
  Val(Substr(EVL(curTemp.cDate, 01/01/00),4,2)), ;
  Val(Substr(EVL(curTemp.cDate, 01/01/00),1,2))) ;

Another solution:
You're only using the join to filter out the records from the lookup:

Don't use the join but use
Where curTemp.F1=A01 AND curTemp.FK1 IN (SELECT pk FROM curTemp2)

Regards,
Sietse Wijnker


 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of Dave Crozier
 Sent: maandag 31 juli 2006 12:04
 To: [EMAIL PROTECTED]
 Subject: Wierd SQL Error - Any Ideas?
 
 To All,
 I had a WEIRD error come up over the weekend in a set of 
 programs that have been working for ages. I managed to tie 
 the problem down to what I think is an error in VFP and 
 wonder what you all think.
 
 Run the program below and you should find that the first and 
 second select statement works OK and the third one doesn't!
 My question is WHY? 
 I can't come up with a reasonable answer here other than the 
 fact that in
 (3) VFP seems to be trying to pre process or parse the 
 Date() expression with a dataset containing null records 
 (maybe?) caused by the Join.
 
 As the only difference is the Join in statement (3), this is 
 obviously the culprit but WHY?
 
 Important Note:
 If you replace the date() statement with   
 Ctod(Substr(curTemp.cDate,1,8)) ;
 as Date ;
 
 Then ALL the statements work.
 
 Surely this is a deep error with the Date() - or am I missing 
 something obvious here. All I know is that it ate up 4 hours 
 to find the problem!
 
 ***
 * Start of Program
 *
 Close Tables all
 
 Set Date British   DD/MM/YY
 Create Cursor curTemp (FK1 I, F1 C(10), cDate C(8))
 
 Insert Into curTemp Values (1, A01,01/01/06) Insert Into 
 curTemp Values (1, A02,02/01/06) Insert Into curTemp 
 Values (2, A03,03/01/06) Insert Into curTemp Values (2, 
 A04,04/01/06) Insert Into curTemp Values (1, A05,05/01/06)
 
 Create Cursor curTemp2 (PK I, F1 C(10))
 Insert Into curTemp2 Values (1, Lookup)
 
 * (1) This statement works OK it has one record Select All ;
   Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
Val(Substr(curTemp.cDate,4,2)), ;
Val(Substr(curTemp.cDate,1,2))) ;
 as Date ;
From curTemp ;
Where curTemp.F1=A01 ;
Into Cursor curResult
 *
 Browse
 
 * (2) This is OK, no records
 Select All ;
Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
 Val(Substr(curTemp.cDate,4,2)),;
 Val(Substr(curTemp.cDate,1,2))) ;
  as Date ;
From curTemp ;
Where curTemp.F1=A99 ;
Into Cursor curResult
 *
 Browse
 
 * (3) This errors. Also No records
 Select All ;
Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
 Val(Substr(curTemp.cDate,4,2)), ;
 Val(Substr(curTemp.cDate,1,2))) ;
  as Date ;
From curTemp ;
Join curTemp2 on curTemp2.PK=curTemp.FK1 ;
Where curTemp.F1=A01 ;
Into Cursor curResult
 *
 Browse
 *
 * End of Program
 
  
 Dave Crozier
 The best way to make a Million pounds in computing.
 ...Start with 5 million!
 
  
 
 --
 No virus found in this outgoing message.
 Checked by AVG Free Edition.
 Version: 7.1.394 / Virus Database: 268.10.5/403 - Release 
 Date: 28/07/2006
  
 
 
 
 
[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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Dominic Burford
 The Ts are firing rockets into Israel. It just doesn't get much
simpler than that.

And Israel has responded with an over the top display of military power
that has just recently seen 37 children killed.  They have also bombed
the exit roads so that civilians cannot escape, they have bombed urban
areas where civialians live, including hospitals.

The straw man is to paint this as a simple issue, and call people who
disagree with you as terrorist loving liberals.  

Go and hide behind your straw man.

Regards

Dominic Burford BSc Hons MBCS CITP
Third Party Developer Program Senior Software Engineer 

* Tel: +44 (0) 1536 495074
* [EMAIL PROTECTED] 

I conclude that there are two ways of constructing a software design:
One way is to make it so simple there are obviously no deficiencies, and
the other way is to make it so complicated that there are no obvious
deficiencies. -- Tony Hoare, Turing Award Lecture 1980


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of petetheisen
Sent: 31 July 2006 12:03
To: ProFox Email List
Subject: Re: [OT] The savages are breaking into the UN offices in Beirut

Dominic Burford wrote:
  hugging terrorists, hating America and hating Israel
 
 These are complex issues

Hi Dominic!

The issues in fact are *very* simple. It is the straw man argument to
paint them as having nuances or whatever.

The Ts are firing rockets into Israel. It just doesn't get much simpler
than that. OK, 911 is simpler.

In response, Israel, the US and any other right thinking nation
eliminates the terrorists. If eliminating the terrorists means killing
every male muslim who does not surrender with his hands up, then that is
what has to happen. Complex indeed.

Regards,

Pete


___
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
** 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.

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__

__
Pegasus Software Limited is a member of the Systems Union Group plc

Registered Office:  Systems Union House, 1 Lakeside Road, Aerospace Centre, 
Farnborough, Hampshire GU14 6XP  Registered No: 1601542

This e-mail is from Pegasus Software Limited. The e-mail and any files 
transmitted with it are confidential and intended solely for the use of the 
individual or entity to whom it is addressed. If you have received this e-mail 
in error you must not copy, distribute or take any action in reliance on it. 
Please notify the sender by e-mail or telephone.

Pegasus Software Limited utilises an anti-virus system and therefore any files 
sent via e-mail will have been checked for known viruses. You are however 
advised to run your own virus check before opening any attachments received as 
Pegasus Software Limited will not in any event accept any liability whatsoever 
once an e-mail and/or any attachment is received.

This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__


___
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
** 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: Wierd SQL Error - Any Ideas?

2006-07-31 Thread Dave Crozier
Sietse,
Seitse,
Thanks for the heads up. 

On Saturday I did try removing the Join just as you suggested, as this was
my first gut reaction but the query ran so slow (x 20) that I reverted to
the ctod() solution just to get the damned thing working at a sensible
speed.

As for the Evl() solution, that is a good one - well found! I might revisit
the code and use that method.

Yes, I've seen a similar problem when using UDF's but this particular one
definitely goes in the book of things to look for. The weird thing was
that I was looking at the data as the culprit, thinking that I had some
corrupted records in the table(s) as the actual live SQL syntax contains
about 15 joins and is vastly more complicated than in the example. That's
why it took me so long to find out what was happening. 

I'll report it as a bug though as the statement shouldn't error.

Dave Crozier
 The secret to staying young is to live honestly, eat slowly, and to lie
about your age 

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Sietse Wijnker
Sent: 31 July 2006 12:13
To: profox@leafe.com
Subject: RE: Wierd SQL Error - Any Ideas?

Hmm. strange indeed.

What I'm seeing: The 1st call to the date function, the curTemp.cDate
contains an empty value! I'm not sure but I'm bettiong it has to do with
optimization of the query.
I've seen this result by using an UDF that accepts 1 param and prints it out
to the screen.
Then include that UDF as a column, passing the curTemp.cDate as the param

The solution:
use EVL() in the expression:
Date(2000+Val(Substr(EVL(curTemp.cDate, 01/01/00),7,2)), ;
  Val(Substr(EVL(curTemp.cDate, 01/01/00),4,2)), ;
  Val(Substr(EVL(curTemp.cDate, 01/01/00),1,2))) ;

Another solution:
You're only using the join to filter out the records from the lookup:

Don't use the join but use
Where curTemp.F1=A01 AND curTemp.FK1 IN (SELECT pk FROM curTemp2)

Regards,
Sietse Wijnker


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Dave Crozier
 Sent: maandag 31 juli 2006 12:04
 To: [EMAIL PROTECTED]
 Subject: Wierd SQL Error - Any Ideas?
 
 To All,
 I had a WEIRD error come up over the weekend in a set of programs that 
 have been working for ages. I managed to tie the problem down to what 
 I think is an error in VFP and wonder what you all think.
 
 Run the program below and you should find that the first and second 
 select statement works OK and the third one doesn't!
 My question is WHY? 
 I can't come up with a reasonable answer here other than the fact that 
 in
 (3) VFP seems to be trying to pre process or parse the
 Date() expression with a dataset containing null records
 (maybe?) caused by the Join.
 
 As the only difference is the Join in statement (3), this is obviously 
 the culprit but WHY?
 
 Important Note:
 If you replace the date() statement with   
 Ctod(Substr(curTemp.cDate,1,8)) ;
 as Date ;
 
 Then ALL the statements work.
 
 Surely this is a deep error with the Date() - or am I missing 
 something obvious here. All I know is that it ate up 4 hours to find 
 the problem!
 
 ***
 * Start of Program
 *
 Close Tables all
 
 Set Date British   DD/MM/YY
 Create Cursor curTemp (FK1 I, F1 C(10), cDate C(8))
 
 Insert Into curTemp Values (1, A01,01/01/06) Insert Into curTemp 
 Values (1, A02,02/01/06) Insert Into curTemp Values (2, 
 A03,03/01/06) Insert Into curTemp Values (2,
 A04,04/01/06) Insert Into curTemp Values (1, A05,05/01/06)
 
 Create Cursor curTemp2 (PK I, F1 C(10)) Insert Into curTemp2 Values 
 (1, Lookup)
 
 * (1) This statement works OK it has one record Select All ;
   Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
Val(Substr(curTemp.cDate,4,2)), ;
Val(Substr(curTemp.cDate,1,2))) ;
 as Date ;
From curTemp ;
Where curTemp.F1=A01 ;
Into Cursor curResult
 *
 Browse
 
 * (2) This is OK, no records
 Select All ;
Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
 Val(Substr(curTemp.cDate,4,2)),;
 Val(Substr(curTemp.cDate,1,2))) ;
  as Date ;
From curTemp ;
Where curTemp.F1=A99 ;
Into Cursor curResult
 *
 Browse
 
 * (3) This errors. Also No records
 Select All ;
Date(2000+Val(Substr(curTemp.cDate,7,2)), ;
 Val(Substr(curTemp.cDate,4,2)), ;
 Val(Substr(curTemp.cDate,1,2))) ;
  as Date ;
From curTemp ;
Join curTemp2 on curTemp2.PK=curTemp.FK1 ;
Where curTemp.F1=A01 ;
Into Cursor curResult
 *
 Browse
 *
 * End of Program
 
  
 Dave Crozier
 The best way to make a Million pounds in computing.
 ...Start with 5 million!
 
  
 
 --
 No virus found in this outgoing message.
 Checked by AVG Free Edition.
 Version: 7.1.394 / Virus Database: 268.10.5/403 - Release
 Date: 28/07/2006
  
 
 
 
 
[excessive quoting removed by server]

___
Post Messages to: 

Re: Views in SQL Server

2006-07-31 Thread Andy Davies
Mike Yearwood said If you always use parameterized SQL queries, the
parameter contents can not be used for SIA.

Surely it depends how you build the parameter variables - if you let the
user enter them what is to stop them entering e.g. a city name as
manchester go truncate table dbo.sysusers go

and If someone were somehow able to access your database at all and run a
query, they can just as easily run your SPs.

I thought that was the point - you make the error checking in your sp rock
solid so you don't care what tool is used to access it.

btw some comments on this topic seem to imply that SQL Server supports
parameterised queries: afaik Foxpro supports parameterised queries,
including queries to a SQL Server back-end, but SQL Server itself only
supports parameters to sp's - or have I missed something?

Andrew Davies  MBCS CITP
  - AndyD    8-)#


**

This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by 
MIMEsweeper for the presence of computer viruses.

Please contact [EMAIL PROTECTED] with any queries.

**



___
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
** 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: Wierd SQL Error - Any Ideas?

2006-07-31 Thread Sietse Wijnker
Part of my explanation was missing:

The DATE() function does not accept year, month and day parameters that are
equal to 0 (zero) and responds with the 'Function argument value, type, or
count is invalid.' error. Because the VAL(substr()) starts with an empty
string, the call to the DATE() function is DATE(2000,0,0). So there's your
error!

Regards,
Sietse

 
 Hmm. strange indeed.
 
 What I'm seeing: The 1st call to the date function, the 
 curTemp.cDate contains an empty value! I'm not sure but I'm 
 bettiong it has to do with optimization of the query.
 I've seen this result by using an UDF that accepts 1 param 
 and prints it out to the screen.
 Then include that UDF as a column, passing the curTemp.cDate 
 as the param
 
 The solution:
 use EVL() in the expression:
 Date(2000+Val(Substr(EVL(curTemp.cDate, 01/01/00),7,2)), ;
   Val(Substr(EVL(curTemp.cDate, 01/01/00),4,2)), ;
   Val(Substr(EVL(curTemp.cDate, 01/01/00),1,2))) ;
 
 Another solution:
 You're only using the join to filter out the records from the lookup:
 
 Don't use the join but use
 Where curTemp.F1=A01 AND curTemp.FK1 IN (SELECT pk FROM curTemp2)
 
 Regards,
 Sietse Wijnker
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Dave Crozier
 Sent: maandag 31 juli 2006 12:04
 To: [EMAIL PROTECTED]
 Subject: Wierd SQL Error - Any Ideas?



___
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
** 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: Wierd SQL Error - Any Ideas?

2006-07-31 Thread Alan Bourke
Oooh nasty one!

I notice it works OK if you have SELECT * instead of SELECT ALL

-- 
  Alan Bourke
  [EMAIL PROTECTED]

-- 
http://www.fastmail.fm - One of many happy users:
  http://www.fastmail.fm/docs/quotes.html



___
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
** 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.


[OT] Lieberman, 2007!

2006-07-31 Thread Ed Leafe

http://villagevoice.com/news/0631,sutton,73970,9.html


-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com





___
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
** 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: Views in SQL Server

2006-07-31 Thread Andy Davies
Stephen Russell said I beg to differ.  Each time you submit a query
statement the server must
create an execution plan for it. 

We've had this discussion before:
according to my SQL Server book this is not true for v2000 and later -
execution plans are cached and if a subsequent query differs only in the
values in the where clause (~ 'parameters') the plan is re-used.

Foxpro's sqlprepare() may also be relevant, but I don't know how it is
handled by the bach-end.

Andrew Davies  MBCS CITP
  - AndyD    8-)#
PC Development Officer
Housing IT
Housing Services
Manchester City Council
@Hawthorn Cottage
( Office +44 161 234 5330
( Internal   [814] 5330
( Mobile 0775 938 5155 (when all else fails)
* [EMAIL PROTECTED]
* home [EMAIL PROTECTED]


**

This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by 
MIMEsweeper for the presence of computer viruses.

Please contact [EMAIL PROTECTED] with any queries.

**



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Ed Leafe

On Jul 31, 2006, at 4:25 AM, Dominic Burford wrote:


The simple minded folk on this list who defend Israel do
so using the antiquated straw man analogy that we must all be extreme
liberals who would love to hug a terrorist.  That would be funny if it
were not so pathetic.  Hiding behind such a straw man is an excuse so
that they do not have to come out and debate the real issues.  They
cower and hide hehind their whimsical caricatures instead, and their
infantile little tag lines such as 'Liberalism is a mental disorder'
(yawn).


And yet so many people here continue to feel the need to engage them.

	The only people who haven't already figured out their lack of  
substance aren't going to get it because others keep trying to  
point it out.


-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com





___
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
** 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: Views in SQL Server

2006-07-31 Thread Dave Crozier
Andy,
The bach-end - that's music to my ears! BG 


Dave Crozier
 The secret to staying young is to live honestly, eat slowly, and to lie
about your age 

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Andy Davies
Sent: 31 July 2006 12:55
To: profox@leafe.com
Subject: RE: Views in SQL Server

Stephen Russell said I beg to differ.  Each time you submit a query
statement the server must create an execution plan for it. 

We've had this discussion before:
according to my SQL Server book this is not true for v2000 and later -
execution plans are cached and if a subsequent query differs only in the
values in the where clause (~ 'parameters') the plan is re-used.

Foxpro's sqlprepare() may also be relevant, but I don't know how it is
handled by the bach-end.

Andrew Davies  MBCS CITP
  - AndyD    8-)#
PC Development Officer
Housing IT
Housing Services
Manchester City Council
@Hawthorn Cottage
( Office +44 161 234 5330
( Internal   [814] 5330
( Mobile 0775 938 5155 (when all else fails)
* [EMAIL PROTECTED]
* home [EMAIL PROTECTED]


**

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

Please contact [EMAIL PROTECTED] with any queries.

**



[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
** 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: Views in SQL Server

2006-07-31 Thread Stephen the Cook
Andy Davies  wrote:
 
 btw some comments on this topic seem to imply that SQL Server
 supports parameterised queries: afaik Foxpro supports parameterised
 queries, including queries to a SQL Server back-end, but SQL Server
 itself only supports parameters to sp's - or have I missed something?

Nope, but you can do a view and Select * from myView Where Customerid =1234
and your going to only get rows back on your customer.


Stephen Russell
DBA / Operations Developer

Memphis TN 38115
901.246-0159

http://spaces.msn.com/members/srussell/

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date: 7/28/2006
 



___
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
** 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.


a collection issue

2006-07-31 Thread Vassilis Aggelakos

Hi All,

I create a collection like this:
oCol = CreateObject(Collection)
ocol.add(5)
ocol.add(6)
ocol.add(7)

I type in the command window:
? oCol(2) and I get 6.
? oCol.item(2).value and I get 6.

OK until here.

Then I want to change the value of the second Col item to 11. 
(oCol.item(2).value)
Does anybody know How can I change the assigned value to a collection 
member?


TIA
Vassilis Aggelakos




___
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
** 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: a collection issue

2006-07-31 Thread Malcolm Greene
Vassilis,

You have to delete the original item and create a new item. There is no
way to directly change a colleciton item's value.

Malcolm


___
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
** 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: a collection issue

2006-07-31 Thread Vassilis Aggelakos

Thanks Mal,

I use collections in my apps very frequently. Usually I have a simple 
ColItem class that looks like this:


DEFINE CLASS myColItem AS Custom

Key = .null.
Value = .null.
TagInfo = .null.
oChild = .null.

ENDDEFINE

I add this object to my collection and everything is fine when I want to 
modify a value but playing now with collections I thought that I have missed 
something obvious.


Thank you very much

-V

- Original Message - 
From: Malcolm Greene [EMAIL PROTECTED]

To: profox@leafe.com
Sent: Monday, July 31, 2006 3:37 PM
Subject: Re: a collection issue



Vassilis,

You have to delete the original item and create a new item. There is no
way to directly change a colleciton item's value.

Malcolm



[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
** 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: [NF] Views in SQL Server

2006-07-31 Thread Michael Babcock

Andy Davies wrote:

M$ never adopted [packages], I can't understand why (unless it's a


copyright issue or something)??

  

--Michael



not copyright - iirc packages are part of the ansi standard - ms said there
was 'no demand'.

  

What's that address again.One Microsoft Way  ???  ;-)


--

Thanks,
--Michael



___
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
** 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 VFP as middle tier to do all the lifting versus stored procs on RDBMS

2006-07-31 Thread Michael Babcock
The discussion last week made me wonder where people stood on using VFP 
as the middle tier that it's been called best for in the past.  If you 
have a non-VFP object using VFP as the middle tier, you can only get 
back single values and not a cursor (unless you're going to create an 
XML document to be consumed by the non-VFP caller), right?  If you could 
get a cursor from VFP into the non-VFP caller, that'd be great, but I 
think VFP cursors are only akin to VFP, right?


How best would you use VFP as the middle tier?

--

Thanks,
--Michael



___
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
** 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 VFP as middle tier to do all the lifting versus stored procs on RDBMS

2006-07-31 Thread stephen . russell
 From: Michael Babcock [EMAIL PROTECTED]
 
 The discussion last week made me wonder where people stood on using VFP 
 as the middle tier that it's been called best for in the past.  If you 
 have a non-VFP object using VFP as the middle tier, you can only get 
 back single values and not a cursor (unless you're going to create an 
 XML document to be consumed by the non-VFP caller), right?  If you could 
 get a cursor from VFP into the non-VFP caller, that'd be great, but I 
 think VFP cursors are only akin to VFP, right?
 
 How best would you use VFP as the middle tier?

Only with a VFP front end.  



___
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
** 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 VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread David Crooks
On Monday, July 31, 2006 9:28 AM Stephen Russell wrote

 From: Michael Babcock [EMAIL PROTECTED]
snipped
 How best would you use VFP as the middle tier?

Only with a VFP front end.  

It is funny that I first thought the same thing.  Then I asked myself,
that a VFP middle tier really should work with any front end. Right?

David L. Crooks



___
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
** 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.


[OT] Yet another hypocrite

2006-07-31 Thread Ed Leafe

This time, it's Condi:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Secretary of State Condoleezza Rice said Monday she will seek  
international consensus for a cease-fire and a lasting settlement  
in the conflict between Lebanon and Israel through a U.N. Security  
Council resolution this week.


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

http://news.yahoo.com/s/ap/20060731/ap_on_re_mi_ea/ 
rice;_ylt=Ar27EGtXLbWgRHvKh8mTtpCs0NUE;_ylu=X3oDMTA3OTB1amhuBHNlYwNtdHM- 



( -or- http://tinyurl.com/nvdoz )

	Wait a second: a UN Security Council Resolution? Didn't she and the  
rest of the Bush Administration constantly use the UN and its  
resolutions as their whipping boy in justifying the invasion of Iraq?  
Now you want to use them when it might buy you some political points?


	I can't wait to hear all the Fox News pundits and their clones start  
ripping Rice and the Bush folk for this. After all, they ripped  
everyone who opposed the timetable for quick invasion of Iraq and  
ridiculed their insistence on letting the UN handle this, because in  
their opinion the UN was worthless, weak, powerless, and we would be  
better off getting rid of it.


-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com





___
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
** 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 Gig, Syracuse NY

2006-07-31 Thread Hal Kaplan
A franchise!  This could be the 'burger-flipping' job of the 21st
century G 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of William Sanders
Sent: Sunday, July 30, 2006 13:24
To: profox@leafe.com
Subject: VFP Gig, Syracuse NY

You guys may have seen it already -
also, wage posted seems low.
http://hotjobs.yahoo.com/jobs/NY/Syracuse/Technology/J787713EC
regards [Bill]
-- 

William Sanders / efGroup {rmv the DOT BOB to reply} VFP Webhosting? You
BET! - http://efgroup.net/vfpwebhosting Failing dotNet Project? -
http://www.dotnetconversions.com



[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
** 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 VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread Michael Babcock

David Crooks wrote:

On Monday, July 31, 2006 9:28 AM Stephen Russell wrote

  

From: Michael Babcock [EMAIL PROTECTED]
  

snipped
  

How best would you use VFP as the middle tier?
  


  
Only with a VFP front end.  



It is funny that I first thought the same thing.  Then I asked myself,
that a VFP middle tier really should work with any front end. Right?

  
That was my point tooas long as you're sending single pieces of 
information, sure.  You could I suppose pass an  XML stream that's a 
multi-record cursor when expanded I guess?



--

Thanks,
--Michael



___
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
** 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 Keyword Jeopardy (42)

2006-07-31 Thread Hal Kaplan
What do the locals call the portion of Michigan that is north of the
Strait of Mackinac?

What is the opposite of IP?

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Bill Anderson
Sent: Friday, July 28, 2006 16:02
To: ProFox Email List
Subject: VFP Keyword Jeopardy (42)


UP



[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
** 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 Keyword Jeopardy (43)

2006-07-31 Thread Hal Kaplan
What is the Weekly Newsmagazine called?

What did Jim Croce keep in his bottle? 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Bill Anderson
Sent: Friday, July 28, 2006 16:02
To: ProFox Email List
Subject: VFP Keyword Jeopardy (43)


TIME



[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
** 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.


Buffering and TableUpdate()

2006-07-31 Thread Kent Belan
Hello,
I am having a problem with my application VFP9 SP1.
I have all free tables with optimistic row buffering.

If I make a change on one computer and tableupdate() returns true,
other computers will not see the change to the data.

Example, 2 computers are sitting on the same invoice.
Computer 1 makes a change to the invoice status, then
computer 2 attempts an operation that depends on the status but
does not see the changes.

How do I get computer 2 to see the current values in the record?

Thanks,
Kent



___
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
** 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 VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread stephen . russell
 From: David Crooks [EMAIL PROTECTED]
 Only with a VFP front end.

 It is funny that I first thought the same thing.  Then I asked myself,
 that a VFP middle tier really should work with any front end. Right?

How does VFP interact with messages from a VB client, and how do you
pass back munged data that the middle tier does?  Who decides what date
format is correct?



___
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
** 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 VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread stephen . russell
 From: Michael Hawksworth [EMAIL PROTECTED]
 
 Try turning it around! If you were using c# for the middle tier what 
 would you pass?

Depends totaly on what is the receiving code compiled in.  VB6, VB.NET,
c++, java, python?  

XML sounds great, but at what volume and what distance are you passing? 






___
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
** 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: Buffering and TableUpdate()

2006-07-31 Thread Dave Crozier
Kent,
Unless you do a refresh of the data, the machine sitting on the original
record will not see the changes unless it tries to commit a change of its
own. Then and only then will you get an exception thrown and you can decide
what data is the most up to date. You need to refresh the data
periodically in the original record form to see any updates. 

If you are using grids or browse windows (uugh!) then these will refresh
automatically after the updates from the new form have been committed if
you set the set refresh to  command accordingly. 

Note that this command setting only refreshes the buffers and may or may
NOT affect the displayed data (i.e it works with unbuffered grids and memo
fields).

I usually use a timer to refresh the data on a form every 5 or 10 seconds.

Dave Crozier
 The secret to staying young is to live honestly, eat slowly, and to lie
about your age 

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Kent Belan
Sent: 31 July 2006 15:11
To: ProFox Email List
Subject: Buffering and TableUpdate()

Hello,
I am having a problem with my application VFP9 SP1.
I have all free tables with optimistic row buffering.

If I make a change on one computer and tableupdate() returns true, other
computers will not see the change to the data.

Example, 2 computers are sitting on the same invoice.
Computer 1 makes a change to the invoice status, then computer 2 attempts an
operation that depends on the status but does not see the changes.

How do I get computer 2 to see the current values in the record?

Thanks,
Kent



[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
** 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: Buffering and TableUpdate()

2006-07-31 Thread Michael Babcock

Kent Belan wrote:

Hello,
I am having a problem with my application VFP9 SP1.
I have all free tables with optimistic row buffering.

If I make a change on one computer and tableupdate() returns true,
other computers will not see the change to the data.

Example, 2 computers are sitting on the same invoice.
Computer 1 makes a change to the invoice status, then
computer 2 attempts an operation that depends on the status but
does not see the changes.

How do I get computer 2 to see the current values in the record?
  


Did Computer2 requery since Computer1 updated the data?

--

Thanks,
--Michael



___
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
** 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 VFP as middle tier to do all thelifting versus storedprocs on RDBMS

2006-07-31 Thread Nick Cipollina
I agree, unless VFP supports Binary serialization, use xml to
communicate between layers.

Thanks,
 
Nick Cipollina
 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Michael Hawksworth
Sent: Monday, July 31, 2006 9:58 AM
To: [EMAIL PROTECTED]
Subject: Re: using VFP as middle tier to do all thelifting versus
storedprocs on RDBMS

Try turning it around! If you were using c# for the middle tier what 
would you pass?

You would have to stay with the standards that your front end and middle

tier both understand or go to a portable standard such as XML.

The fact you are using VFP for the middle tier is moot unless you are 
using a VFP front end in which case you can pass cursors around (which 
is great) otherwise I would say XML is fine and maybe should be used 
between layers in vfp only apps for future proofing.

-- 
Michael Hawksworth
Visual Fox Solutions

[EMAIL PROTECTED]
www.foxpro.co.uk





[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
** 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 VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread Ed Leafe

On Jul 31, 2006, at 9:32 AM, David Crooks wrote:


How best would you use VFP as the middle tier?



Only with a VFP front end.


It is funny that I first thought the same thing.  Then I asked myself,
that a VFP middle tier really should work with any front end. Right?


	You have to approach this in terms on inter-tier messaging. VFP can  
interface great with various backends, but how well does it interface  
with different front ends? If the webserver is your front end, and it  
'talks' VFP, then VFP is a great middle tier. If your front end is  
a .Net form, it probably doesn't speak VFP very well, and might not  
be the best choice. If your front end is a Qt form running on Linux,  
well...


-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com





___
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
** 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: Buffering and TableUpdate()

2006-07-31 Thread Kent Belan
Hello Dave,
Thanks for the reply.

How do I refresh the data on computer 2 after computer 1 makes a change?

I understand the timer, but do I have to seek the invoice or can I just do a
thisform.refresh()

Thanks,
Kent


 Kent,
 Unless you do a refresh of the data, the machine sitting on the original
 record will not see the changes unless it tries to commit a change of its
 own. Then and only then will you get an exception thrown and you
 can decide
 what data is the most up to date. You need to refresh the data
 periodically in the original record form to see any updates.

 If you are using grids or browse windows (uugh!) then these will refresh
 automatically after the updates from the new form have been committed if
 you set the set refresh to  command accordingly.

 Note that this command setting only refreshes the buffers and may or may
 NOT affect the displayed data (i.e it works with unbuffered grids and memo
 fields).

 I usually use a timer to refresh the data on a form every 5 or 10 seconds.

 Dave Crozier
  The secret to staying young is to live honestly, eat slowly, and to lie
 about your age



 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
 Of Kent Belan
 Sent: 31 July 2006 15:11
 To: ProFox Email List
 Subject: Buffering and TableUpdate()

 Hello,
 I am having a problem with my application VFP9 SP1.
 I have all free tables with optimistic row buffering.

 If I make a change on one computer and tableupdate() returns true, other
 computers will not see the change to the data.

 Example, 2 computers are sitting on the same invoice.
 Computer 1 makes a change to the invoice status, then computer 2
 attempts an
 operation that depends on the status but does not see the changes.

 How do I get computer 2 to see the current values in the record?

 Thanks,
 Kent



[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
** 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: Buffering and TableUpdate()

2006-07-31 Thread Dave Crozier
Kent,
Re-seeking the invoice data will give the desired effect or even a goto
recno() for individual records in the invoice. 

Just a point, if you are viewing the invoice details in a Grid then you
certainly need the set refresh to set to say 1 second. 

How are you holding the data on your forms? Are the data fields bound
directly to the table data or to the fields in a cursor or data object and
are you using any form of transactions? If not then it might be sensible to
look a this form of processing so that all the updates can be made in effect
off line without affecting the underlying data until you commit or
rollback.

Personally in a strictly ON-LINE system I hold all detail data in a grid and
that way it gets refreshed automatically regardless of refreshing the page.
Once the Edit selection is made for an invoice, the header is locked
using RLock() so that nobody else can edit the record and Double clicking on
an item opens up a edit section of the form for that item in the knowledge
that nobody else can be editing the Invoice at that time. When I'm writing
an OFF-LINE system I use the temporary cursor approach to load ALL the
invoice data for modification then commit the changes back when apropriate.
The nice thing about doing it this way is that the user can always easily
ABORT. Although you can do this on a live underlying table using Begin
Transaction I find it messy, hence the Off-Line approach with data being
loaded into data objects from the cursor.

There are advantages in using each method and implimentation is normally
down to personal preference.

Just remember that you WON'T see the updated data untill the other machine
commits the transaction or moves off the record(s) (with No Buffering) or
commits the update (with buffering) no matter which method of refreshing you
use, So if the new record form sits on an item line it will NEVER get
written back to the underlying table.

Dave Crozier
 The secret to staying young is to live honestly, eat slowly, and to lie
about your age 

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Kent Belan
Sent: 31 July 2006 15:37
To: ProFox Email List
Subject: RE: Buffering and TableUpdate()

Hello Dave,
Thanks for the reply.

How do I refresh the data on computer 2 after computer 1 makes a change?

I understand the timer, but do I have to seek the invoice or can I just do a
thisform.refresh()

Thanks,
Kent


 Kent,
 Unless you do a refresh of the data, the machine sitting on the 
 original record will not see the changes unless it tries to commit a 
 change of its own. Then and only then will you get an exception thrown 
 and you can decide what data is the most up to date. You need to 
 refresh the data periodically in the original record form to see any 
 updates.

 If you are using grids or browse windows (uugh!) then these will 
 refresh automatically after the updates from the new form have been 
 committed if you set the set refresh to  command accordingly.

 Note that this command setting only refreshes the buffers and may or 
 may NOT affect the displayed data (i.e it works with unbuffered grids 
 and memo fields).

 I usually use a timer to refresh the data on a form every 5 or 10 seconds.

 Dave Crozier
  The secret to staying young is to live honestly, eat slowly, and to 
 lie about your age



 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Kent Belan
 Sent: 31 July 2006 15:11
 To: ProFox Email List
 Subject: Buffering and TableUpdate()

 Hello,
 I am having a problem with my application VFP9 SP1.
 I have all free tables with optimistic row buffering.

 If I make a change on one computer and tableupdate() returns true, 
 other computers will not see the change to the data.

 Example, 2 computers are sitting on the same invoice.
 Computer 1 makes a change to the invoice status, then computer 2 
 attempts an operation that depends on the status but does not see the 
 changes.

 How do I get computer 2 to see the current values in the record?

 Thanks,
 Kent



[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
** 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.


[NF] Microsoft to charge for Office Betas

2006-07-31 Thread Dave Crozier
Well now you have to pay in order to pick the bugs out of the new M$ Beta
software

Microsoft is to start charging $1.50 for beta versions of Office 2007. From
2 August anyone wanting to download the software will have to pay the small
fee.

http://www.regdeveloper.co.uk/2006/07/31/office_betas_cost/
 
 
Dave Crozier
 The secret to staying young is to live honestly, eat slowly, and to lie
about your age 

 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date: 28/07/2006
 




___
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
** 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 VFP as middle tier to do all the lifting versus stored procs on RDBMS

2006-07-31 Thread Andy Davies
Paul Hill said You could use a cursor internally and create methods to
navigate (GoTop(), MoveNext(), EOF() etc). The object would probably need
expose a property for each field in the results.
I played with this some time ago...

So did I - with the .net beta - it worked just fine. iirc I returned a
'scatter name' object.

Andrew Davies  MBCS CITP
  - AndyD    8-)#


**

This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by 
MIMEsweeper for the presence of computer viruses.

Please contact [EMAIL PROTECTED] with any queries.

**



___
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
** 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 VFP as middle tier to do all the lifting versus stored procs on RDBMS

2006-07-31 Thread Michael Babcock

Andy Davies wrote:

Paul Hill said You could use a cursor internally and create methods to
navigate (GoTop(), MoveNext(), EOF() etc). The object would probably need
expose a property for each field in the results.
I played with this some time ago...

So did I - with the .net beta - it worked just fine. iirc I returned a
'scatter name' object.

  
But again, that comes back to what I said:  it's ok for use in cases 
where it's ONE record that you're passing to the caller, but in the case 
where you'd need 1:M, it would have to be XML for non-VFP links.



--

Thanks,
--Michael



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Michael Madigan
You're unable to grasp the facts. The Hezbollah
purposely shot rockets off from there to draw fire so
they could make the news.  And the networks obliged.  

This is a war, in case you hadn't realized.

--- Paul Hill [EMAIL PROTECTED] wrote:

 Irrelevant.  I suppose the 37 children Israelis
 killed yesterday in
 Qana was OK too?  After all, they're only Muslims
 right?
 
 On 7/31/06, Michael Madigan [EMAIL PROTECTED]
 wrote:
  Here's the explanation.
 
 

http://www.canada.com/ottawacitizen/news/story.html?id=37278180-a261-421d-84a9-7f94d5fc6d50
 
  --- Paul Hill [EMAIL PROTECTED] wrote:
 
   On 7/30/06, Michael Madigan
 [EMAIL PROTECTED]
   wrote:
Goofed my ass, they were shooting rockets from
   that
building.
  
   Were the UN inspectors firing rockets too?
 
 
 ___
 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
 ** 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.
 



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Michael Madigan
Please, you've been brainwashed by the Israel-hatiing
BBC. 

--- Dominic Burford [EMAIL PROTECTED]
wrote:

 Quotes from myself to Michael on another, related
 thread:
 
 
 The US will never openly condemn Israel.  It is no
 coincidence that your
 news coverage always seems to paint Israel's enemies
 as the bad guys
 (Palestine, Lebanon, getting the picture yet?)
 
 
 And...
 
 
 Israel fire at who they like, and act with impunity,
 because they know
 that their bigger brother - the US - will always
 defend them.   
 
  
 It seems many people have been brainwashed by their
 media and
 politicians.  The simple minded folk on this list
 who defend Israel do
 so using the antiquated straw man analogy that we
 must all be extreme
 liberals who would love to hug a terrorist.  That
 would be funny if it
 were not so pathetic.  Hiding behind such a straw
 man is an excuse so
 that they do not have to come out and debate the
 real issues.  They
 cower and hide hehind their whimsical caricatures
 instead, and their
 infantile little tag lines such as 'Liberalism is a
 mental disorder'
 (yawn).
 
 Cowardice of the worst kind.
 
 Regads
 
 Dominic Burford BSc Hons MBCS CITP
 Third Party Developer Program Senior Software
 Engineer 
 
 * Tel: +44 (0) 1536 495074
 * [EMAIL PROTECTED] 
 
 I conclude that there are two ways of constructing
 a software design:
 One way is to make it so simple there are obviously
 no deficiencies, and
 the other way is to make it so complicated that
 there are no obvious
 deficiencies. -- Tony Hoare, Turing Award Lecture
 1980
 
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On
 Behalf Of Paul Hill
 Sent: 31 July 2006 09:08
 To: ProFox Email List
 Subject: Re: [OT] The savages are breaking into the
 UN offices in Beirut
 
 Irrelevant.  I suppose the 37 children Israelis
 killed yesterday in Qana
 was OK too?  After all, they're only Muslims right?
 
 On 7/31/06, Michael Madigan [EMAIL PROTECTED]
 wrote:
  Here's the explanation.
 
 

http://www.canada.com/ottawacitizen/news/story.html?id=37278180-a261-4
  21d-84a9-7f94d5fc6d50
 
  --- Paul Hill [EMAIL PROTECTED] wrote:
 
   On 7/30/06, Michael Madigan
 [EMAIL PROTECTED]
   wrote:
Goofed my ass, they were shooting rockets from
   that
building.
  
   Were the UN inspectors firing rockets too?
 
 
 ___
 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
 ** 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.
 

__
 This email has been scanned by the MessageLabs Email
 Security System.
 For more information please visit
 http://www.messagelabs.com/email

__
 

__
 Pegasus Software Limited is a member of the Systems
 Union Group plc
 
 Registered Office:  Systems Union House, 1 Lakeside
 Road, Aerospace Centre, Farnborough, Hampshire GU14
 6XP  Registered No: 1601542
 
 This e-mail is from Pegasus Software Limited. The
 e-mail and any files transmitted with it are
 confidential and intended solely for the use of the
 individual or entity to whom it is addressed. If you
 have received this e-mail in error you must not
 copy, distribute or take any action in reliance on
 it. Please notify the sender by e-mail or telephone.
 
 Pegasus Software Limited utilises an anti-virus
 system and therefore any files sent via e-mail will
 have been checked for known viruses. You are however
 advised to run your own virus check before opening
 any attachments received as Pegasus Software Limited
 will not in any event accept any liability
 whatsoever once an e-mail and/or any attachment is
 received.
 
 This email has been scanned by the MessageLabs Email
 Security System.
 For more information please visit
 http://www.messagelabs.com/email 

__
 
 
 ___
 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
 ** 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.
 


Hezbollah Human Shields  http://www.cafepress.com/rightwingmike/1688255
Right Wing Stuff at http://www.cafepress.com/rightwingmike
Horse Racing Photos at http://www.HorseRacingPix.com



RE: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Michael Madigan
I haven't seen one post from the Jew haters on this
list condemning the killing of Israeli children.  I
don't remember the Jew haters condemning the suicide
bombers that were climbing onto school buses.  I don't
see one condemnation of the Kaytusha rockets, which
are unguided, being fired into cities.  

The Hezbollah are targeting civilians, the Israelis
are accidental hitting civilians.

Are the Hezbollah sending fliers over to warn of
impending military action?

--- Dominic Burford [EMAIL PROTECTED]
wrote:

  hugging terrorists, hating America and hating
 Israel
 
 These are complex issues which have been simplified
 into infantile tags.
 It is easier to churn out these (and hundreds more
 like them) that to
 discuss the real issues.  The irony is, you have
 done exactly what I
 have described you would do.  You have hidden behind
 your caricatures,
 because you are incapable of discussing the real
 issues.
 
 Go ahead and throw your caricatures and tag lines
 around
 
 ___
 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
 ** 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.
 



___
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
** 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 VFP as middle tier to do all thelifting versus storedprocs on RDBMS

2006-07-31 Thread Profox
Try turning it around! If you were using c# for the middle tier what 
would you pass?


You would have to stay with the standards that your front end and middle 
tier both understand or go to a portable standard such as XML.


The fact you are using VFP for the middle tier is moot unless you are 
using a VFP front end in which case you can pass cursors around (which 
is great) otherwise I would say XML is fine and maybe should be used 
between layers in vfp only apps for future proofing.


That's right. The issue of what standard to pass information
will be dependent on the capabilities of each tier IMO.

Before Flash was capable of dealing with XML we developed
a VFP middle tier that received text streams from a Flash
interface, queried a SQL Server backend and passed text
streams back to the Flash interface. We didn't develop the
Flash interface, we just provided the Flash developers with
a couple of lines of hook code.

Jim Eddins



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Michael Madigan
Kind of like Katrina victims.  They know the storm is
coming, they just stay where they are.


 Would you really listen to the enemy?  Come on Pete.
  You would have had
 your gun drawn and a few boxes of ammo handy.
 
 
 
 Stephen Russell
 DBA / Operations Developer
 
 Memphis TN 38115
 901.246-0159
 
 http://spaces.msn.com/members/srussell/
 
 -- 
 No virus found in this outgoing message.
 Checked by AVG Free Edition.
 Version: 7.1.394 / Virus Database: 268.10.5/403 -
 Release Date: 7/28/2006
  
 
 
 
 ___
 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
 ** 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.
 


Hezbollah Human Shields  http://www.cafepress.com/rightwingmike/1688255
Right Wing Stuff at http://www.cafepress.com/rightwingmike
Horse Racing Photos at http://www.HorseRacingPix.com


___
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
** 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: Buffering and TableUpdate()

2006-07-31 Thread Rick Schummer
Assuming you are using tables and not views, you can use the SET REFRESH 
command to
control how often VFP refreshes the local cache. The only other way to force 
VFP to
refresh the local cache is to lock a record (which is what happens when you 
perform the
TABLEUPDATE() in a optimistic buffering scenario).

If you are using local views then the data is only refreshed as often as a 
REQUERY() is
performed on the view.

Rick
White Light Computing, Inc.

www.whitelightcomputing.com
www.rickschummer.com
586.254.2530 - office
586.254.2539 - fax
  

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kent
Belan
Sent: Monday, July 31, 2006 10:37 AM
To: [EMAIL PROTECTED]
Subject: RE: Buffering and TableUpdate()

Hello Dave,
Thanks for the reply.

How do I refresh the data on computer 2 after computer 1 makes a change?

I understand the timer, but do I have to seek the invoice or can I just do a
thisform.refresh()

Thanks,
Kent


 Kent,
 Unless you do a refresh of the data, the machine sitting on the 
 original record will not see the changes unless it tries to commit a 
 change of its own. Then and only then will you get an exception thrown 
 and you can decide what data is the most up to date. You need to 
 refresh the data periodically in the original record form to see any 
 updates.

 If you are using grids or browse windows (uugh!) then these will 
 refresh automatically after the updates from the new form have been 
 committed if you set the set refresh to  command accordingly.

 Note that this command setting only refreshes the buffers and may or 
 may NOT affect the displayed data (i.e it works with unbuffered grids 
 and memo fields).

 I usually use a timer to refresh the data on a form every 5 or 10 seconds.

 Dave Crozier
  The secret to staying young is to live honestly, eat slowly, and to 
 lie about your age



 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Kent Belan
 Sent: 31 July 2006 15:11
 To: ProFox Email List
 Subject: Buffering and TableUpdate()

 Hello,
 I am having a problem with my application VFP9 SP1.
 I have all free tables with optimistic row buffering.

 If I make a change on one computer and tableupdate() returns true, 
 other computers will not see the change to the data.

 Example, 2 computers are sitting on the same invoice.
 Computer 1 makes a change to the invoice status, then computer 2 
 attempts an operation that depends on the status but does not see the 
 changes.

 How do I get computer 2 to see the current values in the record?

 Thanks,
 Kent



[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
** 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: [NF] Microsoft to charge for Office Betas

2006-07-31 Thread Whil Hentzen (Pro*)

Dave Crozier wrote:

Well now you have to pay in order to pick the bugs out of the new M$ Beta
software

Microsoft is to start charging $1.50 for beta versions of Office 2007. From
2 August anyone wanting to download the software will have to pay the small
fee.

http://www.regdeveloper.co.uk/2006/07/31/office_betas_cost/


Let me be the first to say it... we've been paying for their beta 
software for years Windows, Office, servers they just haven't 
called them 'betas' before.


Whil


___
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
** 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: [NF] Microsoft to charge for Office Betas

2006-07-31 Thread Dave Crozier
Nice one Whil! 

Dave Crozier
 The secret to staying young is to live honestly, eat slowly, and to lie
about your age 

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Whil Hentzen (Pro*)
Sent: 31 July 2006 17:01
To: profox@leafe.com
Subject: Re: [NF] Microsoft to charge for Office Betas

Dave Crozier wrote:
 Well now you have to pay in order to pick the bugs out of the new M$ 
 Beta software
 
 Microsoft is to start charging $1.50 for beta versions of Office 
 2007. From
 2 August anyone wanting to download the software will have to pay the 
 small fee.
 
 http://www.regdeveloper.co.uk/2006/07/31/office_betas_cost/

Let me be the first to say it... we've been paying for their beta software
for years Windows, Office, servers they just haven't called them
'betas' before.

Whil


[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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread stephen . russell
 From: Ed Leafe [EMAIL PROTECTED]
   It has nothing to do with any of that. You must first accept the  
 notion that US is divinely guided, and that anything we do is Good.  
 Same with Israel. We are incapable of doing bad things, since a  
 priori everything we do is Good. When we wipe out a population and  
 take their land, it is Manifest Destiny, and if you were an Indian,  
 well, sucks to be you, but God wanted us to do it. Same thing when we  
 torture people; it's not brutal and inhuman, because it's Jesus' hand  
 placing the electrodes on their testicles, not ours.

You are one sick person Ed.  Dropping that second o in Good





___
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
** 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.


[OT] to succeed in American politics

2006-07-31 Thread Bill Arnold

But in many ways, AIPAC has become greater than just another lobby; its
work has made unconditional support for Israel an accepted cost of doing
business inside the halls of Congress.

When it comes to the Israeli-Arab conflict, the terms of debate are so
influenced by organized Jewish groups, like AIPAC, that to be critical
of Israel is to deny oneself the ability to succeed in American
politics.

http://www.thenation.com/doc/20060814/aipacs_hold

Mel Gibson should sober up and make Braveheart takes on Washington. 


Bill



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread stephen . russell
 From: Michael Madigan [EMAIL PROTECTED]
 
 Oh please.  These people are either terrorists or
 terrorist sympathizers. 

They sure aren't your friend after you take their living space, or city
infrastructure.  

It's like it's a scene made for a Halaburton No Bid Contract.  

Bad Steve!



___
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
** 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: [OT] to succeed in American politics

2006-07-31 Thread Michael Madigan
Yes about the Evil Jews behind every corner.  Look
out! Here's another one.  What's that in his hand? 
Looks like a pastrami on rye.

--- Bill Arnold [EMAIL PROTECTED] wrote:

 
 But in many ways, AIPAC has become greater than
 just another lobby; its
 work has made unconditional support for Israel an
 accepted cost of doing
 business inside the halls of Congress.
 
 When it comes to the Israeli-Arab conflict, the
 terms of debate are so
 influenced by organized Jewish groups, like AIPAC,
 that to be critical
 of Israel is to deny oneself the ability to succeed
 in American
 politics.
 
 http://www.thenation.com/doc/20060814/aipacs_hold
 
 Mel Gibson should sober up and make Braveheart
 takes on Washington. 
 
 
 Bill
 
 
 
 ___
 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
 ** 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.
 



___
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
** 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: Views in SQL Server

2006-07-31 Thread Mike yearwood

Hi Andy


From: Andy Davies [EMAIL PROTECTED]
Subject: Re: Views in SQL Server



Mike Yearwood said If you always use parameterized SQL queries, the
parameter contents can not be used for SIA.

Surely it depends how you build the parameter variables - if you let the
user enter them what is to stop them entering e.g. a city name as
manchester go truncate table dbo.sysusers go


No offense meant, but this is another almost myth. Parameter content
is not executed.

Your example would have to be more like:

manchester' go truncate table dbo.sysusers go

If I pass a parameter to a query the profiler shows:

exec sp_executesql N'select * from Table where field = @P1 ', N'@P1
varchar(21)', ''manchester' go truncate table dbo.sysusers go''

Which will only attempt to find records in the table with that value
in the column 'field'. No string scrubbing to remove invalid
characters is required!

The hackers are hoping we're all stupid enough to concatenate in our
applications and stored procedures! Cause if you did such
concatenating in a custom SP, you'd still be open to SIA.

lccmd = select * from Table where field = 'manchester' go truncate
table dbo.sysusers go
sqlexec(m.lnconnection,m.lccmd)

The profiler would show:

exec sp_executesql N'select * from Table where field = 'manchester' go
truncate table dbo.sysusers go'

That entire command would be executed as is and your sysusers would vanish.


and If someone were somehow able to access your database at all and run a
query, they can just as easily run your SPs.


I thought that was the point - you make the error checking in your sp rock
solid so you don't care what tool is used to access it.


I'd guess any tool that can call SPs should be able to create
parameterized ad-hoc SQL. I can only see *needing* an SP for a complex
multi-table multi-step almost procedural function, not for simple or
even complex queries.


btw some comments on this topic seem to imply that SQL Server supports
parameterised queries: afaik Foxpro supports parameterised queries,
including queries to a SQL Server back-end, but SQL Server itself only
supports parameters to sp's - or have I missed something?


That would imply VFP/Access/Crystal Reports/VB were concatenating the
user values into the query command string, which is not true. That
would be a reason to use SPs only! However, let me put it another way.
The product is called SQL Server, not SP Server. ;) It's better than
you're giving it credit for.


From the SQL Server Books Online:


sp_executesql

Executes a Transact-SQL statement or batch that can be reused many
times, or that has been built dynamically. The Transact-SQL statement
or batch can contain embedded parameters.

Syntax
sp_executesql [EMAIL PROTECTED] =] stmt
[
   {, [EMAIL PROTECTED] =] N'@parameter_name  data_type [,...n]' }
   {, [EMAIL PROTECTED] =] 'value1' [,...n] }
]

Which brings me to one last point. If an application is separating a
user from the back-end, why should we be going to all this trouble to
secure the back-end with SPs?

Mike


___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread stephen . russell
 From: Michael Madigan [EMAIL PROTECTED]

 Open your home to terrorists, open your home to a
 guided missile.

Jesus frequented visitations with sinners, and tax collectors.  If they
didn't want to listen he just shook the dirt off his sandals and found
new ones.







___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Michael Madigan
Jesus wasn't being hit by Kaytushas.

--- [EMAIL PROTECTED] wrote:

  From: Michael Madigan [EMAIL PROTECTED]
 
  Open your home to terrorists, open your home to a
  guided missile.
 
 Jesus frequented visitations with sinners, and tax
 collectors.  If they
 didn't want to listen he just shook the dirt off his
 sandals and found
 new ones.
 
 
 
 
 
 
 
 ___
 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
 ** 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.
 



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Michael Madigan
Signs that the Apocolypse is upon us:

I agree with almost everything you've said.

Repent for the day of the Lord is at hand!

--- Profox [EMAIL PROTECTED] wrote:

 snipped
 I don't remember anyone on this list condemning
 Syria
 or Iran either.  I guess because they're not Jewish
 states.
 /snipped
 
 I'll condemn Syria, Iran and Hezboullah. Israel has
 the
 right to do what they are doing. However, they won't
 succeed because you can't fight terrorists or
 terrorism
 with a standing army.
 
 This is my biggest beef with the stupidity of the
 Bush
 Administration's going into Iraq and tying up so
 much
 of our resources. They've tied our hands and freed
 Iran and Syria to do their dirty work.
 
 Here's my take on what should have happened:
 
 1. It was the right thing to do in invading
 Afganistan,
 but we should have done it with enough of our and
 our allies troops to fully occupy and pacify it.
 
 2. Leave Iraq alone. Iraq and Saddam was a counter
 weight against Iran. Take care of Iraq long after
 every
 thing else is done.
 
 3. From our base of operations in Afganistan, Fund
 our own insurgents in Iran and Syria the same way
 we funded and helped the Mujahudeen beat the
 Russians.
 
 With armed and trained insurgents inside their own
 country, Iran and Syria would be getting a dose of
 their own medicine. Syria would topple in a heart
 beat,
 Iran would take longer.
 
 4. Send special forces into Pakistan's Northwestern
 territory to root out Osama Bin Laden.
 
 5. Send troops to occupy the Kurdish region of Iraq,
 which is already outside of Iraq anyway under the no
 fly zone, to protect them and the northern Iraqi
 oil.
 
 Saddam couldn't and wouldn't do much about that.
 
 6. Use our vast propaganda machine against the
 Muslims to pit one against the other. That ain't
 hard
 to do. None of them truly like each other.
 
 7. Put Saudi Arabia on notice that we can and will
 confiscate their wealth held in this country and in
 other places around the world if they continue
 funding
 terrorism and Islamic fundamentalists with oil
 riches.
 
 8. Do what we did during World War II like
 developing
 synthetic rubber and oil to find new sources of
 energy to
 rid industrial nations of the need for Middle
 Eastern oil
 once and for all.
 
 9. Force Isreal to settle the Palestinian problem
 once
 and for all by giving up the West Bank and ceding
 enough
 of the worthless desert to connect Gaza and the West
 Bank.
 
 The West Bank belonged to Jordan originally and they
 gave up all claims to it so it could be used for
 that purpose.
 
 That won't completely stop Palestinian terrorism,
 but it
 forces them to finally admit why they are doing what
 they
 are doing and eliminates a lot of international
 sympathy.
 
 There are a few other things we could do, but those
 are
 the main points.
 
 Jim Eddins
 
 
 
 ___
 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
 ** 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.
 


Hezbollah Human Shields  http://www.cafepress.com/rightwingmike/1688255
Right Wing Stuff at http://www.cafepress.com/rightwingmike
Horse Racing Photos at http://www.HorseRacingPix.com


___
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
** 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 VFP as middle tier to do all the lifting versus storedprocs on RDBMS

2006-07-31 Thread David Stevenson
Stephen,

It's been a long time since I did any XML from VFP.  Can VFP pull schema
and determine that there is a small combination of tables in an xml
file?  Or do you have to parse that out yourself?

VFP's XMLAdapter can handle it if the schema isn't too complicated. In
general, anything output from DataSet.ToXML can be read by XMLAdapter,
including multiple tables. 

However, the MissingSchemaAction=MissingSchemaAction.AddWithKey setting is
needed on the .NET DataAdapter to be sure it sends field lengths and
precision in the schema -- at least in earlier versions of .NET (haven't
tried in 2.0 yet to see if they changed the default setting to actually
include that info). If you don't change that, the XML output by DataSet has
a brain-dead schema that results in all fields becoming Memos in VFP
cursor when XMLAdapter reads it in. Alternatively, you can set up a schema
programmatically in XMLAdapter to work around the problem.

But back to your question, yes, VFP XMLAdapter can handle multiple tables in
the same XML if it has a schema to use in interpreting the data. XMLToCursor
cannot handle more than one table, but does not require a schema (makes a
best guess on field type, length and precision unless you use 8192 flag to
direct the data into an existing pre-formatted cursor).

David Stevenson 





[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
** 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.


[OT] Any Southwest fliers out there?

2006-07-31 Thread Ed Leafe
How To Change A Southwest Airlines Boarding Pass From a C or B to  
and A!



http://boardfast.blogspot.com/2006/07/how-to-change-southwest- 
airlines.html


( -or- http://tinyurl.com/ztkkm )


-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com





___
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
** 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.


Design question

2006-07-31 Thread Michael Babcock
Would you rather your UI look at a property on the bizobj interface for 
a value, or call a bizobj function to get the value?  Assume that it's 
something that would only be called once or twice, not repeatedly (as 
the case would be with something in a UI.refresh event). 


Is there a better choice, or is this 6 of one, 1/2 dozen of another?


--

Thanks,
--Michael



___
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
** 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: Design question

2006-07-31 Thread Michael Babcock

Michael Babcock wrote:
Would you rather your UI look at a property on the bizobj interface 
for a value, or call a bizobj function to get the value?  Assume that 
it's something that would only be called once or twice, not repeatedly 
(as the case would be with something in a UI.refresh event).

Is there a better choice, or is this 6 of one, 1/2 dozen of another?


Forgot to add:  this is something that affects the enable/disable of a 
control, and is not directly tied to any object's controlsource.


--

Thanks,
--Michael



___
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
** 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: Design question

2006-07-31 Thread Ed Leafe

On Jul 31, 2006, at 1:38 PM, Michael Babcock wrote:

Would you rather your UI look at a property on the bizobj interface  
for a value, or call a bizobj function to get the value?  Assume  
that it's something that would only be called once or twice, not  
repeatedly (as the case would be with something in a UI.refresh  
event).

Is there a better choice, or is this 6 of one, 1/2 dozen of another?


	The important thing is that when you create your design, you define  
an interface that will not be changing and use that for all inter- 
object communication. Whether it is a property or a method call is  
not that important; what is important is that you don't have objects  
accessing implementation details.


-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com





___
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
** 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: Design question

2006-07-31 Thread Michael Babcock

Ed Leafe wrote:

On Jul 31, 2006, at 1:38 PM, Michael Babcock wrote:

Would you rather your UI look at a property on the bizobj interface 
for a value, or call a bizobj function to get the value?  Assume that 
it's something that would only be called once or twice, not 
repeatedly (as the case would be with something in a UI.refresh event).

Is there a better choice, or is this 6 of one, 1/2 dozen of another?


The important thing is that when you create your design, you 
define an interface that will not be changing and use that for all 
inter-object communication. Whether it is a property or a method call 
is not that important; what is important is that you don't have 
objects accessing implementation details.


And by that you mean to be very interchangable and not get snagged on 
the different layers from which it may be called, if I understand that 
principle correctly.  An  example for folks not familiar with this would 
be where you program something using objects on a page, then later put 
them into some other container on a different level (say a page within a 
pageframe).  If you've designed to the interface, everything should 
still function just fine instead of not being able to find the 
references correctly.  That's another reason why it's good to put the 
code in the highest level (in this case, the custom form methods) 
instead of the button.clicks.  Also allows for easier re-use if you 
really need it:  like instantiating the form and calling it's custom 
object -- that's a heck of a lot easier than instantiating the form and 
having to drive down 'n' levels into the object hierarchy to some 
button's click event!


Just trying to help the lurkers...correct me if wrong.

--

Thanks,
--Michael



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Kristyne McDaniel
Ed,

   Your thinking is being clouded by these wacky shades of grey  
 concepts. Things make much more sense when you only think in these  
 black-and-white notions.

That must be why Ann Coulter is always in a short black dress exposing lots
of pasty-colored white skin. Her fans not only think in black and white --
those are the only colors they can see!

-- Kris
http://www.mcstyles.com



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Bob Calco
Jim:

You have just articulated a plan I can actually respect as a
potentially viable alternative to what we've done that actually makes
tactical and strategic sense on numerous levels that the standard
shrill critiques from the black helicopter crowd do not. My hat is off
to you and I thank you.

- Bob

! -Original Message-
! From: [EMAIL PROTECTED] 
! [mailto:[EMAIL PROTECTED] On Behalf Of Profox
! Sent: Monday, July 31, 2006 1:18 PM
! To: ProFox Email List
! Subject: Re: [OT] The savages are breaking into the UN 
! offices in Beirut
! 
! snipped
! I don't remember anyone on this list condemning Syria
! or Iran either.  I guess because they're not Jewish
! states.
! /snipped
! 
! I'll condemn Syria, Iran and Hezboullah. Israel has the
! right to do what they are doing. However, they won't
! succeed because you can't fight terrorists or terrorism
! with a standing army.
! 
! This is my biggest beef with the stupidity of the Bush
! Administration's going into Iraq and tying up so much
! of our resources. They've tied our hands and freed
! Iran and Syria to do their dirty work.
! 
! Here's my take on what should have happened:
! 
! 1. It was the right thing to do in invading Afganistan,
! but we should have done it with enough of our and
! our allies troops to fully occupy and pacify it.
! 
! 2. Leave Iraq alone. Iraq and Saddam was a counter
! weight against Iran. Take care of Iraq long after every
! thing else is done.
! 
! 3. From our base of operations in Afganistan, Fund
! our own insurgents in Iran and Syria the same way
! we funded and helped the Mujahudeen beat the Russians.
! 
! With armed and trained insurgents inside their own
! country, Iran and Syria would be getting a dose of
! their own medicine. Syria would topple in a heart beat,
! Iran would take longer.
! 
! 4. Send special forces into Pakistan's Northwestern
! territory to root out Osama Bin Laden.
! 
! 5. Send troops to occupy the Kurdish region of Iraq,
! which is already outside of Iraq anyway under the no
! fly zone, to protect them and the northern Iraqi oil.
! 
! Saddam couldn't and wouldn't do much about that.
! 
! 6. Use our vast propaganda machine against the
! Muslims to pit one against the other. That ain't hard
! to do. None of them truly like each other.
! 
! 7. Put Saudi Arabia on notice that we can and will
! confiscate their wealth held in this country and in
! other places around the world if they continue funding
! terrorism and Islamic fundamentalists with oil riches.
! 
! 8. Do what we did during World War II like developing
! synthetic rubber and oil to find new sources of energy to
! rid industrial nations of the need for Middle Eastern oil
! once and for all.
! 
! 9. Force Isreal to settle the Palestinian problem once
! and for all by giving up the West Bank and ceding enough
! of the worthless desert to connect Gaza and the West Bank.
! 
! The West Bank belonged to Jordan originally and they
! gave up all claims to it so it could be used for that purpose.
! 
! That won't completely stop Palestinian terrorism, but it
! forces them to finally admit why they are doing what they
! are doing and eliminates a lot of international sympathy.
! 
! There are a few other things we could do, but those are
! the main points.
! 
! Jim Eddins
! 
! 
! 
[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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Michael Madigan
And you only see though thick cataracts.

--- Kristyne McDaniel [EMAIL PROTECTED] wrote:

 Ed,
 
  Your thinking is being clouded by these wacky
 shades of grey  
  concepts. Things make much more sense when you
 only think in these  
  black-and-white notions.
 
 That must be why Ann Coulter is always in a short
 black dress exposing lots
 of pasty-colored white skin. Her fans not only think
 in black and white --
 those are the only colors they can see!
 
 -- Kris
 http://www.mcstyles.com
 
 
 
 ___
 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
 ** 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.
 


Hezbollah Human Shields  http://www.cafepress.com/rightwingmike/1688255
Right Wing Stuff at http://www.cafepress.com/rightwingmike
Horse Racing Photos at http://www.HorseRacingPix.com


___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Kristyne McDaniel
Bob,

 You have just articulated a plan I can actually respect as a
 potentially viable alternative to what we've done that actually makes
 tactical and strategic sense on numerous levels that the standard
 shrill critiques from the black helicopter crowd do not. My hat is off
 to you and I thank you.

Unfortunately, what we need now is a plan that starts from today and goes
forward. We don't have a time machine so we can go back to 9/12 and get a
do-over.

Kristyne McDaniel
www.shamrocktrails.com, www.mctyles.com, www.emryldlife.com



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Jean Laeremans

On 7/31/06, Kristyne McDaniel [EMAIL PROTECTED] wrote:

Her fans not only think in black and white --
those are the only colors they can see!



Kris,

tsss

http://www.highlightskids.com/Science/ScienceQuestions/h1sciQbwColors.asp

A+
jml


___
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
** 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: [NF] Microsoft to charge for Office Betas

2006-07-31 Thread Ted Roche

On 7/31/06, Dave Crozier [EMAIL PROTECTED] wrote:

Well now you have to pay in order to pick the bugs out of the new M$ Beta
software



I don't do Microsoft Betas any more, but in the nineties a whole slew
of FoxPro folks devoted hundreds of hours to backing up, installing,
configured, testing, documenting, reporting and advocating for bugs to
be fixed in FoxPro. It made for an incredibly good product, worthy of
version Dot-Zero status and ready to go into production the day it
was released. FoxPro teams were patient and good sports about the
whole thing, and knocked themselves out to deliver a great product,
which they did, time after time. THAT was beta-testing.

Microsoft public betas are nothing more than a public showing of
what they are going to foist on their customers, with a chance for the
marketeers to develop answers to the most frequency voiced complaints.

I can't imagine paying for the privilege.

--
Ted Roche
Ted Roche  Associates, LLC
http://www.tedroche.com


___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
So, what are the 'real issues'?  List what you think are the Top five
'real issues' and I'll have a go at it.

V/R
 
//SIGNED//
Stephen S. Wolfe, GS-11, DAF
Comm (813) 827-9994  DSN 651-9994
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Ed Leafe
Sent: Monday, July 31, 2006 8:10 AM
To: ProFox Email List
Subject: Re: [OT] The savages are breaking into the UN offices in Beirut

On Jul 31, 2006, at 4:25 AM, Dominic Burford wrote:

 The simple minded folk on this list who defend Israel do
 so using the antiquated straw man analogy that we must all be extreme
 liberals who would love to hug a terrorist.  That would be funny if it
 were not so pathetic.  Hiding behind such a straw man is an excuse so
 that they do not have to come out and debate the real issues.  They
 cower and hide hehind their whimsical caricatures instead, and their
 infantile little tag lines such as 'Liberalism is a mental disorder'
 (yawn).

And yet so many people here continue to feel the need to engage
them.

The only people who haven't already figured out their lack of  
substance aren't going to get it because others keep trying to  
point it out.

-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com





[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
** 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: [OT] Any Southwest fliers out there?

2006-07-31 Thread stephen . russell
 From: Ed Leafe [EMAIL PROTECTED]
 
 How To Change A Southwest Airlines Boarding Pass From a C or B to  
 and A!
 
 ( -or- http://tinyurl.com/ztkkm )

I fly the other direction Northwest.  What does an A boarding pass get
you?  And if they catch your in a forgery, can the feds take you away?  



___
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
** 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: [NF] Microsoft to charge for Office Betas

2006-07-31 Thread Michael Babcock

Ted Roche wrote:

I can't imagine paying for the privilege.


Perhaps there will be a backlash large enough that they'll recant.

--

Thanks,
--Michael



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Ed Leafe

On Jul 31, 2006, at 2:25 PM, Wolfe Stephen S GS-11 6 MDSS/SGSI wrote:


So, what are the 'real issues'?  List what you think are the Top five
'real issues' and I'll have a go at it.


	The problem is not the choice of issue. The problem is responding to  
vacuous drivel, no matter what the issue may be.


-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com





___
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
** 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: Design question

2006-07-31 Thread Ed Leafe

On Jul 31, 2006, at 1:58 PM, Michael Babcock wrote:

And by that you mean to be very interchangable and not get snagged  
on the different layers from which it may be called, if I  
understand that principle correctly.  An  example for folks not  
familiar with this would be where you program something using  
objects on a page, then later put them into some other container on  
a different level (say a page within a pageframe).  If you've  
designed to the interface, everything should still function just  
fine instead of not being able to find the references correctly.   
That's another reason why it's good to put the code in the highest  
level (in this case, the custom form methods) instead of the  
button.clicks.  Also allows for easier re-use if you really need  
it:  like instantiating the form and calling it's custom object --  
that's a heck of a lot easier than instantiating the form and  
having to drive down 'n' levels into the object hierarchy to some  
button's click event!


Just trying to help the lurkers...correct me if wrong.


	That's one of the main reasons for not hard-coding paths to objects.  
But no matter how you reference an object, you should always program  
to interface, not to implementation.


	The example I gave back when I used to give this topic at  
conferences was a light switch in a room. In your app, you want to  
control the lighting by turning the switch on and off. Now let's  
imagine the switch is a typical mechanical switch with contacts that  
are opened and closed when you flip the toggle. In code, you could  
write oSwitch.contact1.Closed = .T., or oSwitch.TurnOn(), and either  
code would work great. However, if at a later date the switch was  
replaced by a mercury switch, or an electronic switch, or a dimmer  
switch, the first example of code would probably fail, since it was  
written to use an implementation detail of a particular switch,  
instead of the public interface all switches are designed to use. By  
coding to the public interface, such as the TurnOn() method, the code  
will work no matter how the switch works internally.


-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com





___
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
** 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.


[OT] Back alley liposuction

2006-07-31 Thread Michael Madigan

http://www.breitbart.com/news/2006/07/31/D8J726PO0.html

Hezbollah Human Shields  http://www.cafepress.com/rightwingmike/1688255
Right Wing Stuff at http://www.cafepress.com/rightwingmike
Horse Racing Photos at http://www.HorseRacingPix.com


___
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
** 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: Design question

2006-07-31 Thread Michael Babcock

Ed Leafe wrote:
The example I gave back when I used to give this topic at 
conferences was a light switch in a room. In your app, you want to 
control the lighting by turning the switch on and off. Now let's 
imagine the switch is a typical mechanical switch with contacts that 
are opened and closed when you flip the toggle. In code, you could 
write oSwitch.contact1.Closed = .T., or oSwitch.TurnOn(), and either 
code would work great. However, if at a later date the switch was 
replaced by a mercury switch, or an electronic switch, or a dimmer 
switch, the first example of code would probably fail, since it was 
written to use an implementation detail of a particular switch, 
instead of the public interface all switches are designed to use. By 
coding to the public interface, such as the TurnOn() method, the code 
will work no matter how the switch works internally.


I meant to reference that example too in my session at FoxForward!  I 
recall you saying that...I think it was in the Profox archives from 2001?


--

Thanks,
--Michael



___
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
** 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: [OT] Any Southwest fliers out there?

2006-07-31 Thread stephen . russell
 From: David Crooks [EMAIL PROTECTED]

 I fly the other direction Northwest.  What does an A boarding pass
 get you?  And if 
 they catch your in a forgery, can the feds take you away?  
 
 In their cattle call you get to go first if you have an A boarding
 pass.  Some of the comments to the blog state that if you change your
 boarding pass then it is invalid and yes maybe they will take you
 away...  Also, Southwest is changing their boarding procedures to have
 assigned seating and that will get rid of the A, B, or C boarding
 passes.

Thanks.  I know that when they call for boarding of the back of the
plane in a NWA flight some people have to go on just to get their
luggage set, I mean they can't be bothered to told they are not suposed
to be on in an orderly manner.  

Was it luck of the draw on who gets the A, B, C or was it in seniority
like the # of miles you have flown? 
 



___
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
** 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: [OT] Any Southwest fliers out there?

2006-07-31 Thread john harvey
Stepehen,

Just tell them anything, and it's ok to forge someone else's name too. Can I
have your laptop?G

John Harvey

www.cyber-posse.com

www.johnharveysheriff.com

http://memphiscrime.blogspot.com

www.votinginmemphis.com

 


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of [EMAIL PROTECTED]
Sent: Monday, July 31, 2006 2:04 PM
To: ProFox Email List
Subject: RE: [OT] Any Southwest fliers out there?

 From: David Crooks [EMAIL PROTECTED]

 I fly the other direction Northwest.  What does an A boarding pass
 get you?  And if 
 they catch your in a forgery, can the feds take you away?  
 
 In their cattle call you get to go first if you have an A boarding
 pass.  Some of the comments to the blog state that if you change your
 boarding pass then it is invalid and yes maybe they will take you
 away...  Also, Southwest is changing their boarding procedures to have
 assigned seating and that will get rid of the A, B, or C boarding
 passes.

Thanks.  I know that when they call for boarding of the back of the
plane in a NWA flight some people have to go on just to get their
luggage set, I mean they can't be bothered to told they are not suposed
to be on in an orderly manner.  

Was it luck of the draw on who gets the A, B, C or was it in seniority
like the # of miles you have flown? 
 



[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
** 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: [OT] Any Southwest fliers out there?

2006-07-31 Thread stephen . russell
 From: Michael Madigan [EMAIL PROTECTED]

 Airline security is a joke

 --- Ed Leafe [EMAIL PROTECTED] wrote:

Why would you say that?

This is the company spotting a forgery on where your sitting on the
plane, no SWA doesn't sell a seat assignment just an open spot.

When you get your ticket scanned it shows that your supposed to be on
that flight, and not on a different one.  You are just forging when
your allowed onto the aircraft that's all.  I am just guessing that
it's a felony to alter a boarding pass that your printing at home.



___
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
** 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: a collection issue

2006-07-31 Thread Sietse Wijnker
Hi Vassilis
To directly access an item inside a collection for filling a property, you
can use collection[index] or collection(index) (like it's an array)

This is also handy when trying to access a value in the watch window
As you've probably seen, debugging values inside a collection in the
debugger using the item() is impossible. Accessing the collection as if it's
an array makes it possible.

BTW, Changing the value of the collection-item is impossible, even when
using the array-like approach. So oCol(2) = test doesn't work.

Regards,
Sietse Wijnker


 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of Vassilis Aggelakos
 Sent: maandag 31 juli 2006 14:46
 To: [EMAIL PROTECTED]
 Subject: Re: a collection issue
 
 Thanks Mal,
 
 I use collections in my apps very frequently. Usually I have 
 a simple ColItem class that looks like this:
 
 DEFINE CLASS myColItem AS Custom
 
  Key = .null.
  Value = .null.
  TagInfo = .null.
  oChild = .null.
 
 ENDDEFINE
 
 I add this object to my collection and everything is fine 
 when I want to modify a value but playing now with 
 collections I thought that I have missed something obvious.
 
 Thank you very much
 
 -V



___
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
** 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: Design question

2006-07-31 Thread Ed Leafe

On Jul 31, 2006, at 3:00 PM, Michael Babcock wrote:

I meant to reference that example too in my session at FoxForward!   
I recall you saying that...I think it was in the Profox archives  
from 2001?


	I don't know. I know I first started using that example back in the  
mid-90s when I was teaching for Flash, so it's very possible.


-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com





___
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
** 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: [NF] Microsoft to charge for Office Betas

2006-07-31 Thread Whil Hentzen (Pro*)

Michael Babcock wrote:

Ted Roche wrote:

I can't imagine paying for the privilege.


Perhaps there will be a backlash large enough that they'll recant.


Nah, there'll be enough lemmings out there who will think it'll be cool 
to be 'beta testing'. They can brag to their golf buddies or try to pick 
up chicks in bars with their new line.


Even if there was a backlash, do you really think that the MSFT muckity 
mucks and marketroids would care? They never have before.


Whil




___
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
** 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: [NF] Microsoft to charge for Office Betas

2006-07-31 Thread Michael Babcock

Whil Hentzen (Pro*) wrote:
Nah, there'll be enough lemmings out there who will think it'll be 
cool to be 'beta testing'. They can brag to their golf buddies or try 
to pick up chicks in bars with their new line.

Hey, does that work (picking up chicks with those geeky lines)?  ;-)


Even if there was a backlash, do you really think that the MSFT 
muckity mucks and marketroids would care? They never have before.
Now I seem to recall some things in the past (and not-so-distant at 
that) where M$ backed off and/or changed their line regarding something 
that got heavy backlash.  Think of all those things that never came to 
beHailstorm anyone?


--

Thanks,
--Michael



___
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
** 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: Design question

2006-07-31 Thread Michael Babcock

Ed Leafe wrote:

On Jul 31, 2006, at 3:00 PM, Michael Babcock wrote:

I meant to reference that example too in my session at FoxForward!  I 
recall you saying that...I think it was in the Profox archives from 
2001?


I don't know. I know I first started using that example back in 
the mid-90s when I was teaching for Flash, so it's very possible.


Come to think of it, it was perhaps from some paper you wrote...a 300 or 
500 level paper comes to mind?  Oh wellthe lesson stuck!


--

Thanks,
--Michael



___
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
** 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.


[OT] The Zionists/NeoCons have infiltrated even Arab TV

2006-07-31 Thread Bob Calco
 http://switch3.castup.net/cunet/gm.asp?ai=214ar=1050wmvak=null
http://switch3.castup.net/cunet/gm.asp?ai=214ar=1050wmvak=null
 
---
 
Enjoy
 
- Bob


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---


___
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
** 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.


Floating Command Buttons

2006-07-31 Thread Eurico_EZ

Hi Tracy

My bad. I am thinking of a picture with the buttons, floating over
the grid that drops to next row everytime a row is added.
But still you can click on the buttons and execute something.

Eurico.



___
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
** 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: [OT] Any Southwest fliers out there?

2006-07-31 Thread Jerry Wolper
 Was it luck of the draw on who gets the A, B, C or was it in seniority
 like the # of miles you have flown? 

I believe (never having flown Southwest) that it's in order of check-
in.

-Jerry Wolper
 [EMAIL PROTECTED]


___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Stephen the Cook
petetheisen  wrote:
 
 I would have sent my wife and for God's sake my children to safety
 should I have chosen to resist. 

In their culture it's good to give your life for the cause.  



Stephen Russell
DBA / Operations Developer

Memphis TN 38115
901.246-0159

http://spaces.msn.com/members/srussell/

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/404 - Release Date: 7/31/2006
 



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Stephen the Cook
petetheisen  wrote:
 Dominic Burford wrote:
  hugging terrorists, hating America and hating Israel
 
 These are complex issues
 
 Hi Dominic!
 
 The issues in fact are *very* simple. It is the straw man argument to
 paint them as having nuances or whatever. 

Wow.  Why not call Condi and tell her what is really going on.  She will
just have you relocate and fix the problem.  It's really easy! 



Stephen Russell
DBA / Operations Developer

Memphis TN 38115
901.246-0159

http://spaces.msn.com/members/srussell/

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/404 - Release Date: 7/31/2006
 



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Stephen the Cook
Dominic Burford  wrote:

 And Israel has responded with an over the top display of military
 power that has just recently seen 37 children killed.  They have also
 bombed the exit roads so that civilians cannot escape, they have
 bombed urban areas where civialians live, including hospitals.   

I thought that Israel bombed the supply routes for new ammo and or weapons
coming in.  
 
 The straw man is to paint this as a simple issue, and call people who
 disagree with you as terrorist loving liberals. 

Did Israel tell the world they won't negotiate with terrorists?  Yes.  Did
they push that message way to far this time?  Hell yeah.  Has this crap been
going on since Abraham?  Pretty much.  Will it change in our lifetime?  Only
time will tell.

Stephen Russell
DBA / Operations Developer

Memphis TN 38115
901.246-0159

http://spaces.msn.com/members/srussell/

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/404 - Release Date: 7/31/2006
 



___
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
** 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: [OT] The savages are breaking into the UN offices in Beirut

2006-07-31 Thread Bill Arnold

Here's my list of what I think should happen tomorrow:

1. Give every neocon in Washington a pink slip and a court date for the
murder and destruction they've wrought in Iraq; the debt they've
incurred the American public, and the loss of respect for America
throughout the world.

2. Bust up media conglomerates with much hardened anti-trust laws

3. Require news services to give equal time/coverage to opposing
points of view

4. Put America on an even-handed footing with Israel. No more taxpayer
funding, no more arms and no more special treatment then we give any
other like-sized country. Promote a combined democracy approach and/or
anything else that might work, but the time has come for that country to
stand on it's own feet and reconcile it's own conflicts.

5. Apologize to the Arabic/Muslim world for having shown them so much
disrespect for so long.

6. Withdraw our military from the ME immediately. It's a lost cause and
any further military involvement will only make that very bad situation
worse. Immediately switch to the UN as the basis to carry on political
negotiations with the countries of the ME.

7. Strengthen the UN. With a strong American commitment, it can serve
it's purpose. It's been hobbled because it lacks that commitment. #1
issue is wmd disarmament.

8. Use our resources and leadership to contribute our fair share to
relieving humanitarian disasters in the world. It's righteousness and
the higher qualities that man aspires to, not guns, that minimizes
terrorism. 

9. Strengthen Interpol and UN managed police services to counter
remaining terrorism. 

10. Demonstrate how life, liberty and the pursuit of happiness works in
the technology age by dismantling all trappings of Big Brother; insure
technology works for us and never against us.

11. Institute massive building projects here and in space to challenge
people and give them direction.

12. Fund and encourage an Internet - TV merger and the use of this
facility to spread education through the world.

13. Encourage international travel in every way possible

14. Force the legal system to give everyone equal access to the law.

15. Solve our energy problems by calling on all engineers to put a
Herculean effort into the task


Bill 




___
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
** 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.


  1   2   >