Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Gene Wirchenko
  Where is Gene Wirchenko?
 Kamloops
 Canada
 Gene Wirchenko
 To: Cecil Champenois
  Where is Cecil Champenois?
 Little Elm
 Texas - United States
 Cecil Champenois
 Tags
Subject: RE: Over-Killed Dupes in SQL Statement
Thread ID: 396048 Message ID: 396227 # Views: 29 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, January 23, 2014 7:58:52 PM         
   


[snip]

> But, I must ask "What difference does it make" to use m.dots or not? (Do I sound like Hillary when she was being interviewed by a congressional panel about Benghazi?

A reference to an identifier will be taken by VFP to refer to a column of that name in the current table over a memvar. Some people use "m." all over to avoid this problem.

   set talk off
   local identifier
   identifier="memvar"
   ? identifier     && prints "memvar"
   create cursor id (identifier c(10))
   insert into id (identifier) values ("cursor")
   ? identifier     && prints "cursor"
   use in id
   ? identifier     && prints "memvar"
   return


Sincerely,

Gene Wirchenko

ENTIRE THREAD

Over-Killed Dupes in SQL Statement Posted by Cecil Champenois @ 1/22/2014 2:29:01 PM
RE: Over-Killed Dupes in SQL Statement Posted by Tore Bleken @ 1/22/2014 3:04:05 PM
RE: Over-Killed Dupes in SQL Statement Posted by Jun Tangunan @ 1/23/2014 3:18:33 AM
RE: Over-Killed Dupes in SQL Statement Posted by Jun Tangunan @ 1/23/2014 3:18:39 AM
RE: Over-Killed Dupes in SQL Statement Posted by Cecil Champenois @ 1/23/2014 12:59:22 PM
RE: Over-Killed Dupes in SQL Statement Posted by Ali Koumaiha @ 1/23/2014 4:07:24 PM
RE: Over-Killed Dupes in SQL Statement Posted by Pete Sass @ 1/23/2014 4:07:46 PM
RE: Over-Killed Dupes in SQL Statement Posted by Cecil Champenois @ 1/23/2014 5:28:11 PM
RE: Over-Killed Dupes in SQL Statement Posted by Gene Wirchenko @ 1/23/2014 7:58:52 PM
RE: Over-Killed Dupes in SQL Statement Posted by Jun Tangunan @ 1/24/2014 12:05:00 AM
RE: Over-Killed Dupes in SQL Statement Posted by Anders Altberg @ 1/25/2014 1:31:47 AM
RE: Over-Killed Dupes in SQL Statement Posted by Christian Tabligan @ 1/25/2014 2:32:49 PM