Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ciprian Zaharia
  Where is Ciprian Zaharia?
 Brossard
 Canada
 Ciprian Zaharia
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: Concatenation in a CA
Thread ID: 112255 Message ID: 112285 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Classes and Objects
Date: Tuesday, November 07, 2006 2:57:29 AM         
   


> > > > > 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)

> > > >
> > > > Hi Ken
> > > >
> > > > I played a bit with CA and I tested your example with 2 different connections.One with ADO data type and a ACCESS like database is not working.The second one with a connection to a VFP database with Native data type and with exactly the same structure like before is working perfectly.I don't know what kind of data type you use but I wonder if is not some kind of limitation.
> > > >
> > > > Ciprian Zaharia
> > > >
> > > > Fox4Ever

> > >
> > > Ciprian,
> > >
> > > Thanks for the quick reply. I am trying to do this with ODBC and ADO type CA's. I am currently using a VFP backend, but I will be accessing it over the Internet via VPN and I will shortly be upsizing that database to a SQL backend. The native CA will work for the short term, but I will have to change to ODBC or ADO anyway. Best to try and get the thing to work now.
> > >
> > >
> > > PS, Where is Brossard?
> > >
> > > Ken
> > > You shall know the truth - and the truth shall set you free. (John 8:33)

> >
> > I used CA on a small scale because is providing a fast way to access almost everything but
> > sometimes is tricky and at least for me not very well documented.
> > It was very useful when I needed to access Simply Accounting Database.
> > Brossard is 5 km south of Montreal
> >
> > Ciprian Zaharia
> >
> > Fox4Ever

>
> Ciprian,
>
> This is my first real venture into CA's - as I said, I have been using SPT all along. Thought it was time to learn about CA's. I have also used SPT to handle my Simply Accounting database too. You are right however - CA's aren't all that well documented. The best info I could find on them came from Bernard's excellent set of articles, in the Artlciles page of this site. Unfortuately, I believe that I am getting outside the scope of Bernards "Simple CA Tutorials."
>
> I thought that Brossard might have been in Quebec.
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)


Beside other things I'm taking care of an old FPD 26 system which is connected with Simply Accounting with a "Bridge" written in Java. Unfortunately I don't know two much Java but I still think in this place is like using an elephant to kill a mouse.Anyway at some point something in Simply Accounting database make the Java program to stop and the easiest way to correct that it was by using "CA".Today I played a bit with Data Explorer.Try to make a connection there to Simply Accounting and after that drag and drop a table from there to a VFP form.The result is the best marketing for Fox.

Ciprian Zaharia
Fox4Ever

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