Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Om Rajan
  Where is Om Rajan?
 Jalandhar
 India
 Om Rajan
 To: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 Tags
Subject: RE: mysql(7)
Thread ID: 373378 Message ID: 373509 # Views: 33 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 7:50:28 PM         
   


Hi Prasanna
check this link hopefully this will help you
http://www.redware.com/handbooks/vfpcursoradaptor/vfpcursoradaptor_cursoradaptor.html



> 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



Always Fox Ahead

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