i making a program that will sort or index the table in foxpro, i use sql code to generate the code in visual basic 6.0 but it has always an error.. i'm using ado data control, and here are my codes..
Adodc1.ConnectionString = "Provider=VFPOLEDB.1;Data Source=G:Documents and SettingsDP2205DesktopDataEnvironment;Password="";Collating Sequence=MACHINE" Adodc1.RecordSource = " SELECT Books.book_id, Books.title, Books.topic_id, Books.copyright_year, " _ & " Books.isbn_number, Books.publisher_name, Books.purchase_price," _ & " Books.covertype, Books.date_purchased, Books.pages, Books.notes" _ & " FROM books!books" _ & " ORDER BY copyright_year DESC" Adodc1.Refresh Set DataGrid1.DataSource = Adodc1
please help me get through with it,,hehe
i hope for your replies,,
July 29, 2011 9:02 AM
March 31, 2012 7:40 PM