Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: Concatenation in a CA
Thread ID: 112255 Message ID: 112255 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 Category: Classes and Objects
Date: Monday, November 06, 2006 6:37:13 PM         
   


I have this Lookup class that I am trying to create that uses a CA. (This is my first real attempt to play with CA's - in the past, I simply used SPT.) In SPT, I could easily create a cursor like:
TEXT TO lcSqlScript NOSHOW TEXTMERGE PRETEXT 15
   SELECT nSupporterId, 
      PADR(ALLTRIM(cTitle-([ ]+cFirstName)-([ ]+cMiddleName)-([ ]+cSurname)),40) AS cSupName
   FROM supporter
   ...
ENDTEXT
SQLEXEC(lnHndl,lcSqlScript,[ResultCursor])

When I ran this, I would get a cursor that contained two fields: nSupporterID and cSupName. I want to do the same thing in a CA so I create the SELECT statement using the same as above and modify the schema to show nSupporterID I, cSupName C(30) but it doesn't work. Obviously, I am doing something wrong. Any suggestions?

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

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