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(9)
Thread ID: 373516 Message ID: 373518 # Views: 30 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 9:04:34 PM         
   


> > hello experts
> >
> >
> >
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 order by AccHead"
> > lodo.CursorFill()
> > 

> >
> > it's work ok
> >
> > now i want to change order (my mysql table have order AccCode & AccHead)
> > to AccCode
> >
> > how...
> > thanks in advance
>
>
> Index the Cursor
>
> -----------------
> 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.

sele cInfo_SQL
index on AccCode into cInfoHead


like this, it's doesn't affect my TableUpdate(.t.,.t.)

ENTIRE THREAD

mysql(9) Posted by prasanna kunder @ 3/22/2013 8:44:47 PM
RE: mysql(9) Posted by Borislav Borissov @ 3/22/2013 8:58:35 PM
RE: mysql(9) Posted by prasanna kunder @ 3/22/2013 9:04:34 PM
RE: mysql(9) Posted by Borislav Borissov @ 3/22/2013 9:26:03 PM
RE: mysql(9) Posted by Tamar Granor @ 3/22/2013 9:14:04 PM
RE: mysql(9) Posted by prasanna kunder @ 3/22/2013 9:16:06 PM
RE: mysql(9) Posted by Borislav Borissov @ 3/22/2013 9:29:26 PM
RE: mysql(9) Posted by Rod G Paddock @ 3/22/2013 10:30:55 PM