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: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: mysql(8)
Thread ID: 373505 Message ID: 373510 # Views: 40 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 7:54:50 PM         
   


> > hello experts
> >
> > this are the properties i am using for CA - MySql
> >
> >
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" 

> >
> >
> > anything i am missing
> > edited
> > another question
> >
> > we use lodo.UPDATABLEFIELDLIST properties
> > to update specified filed, if we want all field's in cursor to update
> > then what should be the properties
> > should i include all fields in the list
> >
> > thanks again
>
>
> Yes, you should list ALL fields in both properties UPDATABLEFIELDLIST and UPDATENAMELIST.
>
> BTW why all main properties of the CA are set AFTER CursorFill()?
>
> -----------------
> Borislav Borissov
>
> Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> The only thing normal about database guys is their tables.

sorry
this will end of CA
> > lodo.CursorFill()

if i got more then 50 fields , then ...
should i list all
any short method
(i want include all fields by default)

ENTIRE THREAD

mysql(8) Posted by prasanna kunder @ 3/22/2013 6:17:19 PM
RE: mysql(8) Posted by Borislav Borissov @ 3/22/2013 7:43:22 PM
RE: mysql(8) Posted by prasanna kunder @ 3/22/2013 7:54:50 PM
RE: mysql(8) Posted by Borislav Borissov @ 3/22/2013 8:25:34 PM
RE: mysql(8) Posted by prasanna kunder @ 3/22/2013 7:54:17 PM
RE: mysql(8) Posted by tushar @ 3/23/2013 5:15:59 AM
RE: mysql(8) Posted by prasanna kunder @ 3/23/2013 7:14:32 AM
RE: mysql(8) Posted by tushar @ 3/23/2013 8:52:14 AM