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: mysql(7)
Thread ID: 373378 Message ID: 373378 # Views: 52 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, March 21, 2013 7:58:37 PM         
   


Hi experts

i am using

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 = "cInfo_SQL"
lodo.SelectCmd="select * from Info"
lodo.CursorFill()

lodo.TABLES='InFo'
lodo.KEYFIELDLIST='IdInfo'
lodo.UPDATABLEFIELDLIST='AccCode,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" 

now i want open another table in same database
so i can use like this

lodo.alias = "cCustomer"
lodo.SelectCmd="select * from Customer"
lodo.CursorFill()
....

then i can use both alias so i can make TABLEUPDATE(.T.,.T.)

i am new in mysql, CA

thanks in advance

ENTIRE THREAD

mysql(7) Posted by prasanna kunder @ 3/21/2013 7:58:37 PM
RE: mysql(7) Posted by Stefan Wuebbe @ 3/21/2013 11:51:03 PM
RE: mysql(7) Posted by prasanna kunder @ 3/22/2013 6:43:14 AM
RE: mysql(7) Posted by prasanna kunder @ 3/22/2013 6:50:40 AM
RE: mysql(7) Posted by Stefan Wuebbe @ 3/22/2013 7:26:13 AM
RE: mysql(7) Posted by prasanna kunder @ 3/22/2013 3:03:29 PM
RE: mysql(7) Posted by Stefan Wuebbe @ 3/22/2013 4:00:32 PM
RE: mysql(7) Posted by prasanna kunder @ 3/22/2013 5:36:11 PM
RE: mysql(7) Posted by Om Rajan @ 3/22/2013 7:50:28 PM