Hi Vince
In addition to what MB said, named parameters will prevent SQL
Injection. That is if a user (hacker) entered SQL into a textbox that
filled in cstring that person could do bad things to your SQL Server.
Mike Yearwood
Microsoft MVP - FoxPro 2008
Message: 2
Date: Wed, 10 Jun 2009 12
Hey all
I'm certain there was an article showing a new projector bulb that
was a flat card - with a ridiculously long life span. I think the link
was on ProFoxTech but I cannot find it.
Anybody remember?
Thanks
Mike Yearwood
___
Post Messages
Hiya Ted!
Long long time!
Nope - That's not it. The picture I saw was a very thin rectangular
card which was the projection material.
Mike Yearwood
Message: 8
Date: Fri, 29 May 2009 09:40:09 -0400
From: Ted Roche tedro...@gmail.com
Subject: Re: Projector - new bulb technology
To: profoxt
Mike Yearwood
Microsoft MVP 2008 - Visual FoxPro
Message: 8
Date: Wed, 22 Apr 2009 07:55:20 -0700
From: Matt Jarvis matt.jar...@kingrs.com
Subject: RE: position of item in a list
To: profoxt...@leafe.com
Message-ID:
3e2cccb1767f7d4aab5384dd8e54525104744...@exchmail1.kingrs.local
-1
On Thu, Apr 16, 2009 at 8:59 PM, Mike yearwood mike.yearw...@gmail.com
wrote:
From: Stephen Russell srussell...@gmail.com
Mike yearwood wrote:
Second Q here is if injection is impossible if you use params?
The answer to that is NO. ?Is it harder to achieve success in
injection attacks
Hi Bill
Look into parameterizing. That way you don't need to escape values and
you prevent sql injection attacks.
Message: 1
Date: Thu, 16 Apr 2009 10:55:50 -0400
From: W.N. Pew b...@cogeco.ca
Subject: String With Apostrophes, etc Into MySql
To: profoxt...@leafe.com
Message-ID:
-8859-1
On Thu, Apr 16, 2009 at 11:55 AM, MB Software Solutions General
Account mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Mike yearwood wrote:
Hi Bill
Look into parameterizing. That way you don't need to escape values and
you prevent sql injection attacks.
Excellent suggestion
Hi Richard
I have the version that ships with Visual Maxframe. Both it and the
one you're referring to have 4 such lines that all would benefit from
your change.
Mike Yearwood
Message: 2
Date: Tue, 7 Apr 2009 18:16:37 -0400
From: Richard Kaye rk...@artfact.com
Subject: genmenux bug
) will
be created?
You need to embed a config.fpw in the exe with the RESOURCE=OFF line
at least. It does not work as the first line of the first .prg ever.
Mike Yearwood
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com
[m.liLoop,1] + WITH ,
llFound = .T.
ENDIF
ENDFOR
IF m.llFound
*Drop the final comma
lcCmd = LEFT(m.lcCmd,LENC(m.lcCmd)-1)
lcCmd. ALL IN LOS
ENDIF
HTH
Mike Yearwood
Microsoft MVP 2008 - Visual FoxPro
Message: 2
Date: Wed, 25 Feb 2009 17:15:44
to puzzle through unreadable SQL.
I find it far better, (easier to read, easier to understand!!!, easy
enough to type), to use (as an example) Inv. and Lin. as aliases for
Invoice and LineItems. There is no reason to study the options.
Obvious beats obscure every time.
Mike Yearwood
Microsoft MVP
unlikely your code to prepare an XML
file is optimized and free from error. Those both amount to
performance problems, and may even result in bad data.
Mike Yearwood
Microsoft MVP 2008 - Visual FoxPro
___
Post Messages to: ProFox@leafe.com
Subscription
adverse.
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Mike yearwood
Sent: Thursday, 15 January 2009 4:00 AM
To: profoxt...@leafe.com
Subject: [NF] M$ is pushing ahead for performance
Message: 2
Date: Wed, 14 Jan 2009 08:08:38 +1030
Hi Garrett
I've respected her for many years! Ceil gave me the Tip of the Month
twice for FoxPro Advisor and wrote very nice things. My condolences to
her family.
Mike Yearwood
Microsoft MVP - Visual FoxPro 2008
6. Ceil Silver (Garrett Fitzgerald)
Message: 6
Date: Mon, 5 Jan 2009 09:56:06
Hi Joe
You should avoid using KEYBOARD at all costs. It really messes things
up while the user is typing. As Rick Schummer said you can use a
numeric return value. You can also pass an object reference for the
control to receive focus.
Mike Yearwood
Microsoft MVP 2008 - Visual FoxPro
modifications to MaxFrame and the app is doing fine.
Next thing will be to redo it web-based.
Mike Yearwood
Microsoft MVP 2008 - Visual FoxPro
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT
. Despite being told all over that it was not possible,
they can print things that small. They're pretty fast too. A
combination of one of these and one of Gil's HPs allows a small
business to do a lot of custom print jobs.
Mike Yearwood
Microsoft MVP 2008 - Visual FoxPro
6. RE: [NF] RE: Printer
to fill a cursor using APPEND FROM and it was
significantly and visibly faster.
It depends on the type of file of course.
Mike Yearwood
Message: 7
Date: Wed, 01 Oct 2008 23:00:56 -0400
From: Lew [EMAIL PROTECTED]
Subject: RE: Memory compaction/clean up
To: [EMAIL PROTECTED]
Message-ID: [EMAIL
Ummm Jack?
Disabling the mouse is like disabling the steering wheel in a car.
Find a way to let the user do what they do.
Mike Yearwood
Message: 8
Date: Wed, 1 Oct 2008 13:43:43 -0400
From: Jack Skelley [EMAIL PROTECTED]
Subject: RE: Disable Mouse When A Form Is Visible
To: [EMAIL
of the goods, there was no
apparently need for interviewing subjects.
Mike Yearwood
Message: 3
Date: Wed, 27 Aug 2008 14:42:37 -0500
From: John [EMAIL PROTECTED]
Subject: RE: Theft Retrieval software
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]@shelbynet.com
Content-Type: text/plain
of the goods, there was no
apparently need for interviewing subjects.
Mike Yearwood
Message: 3
Date: Wed, 27 Aug 2008 14:42:37 -0500
From: John [EMAIL PROTECTED]
Subject: RE: Theft Retrieval software
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]@shelbynet.com
Content-Type: text/plain
) and the final plus sign means one or more of those.
Mike Yearwood
___
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
Well, if you think it's necessary :)
TEXT TO m.lcSQL TEXTMERGE NOSHOW
SELECT ;
0 as nSelected, ;
m.ptCutOff AS dCutDate, ;
members.uid, ;
members.mkey, ;
members.surname ;
FROM ;
members
ENDTEXT
loRegex=CREATEOBJECT('vbscript.regexp')
on the
record you are trying to update, your best approach is to drop the
RECORD clause.
Mike Yearwood
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com
Hi Alan
I will respectfully disagree with those who will say use SET ENGINEBEHAVIOR 70.
Off the top of my head and not tested...
Select ;
PayTable.employeecode,
maxperiod.maxperiodcode as periodcode;
From paytable ;
INNER JOIN ;
(SELECT ;
employeecode, ;
Hi Garrett
That's cool getting the out. Could you not do everything from the
to the end of the line? Since you are calling regexp already, can
you remove the chr(10), chr(9), chr(13), leading spaces and ; all with
a single RegExp?
Thanks
Mike Yearwood
Message: 8
Date: Wed, 4 Jun 2008 11:30
reading left to right, eyes tracking
from one caption+field pair to the next.
Mike Yearwood
Message: 2
Date: Thu, 22 May 2008 13:08:43 -0400
From: Malcolm Greene [EMAIL PROTECTED]
Subject: [NF] How do you position your labels relative to their input
controls(left, right, on top
Hi Ajoy
Get genmenux. You can have it hide or show menu options based on user
security levels.
http://www.aksel.com/genmenux/
Mike Yearwood
Message: 1
Date: Sun, 11 May 2008 20:14:48 +0530
From: Ajoy Khaund [EMAIL PROTECTED]
Subject: vfp9 dynamic menu
To: [EMAIL PROTECTED]
Message-ID
')
loaValue = eval(this.aValue)
loaValue.Value=m.Parameter
loaValue.Top=m.ntop
loaValue.Visible=.T.
loaValue.Left=100
loaValue.Width=200
ntop=m.ntop+20
Endfor
Mike Yearwood
6. Re: What am I doing wrong? (James Roark)
Message: 6
Date: Tue, 06 May
right corner there should be an unblock button.
Click that, then apply. Worked for me.
Mike Yearwood
Message: 6
Date: Thu, 1 May 2008 14:03:34 -0500 (CDT)
From: William Sanders / EFG [EMAIL PROTECTED]
Subject: re: Update to Microsoft's VFP page: Fixed SP2 help file now
available
will be appreciated.
Mike Yearwood
From: Ed Leafe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 24 April 2008 15:40:21 o'clock (GMT) Europe/London
Subject: [ADMIN] Replying To Digests
Does anyone think it's time to filter out posts based on the presence
of 'ProFox Digest
Message: 10
Date: Thu, 24 Apr 2008 11:17:08 -0700
From: Kristyne McDaniel [EMAIL PROTECTED]
Subject: RE: [ADMIN] Replying To ProfoxTech Digest ;)
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Paul,
What is so hard with:
click reply
Hey guys
Excuse me if this is not an appropriate post, but I've got a recruiter
friend that has asked me if I know of anyone that knows Pocket PowerBuilder
(now called PocketBuilder). Knowing the wide range of database skills of the
members on this list, I promised to ask on his behalf. So, if
. Frankly I find it hard to imagine a situation where
the local exe could result in slower operation than a remote exe on a
server.
:)
Mike Yearwood
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
the initial import. Then I only update few records (and their indexes)
during the update and append processes. If you could do those commands
directly with the csv files, that might be pretty good.
Mike Yearwood
___
Post Messages to: ProFox@leafe.com
Subscription
Hi Paul
Mike yearwood wrote:
The third parameter was not in 2.6 (Checked in FPD 2.6 but not in FPW 2.6)
Quite right. 3rd parameter wasn't there, but seek() function was,
which is what I thought he was asking. I forgot to mention one thing I
used a lot. LOOKUP(). If you provide the 4th
Hey Stephen
Use the 3d Flying Objects screen saver in Windows XP (at least).
Style: Textured Flag. Specify your graphic as the texture.
Mike Yearwood
From: Wolfe, Stephen S Civ USAF AMC 6 MDSS/SGSI
[EMAIL PROTECTED]
Subject: [NF] Free or open license screensaver maker?
Anybody
Hey Joe
Check this out:
http://www.foxridgesoftware.com/Blogs/tabid/84/EntryID/10/Default.aspx
Mike Yearwood
Date: Thu, 27 Mar 2008 11:42:40 -0400
From: Joe Yoder [EMAIL PROTECTED]
Subject: Measuring short time periods in VFP
I have a server that is having problems relaying mail over
. But don't fault them. I know people
that use VFP today that still don't know that locate is slower than
seek.
;)
Mike Yearwood
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version
Hi Eurico
I have the following scenario, VFP9.2, Win Server 2003, VFP database.
In my program, EXE, I call...
Do (this.cMainMenu) \xxx\Menus\Main.mpr
Do (this.cAppMenu)\yyy\Menus\AppMenu.mpr
In my working environment it's as fast as it can be. In the serve is the
same.
SQL commands is incorrect. VFP SQL re-opens
the cursors in their own workareas so it can avoid any ORDER/SET
FILTER you've already put on the cursors.
Mike Yearwood
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman
on LAN tables?
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
On Tue, March 25, 2008 4:26 pm, Mike yearwood wrote:
Hi Mike
No. There is no such performance penalty. There may be a slight
benefit to using 1 line of code versus 4
Hi David
FoxPro never brings down the whole table. Although, if you have SET
DELETED ON and lots of deleted records, it may take time to skip over
those.
Mike Yearwood
Message: 4
Date: Mon, 24 Mar 2008 10:16:17 -0400
From: David Boatright [EMAIL PROTECTED]
Subject: Tables in the Data
optimized commands like GO TOP and GO BOTTOM with filters
and/or SET DELETED can take a long time to skip to the first matching
record in the filter, but still it is not reading the entire dbf or
cdx.
Mike Yearwood
___
Post Messages to: ProFox@leafe.com
Hi Mike
Message: 1
Date: Thu, 20 Mar 2008 10:29:45 -0400
From: MB Software Solutions General Account
[EMAIL PROTECTED]
Subject: Re: VFP SPT Canvassing Opinion
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Ajit Abraham wrote:
is not going to go haywire. That is too
restrictive a situation for my liking.
Mike Yearwood
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of MB Software Solutions General Account
Sent: 20 March 2008 20:03
To: ProFox Email List
Subject: Using RECNO in SELECT-SQL
/plain; charset=us-ascii
On Thu, Mar 20, 2008 at 12:14 PM, Mike yearwood [EMAIL PROTECTED]
wrote:
1 - NewSequentialID is sequential if SQL Server generates the ID.
That's because SQL Server apparently calls UuidCreateSequential on the
server. If I have a client generate a GUID using
Hi Ed
The UTMag is free, so there's no spending involved. I don't know how
much autonomy I'll have, but I'm not paid to be the editor. I'm doing
it on a voluntary basis. I thought not to mention that originally in
case it seemed like bragging, but now it is significant. It's not like
I'll lose
Hi Ed
Please. There will not be any magic information there that cannot be
found elsewhere. The issue is supporting a business with whom you have
a fundamental difference of philosophy. When FoxTalk went to sleaze
marketing, I stopped buying it. It had nothing to do with Fox; I still
Hi Graham
Just FYI, but you could use INSERT-SQL to do that bypassing the APPEND
BLANK, the SCATTER, the memory variable re-assignments and the GATHER
lines.
Message: 7
Date: Fri, 14 Mar 2008 15:04:46 -
From: Graham Brown \(CompSYS\) [EMAIL PROTECTED]
Subject: RE: Getting at Excel data
On Mar 14, 2008, at 10:17 AM, Mike yearwood wrote:
That's a silly argument. Innocent until proven guilty,
y'know? UT has
a long history upon which to make such a decision.
How come it seems I'm guilty by association?
I don't think anyone's said anything personally against you
for articles, but getting published is good for your career
and/or reputation.
If you want to do a regular column or have any ideas for articles at
this time, please email me at [EMAIL PROTECTED]
I'm looking forward to working with you all.
Mike Yearwood
8. Re: [NF] Programming skills (Michael Madigan)
Message: 8
Date: Wed, 12 Mar 2008 13:20:23 -0700 (PDT)
From: Michael Madigan [EMAIL PROTECTED]
Subject: Re: [NF] Programming skills
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
You left
the code
harder to follow.
select 1
do something
select 2
do somethingelse
Is meaningless
select Invoices
do something
select lineitems
do something else
has more meaning.
Mike Yearwood
Message: 2
Date: Tue, 11 Mar 2008 16:16:24 +0100
From: Allen [EMAIL PROTECTED]
Subject: RE: table names
Hey Lou
Here's a poem for you.
It's winter in Canada
And the gentle breezes blow
Seventy miles an hour
At twenty-five below.
Oh, how I love Canada
When the snow's up to your butt
You take a breath of winter
And your nose gets frozen shut.
Yes, the weather here is wonderful
So I guess I'll hang
Hi all
Environment: Windows Server 2003 and Windows XP wireless clients
running FoxPro loader exe.
I'm not sure of the exact terminology, so give me a break! :) I have a
mapped drive letter W: which is connected to \\server\somefolder.
somefolder needs most if not all rights for admin users,
Hi Dave
I've got such code too. :)
oWS = CREATEOBJECT(Wscript.Network)
oWS.MapNetworkDrive(W:,\\Server,.F.,username,password)
I'm just not comfortable with having the username+password on the
local machines. It would also be a problem to disconnect the drive if
a second instance of the app were
Hi Al
The network guy set it up as static IPs. It's strange because simply
clicking on the drive in Windows explorer re-establishes the
connection. Actually that makes me wonder if any of the WSH drive and
or file interrogation APIs would work.
We're using a loader/launcher to copy down the
Mike yearwood wrote:
How about login scripts? Is that possible with Server 2003? If so,
how?
Do you have to use drive letters? Is there a reason not to just use
\\server\share\mytable.dbf or whatever ?
I guess I don't have to use drive letters. Back in VFP3 I tried to
pack a table opened
, but not necessarily the
corresponding registration number.
HTH
Mike Yearwood
Fox Ridge Software
I have two tables, 1-to-many related. Parent table contains car information,
child table contains the registration numbers, with their date, as they
change.
Parent table fields:
Id, Serial, Model
Child
Hi Michael
I bought TurboFTP (www.turboftp.com) because it can compare local
files against remote files and upload only the changed files. Well
worth the 40 bucks, IMO.
Mike
Message: 2
Date: Fri, 29 Feb 2008 13:14:29 -0500
From: MB Software Solutions General Account
[EMAIL PROTECTED]
of you have had a customer (for independents, not in-house
developers) who were happy to pay for you to watch their people work for
a couple of days?
I estimated two days to do a review so I could quote on a redesign,
but did the quote after only one day. Was paid for the one day.
Mike
to get one of the newest HD capable
video cards.
http://www.digitalconnection.com/Support/cliffnotes_17.asp
HTH
Mike Yearwood
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version
did not hold a
formal beta, and those
who reported issues never received any feedback that the issues were being
looked at and fixed if
appropriate. This combination turned a lot of people off, and now we have to
live with the results,
which stinks.
Mike Yearwood
Hey Mike
PICNIC - it's easier to remember. Problem In Chair, Not In Computer. :)
Mike Yearwood
Message: 9
Date: Mon, 28 Jan 2008 22:53:19 -0500
From: Mike Wohlrab [EMAIL PROTECTED]
Subject: RE: [NF] Fingerprint scanner
To: [EMAIL PROTECTED]
Message-ID
to see what is faster). The resulting CDX will disappear when
you close the cursor,
so you have to create the index tags each time.
Hi Rick
I thought he meant to speed up the first view. Indexing it would only
speed up a second view.
Mike Yearwood
Hello all
I'm trying to print membership cards that are 2.25 high x 3.5 wide.
I've got an Epson CX3810 printer/scanner. It can feed and print on
these cards without any problem.
The Windows XP printer driver is limited to 3.5 x 3.5. I proved the
printer can do it regardless. So I emailed
Hi Matt
Date: Fri, 21 Dec 2007 10:17:48 -0800
From: Matthew Jarvis [EMAIL PROTECTED]
It's Friday and xmas approaches... let's have a bit of fun...
What's the whackiest thing you've ever had to do to just make it work
or solve a problem?
Well, I got a call from a client about a
Hi Paul
Message: 10
Date: Mon, 17 Dec 2007 13:27:51 +
From: Paul Newton [EMAIL PROTECTED]
Subject: To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Eurico
I'm going to do exactly what the he wants (he's the boss and the boss is
always
Hi Paul
I'm not about to be critical of my boss
Of course.
- he has (at least,
historically) good reasons for doing things the way he has
There is no good reason for keeping everything in one vcx. Everyone
I've ever asked said they didn't think of it or know any better. Even
Drew Speedie
For the Apple-iphiles in the audience. Hey! I should copyright that term. ;)
http://www.youtube.com/watch?v=rw2nkoGLhrE
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this
Hi Paul
--
Message: 8
Date: Fri, 30 Nov 2007 14:28:42 -0800
From: Paul McNett [EMAIL PROTECTED]
Subject: Re: Setting property value at runtime
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Paul McNett wrote:
Hi Joe
Message: 2
Date: Fri, 30 Nov 2007 20:36:44 -0500
From: Joe Yoder [EMAIL PROTECTED]
Subject: re: Execscript glitch?
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Thanks Gianni and Lew,
I guess that's one reason to use Execscript
Hi Ed
Date: Thu, 29 Nov 2007 09:48:29 -0500
From: Ed Leafe [EMAIL PROTECTED]
Subject: Re: [NF] Dabo Question
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
On Nov 29, 2007, at 9:40 AM, MB Software Solutions wrote:
Ok...could a Mac or
Hi Ed
I'm interested in Dabo. I've read it's for developing desktop apps.
What about developing an app that is both desktop and web?
Thanks
Mike
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
,guid,cbe94fe8-cf6b-4600-9a05-b23b0adff749.aspx
HTH
Mike Yearwood
___
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
2. VFP7: Scan challenge (David Crooks)
Message: 2
Date: Sun, 18 Nov 2007 10:03:53 -0500
From: David Crooks [EMAIL PROTECTED]
Subject: VFP7: Scan challenge
To: [EMAIL PROTECTED]
Message-ID:
[EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Another inherited app which
Hi Ted
Message: 8
Date: Wed, 24 Oct 2007 08:48:56 -0400
From: Ted Roche [EMAIL PROTECTED]
Subject: Re: [NF] Open source or proprietary: Which software model is
better for the consumer?
To: [EMAIL PROTECTED]
Message-ID:
[EMAIL PROTECTED]
Content-Type: text/plain;
Sorry - didn't edit the subject.
Message: 1
Date: Tue, 16 Oct 2007 14:59:47 -0700
From: kam [EMAIL PROTECTED]
Subject: VFP9 Error: database object is being used by someone else
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
This is
Message: 8
Date: Wed, 17 Oct 2007 13:16:40 +0100
From: Dave Crozier [EMAIL PROTECTED]
Subject: RE: ProfoxTech Digest, Vol 53, Issue 68
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Mike,
Am I missing something here or is my email getting
= 'SOMETHING'
In newer VFP SQL
SELECT * FROM TABLE1 ;
INNER JOIN TABLE2 ON TABLE2.FIELD1 = TABLE1.FIELD1 ;
WHERE TABLE1.FIELD2 = 'SOMETHING'
The issue of joining the tables is removed from the where clause - I
find this far easier to read and maintain.
Mike Yearwood
Message: 8
Date: Wed
Hi Paul
Re something you said in the TRY CATCH thread. I believe almost all
examples, including those that come with VFP are contrived. So
little is ready to be applied in the real world. In this case a field
mover is not something required in every app, so it's not too likely
their will be
Hi Rafael
Message: 8
Date: Tue, 2 Oct 2007 12:45:10 -0300
From: Rafael Copquin [EMAIL PROTECTED]
Subject: grid footers
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
I am building a complicated information system which involves creating a
Hi John
I've seen that before. I think it was back in VFP5. Only happened if I
opened the file with UNC
USE \\SERVER\PATH\file.dbf
I reported it and it was fixed in the next version/sp of VFP
3. Message: 3
Date: Tue, 25 Sep 2007 11:44:42 -0400
From: John J. Mihaljevic [EMAIL PROTECTED]
Hey all
I'm trying to monitor SQL Server backup and restore via SPT. I've made
an asynch connection and started the backup. Now what? :)
Thanks
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
Hi all
The next meeting of the Toronto Ontario FoxPro User's Group is
September 19th at the usual place.
Registration on my site is only for people planning to attend meetings
in Toronto.
http://www.foxridgesoftware.com/Home/TorontoOntarioFoxProUsersGroup/tabid/85/Default.aspx
Thanks
Message: 9
Date: Mon, 03 Sep 2007 17:42:54 -0400
From: Joe Yoder [EMAIL PROTECTED]
Subject: re: Unexplained behavior when attempting to write to a low
level file
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Sorry for bothering you
, 2007 9:15 AM, Mike yearwood wrote:
Message: 9
Date: Mon, 03 Sep 2007 17:42:54 -0400
From: Joe Yoder [EMAIL PROTECTED]
Subject: re: Unexplained behavior when attempting to write to a low
level file
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain
, the obvious
answer is, don't bring down more than 255 columns, but I need to
update every field back to the server, so any suggestions are greatly
appreciated-
Mike Yearwood
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com
Message: 5
Date: Mon, 13 Aug 2007 09:01:57 -0400
From: Rick Schummer [EMAIL PROTECTED]
Subject: RE: Tech Skills
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Hi Jeff,
Don't drop your card deck! ;^) I wonder how many (other than Whil)
Hi Mark
Date: Wed, 08 Aug 2007 12:28:19 +0100
From: Mark Stanton [EMAIL PROTECTED]
Subject: Re: Data Strategy
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Yes I follow a more C/S apprach where your only getting the data your
looking for
Hi Mark
Message: 2
Date: Wed, 08 Aug 2007 16:45:37 +0100
From: Mark Stanton [EMAIL PROTECTED]
Subject: Re: Data Strategy
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
In article [EMAIL PROTECTED], Mike yearwood wrote:
Unlike most every
Message: 2
Date: Wed, 08 Aug 2007 20:50:09 +0100
From: Mark Stanton [EMAIL PROTECTED]
Subject: Re: Data Strategy
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Hiya,
I don't use views anymore - they seem so outdated and limited,
Hehehe!
if you add access and
assigns to that property. Nothing you do with indexes will speed up
using the property. I NEVER use property references in any rushmore
commands.
Mike Yearwood
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http
Hi Pete
http://www.off-grid.net/2006/11/21/les-stroud-interview/
Message: 9
Date: Wed, 01 Aug 2007 11:55:00 -0500
From: Pete Theisen [EMAIL PROTECTED]
Subject: [NF] Green electric hardware
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Hi
Hiya Ted!
From: Ted Roche [EMAIL PROTECTED]
Subject: Re: Write ahead cache problems
To: [EMAIL PROTECTED]
Message-ID:
[EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
On 7/26/07, Mike yearwood [EMAIL PROTECTED] wrote:
However, I have a system based on Visual MaxFrame
Hi Allen
Message: 2
Date: Thu, 26 Jul 2007 12:39:31 +0200
From: Allen [EMAIL PROTECTED]
Subject: RE: Write ahead cache problems
To: [EMAIL PROTECTED]
Message-ID: [EMAIL PROTECTED]
Content-Type: text/plain; charset=windows-1250
Hi Paul
This is what I feared. Its not too good when two
Stephen
Look at the sample here.
http://www.datamodel.org/NormalizationRules.html
See how they broke company from member? Two entities. Salutations and
Occupations are entities. Lookup is a vague term describing some
artificial computing construct, completely different from Invoice or
Product.
Message: 5
Date: Wed, 25 Jul 2007 10:07:21 -0400
From: Derek Kalweit [EMAIL PROTECTED]
Subject: Re: [NF] New processors present problems, payoff
To: [EMAIL PROTECTED]
Message-ID:
[EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
I understand the police figure out which
Hi Jim
I'm 100% in agreement with you.
Bull!
Expected that response. g
Like I said, I've been down this roadg.
I explained this same issue to Drew Speedie long ago. He had been
doing the OTLT - One True Lookup Table for years and never wondered
about it. He agreed it was probably wrong,
1 - 100 of 166 matches
Mail list logo