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
 Tags
Subject: Error in UPDATENAMELIST
Thread ID: 373584 Message ID: 373584 # Views: 35 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, March 23, 2013 6:33:48 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



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