Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 To: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 Tags
Subject: RE: Error in UPDATENAMELIST
Thread ID: 373584 Message ID: 373586 # Views: 35 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, March 23, 2013 6:46:57 PM         
   


> > Hello experts
> >
> > i have error in
> >
> >
SET MULTILOCKS ON
> > PUBLIC lodo
> > 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 = "Cust_Details"
> > lodo.SelectCmd="select * from Customer_Detail"
> > lodo.CursorFill()
> > 
> > lodo.TABLES='Customer_Detail'
> > lodo.KEYFIELDLIST='IdCustomer_Detail'
> > lodo.UPDATABLEFIELDLIST='IDCUSTOMER_DETAIL,ACCCODE,ACCHEAD,SRNO,NAME,DESIG,lanmob' &&,CALLNO,SENDSMS'
> > lodo.UPDATENAMELIST = "IDCUSTOMER_DETAIL Customer_Detail.IDCUSTOMER_DETAIL,;
> > 					   ACCCODE Customer_Detail.ACCCODE,;
> > 					   ACCHEAD Customer_Detail.ACCHEAD,;
> > 					   SRNO Customer_Detail.SRNO,;
> > 					   NAME Customer_Detail.NAME,;
> > 					   DESIG Customer_Detail.DESIG,;
> > 					   lanmob Customer_Detail.lanmob" 

> >
> >
> > i got error , check snap
> >
> >
>
>
>
text to lodo.UPDATENAMELIST pretext 15 noshow
> IDCUSTOMER_DETAIL Customer_Detail.IDCUSTOMER_DETAIL,
> ACCCODE Customer_Detail.ACCCODE,
> ACCHEAD Customer_Detail.ACCHEAD,
> SRNO Customer_Detail.SRNO,
> NAME Customer_Detail.NAME,
> DESIG Customer_Detail.DESIG,
> lanmob Customer_Detail.lanmob 
> endtext
> 

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

thanks for quick response

sir but what is wrong with my code

pl.explain

thanks in advance

ENTIRE THREAD

Error in UPDATENAMELIST Posted by prasanna kunder @ 3/23/2013 6:33:48 PM
RE: Error in UPDATENAMELIST Posted by tushar @ 3/23/2013 6:43:52 PM
RE: Error in UPDATENAMELIST Posted by prasanna kunder @ 3/23/2013 6:46:57 PM
RE: Error in UPDATENAMELIST Posted by tushar @ 3/24/2013 4:40:36 AM
RE: Error in UPDATENAMELIST Posted by prasanna kunder @ 3/24/2013 4:42:37 AM
RE: Error in UPDATENAMELIST Posted by Anders Altberg @ 3/24/2013 12:04:35 PM