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: Error in UPDATENAMELIST
Thread ID: 373584 Message ID: 373585 # Views: 41 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, March 23, 2013 6:43:52 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/

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