Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: Concatenation in a CA
Thread ID: 112255 Message ID: 112390 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Classes and Objects
Date: Wednesday, November 08, 2006 5:15:09 AM         
   


>
> In my SPT data classes, all I need do is tell the class what kind of backend I am using and it builds the SELECT using the correct syntax all by itself (check out Andy's article on Class Based Data Management on his website - what I do is based on that article) so I want to do the same sort of thing using CA's. Obviously, having an ALLTRIM() in the query will not work for me - chalk it up to old age.
>
>

Hey Ken

You can use the same method code with the CA's as well. Basically you use your code to construct the "SelectCmd" and then set the property of the CA.SelectCmd = "Your new modified language specific select". You will need to do a CursorFill() after this since the selectd fields have changed.

ENTIRE THREAD

Concatenation in a CA Posted by Ken Murphy @ 11/6/2006 6:37:13 PM
RE: Concatenation in a CA Posted by Ciprian Zaharia @ 11/6/2006 10:22:57 PM
RE: Concatenation in a CA Posted by Ken Murphy @ 11/6/2006 11:34:48 PM
RE: Concatenation in a CA Posted by Ciprian Zaharia @ 11/6/2006 11:54:14 PM
RE: Concatenation in a CA Posted by Ken Murphy @ 11/7/2006 1:51:19 AM
RE: Concatenation in a CA Posted by Ciprian Zaharia @ 11/7/2006 2:57:29 AM
RE: Concatenation in a CA Posted by Bernard Bout @ 11/7/2006 8:21:27 AM
RE: Concatenation in a CA Posted by Ken Murphy @ 11/7/2006 1:59:21 PM
RE: Concatenation in a CA Posted by Bernard Bout @ 11/8/2006 5:15:09 AM