Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 Tags
Subject: RE: CA Class
Thread ID: 373598 Message ID: 373609 # Views: 43 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Sunday, March 24, 2013 5:26:34 AM         
   


> >
> > What are the errors you get. Also, you need just one global connection. Do not create a connection for each CA.
> >
> > Regards
> > Tushar
> > http://weblogs.foxite.com/tushar/
>
>
> lodo = CreateObject("CursorAdapter")
> lodo.DataSourceType="ODBC"
> lodo.DataSource=SQLStringConnect("DRIVER={MySQL ODBC 5.2(w) Driver};SERVER=192.168.0.52;database=maxell_Data;uid=root;pwd=pmk007")
> lodo.alias = "c1"
> lodo.SelectCmd="select * from Customer_Detail"
> lodo.TABLES='customer_Detail'
> lodo.KEYFIELDLIST='idcustomer_detail'
> lodo.UPDATABLEFIELDLIST='AccCode,AccHead,UnderCode,GroupCode,FullCode'
> lodo.UPDATENAMELIST = "IdInFo InFo.IDInfo ,;
> 					   AccCode Info.AccCode,;
> 					   AccHead Info.AccHead,;
> 					   UnderCode Info.UnderCode,;
> 					   GroupCode Info.GroupCode,;
> 					   FullCode Info.FullCode" 

>
> lodo.CursorFill()
>
> now i want use same connection for another
>
> then how
> sorry sir i am new for this
> thanks again

lodo.CursorFill() is the command that gives error. What does AERROR give.

Regards
Tushar
http://weblogs.foxite.com/tushar/

ENTIRE THREAD

CA Class Posted by prasanna kunder @ 3/24/2013 4:31:52 AM
RE: CA Class Posted by tushar @ 3/24/2013 5:07:34 AM
RE: CA Class Posted by prasanna kunder @ 3/24/2013 5:14:17 AM
RE: CA Class Posted by tushar @ 3/24/2013 5:26:34 AM
RE: CA Class Posted by prasanna kunder @ 3/24/2013 5:34:34 AM
RE: CA Class Posted by tushar @ 3/24/2013 6:01:30 AM
RE: CA Class Posted by prasanna kunder @ 3/24/2013 5:31:56 PM