index

[zeldaxp]

I have problem with dbase & foxpro.
I want connect dbase with asp & foxpro with asp.
I don't use file idx for foxpro & ndx for dbase.
I use foxpro 2.6 & dbase version 7.
I try Applo software but it run slow.
can I use file idx or ndx for asp with another way, because with idx or ndx, i can run sql fast in asp.
foxpro & dbase use shared.

my code(asp use foxpro):
<%

dim con, rs, sql, keyword

keyword = trim(request(&quot;keyword&quot)
set con = Server.CreateObject(&quot;ADODB.Connection&quot

Con.ConnectionString = &quot;Provider=MSDASQL.1;Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;&quot; _
& &quot;SourceDB=f:\;&quot; _
& &quot;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;&quot; _
& &quot;Collate=Machine;Null=Yes;Deleted=Yes;&quot;

con.open
set rs = Server.CreateObject(&quot;ADODB.RecordSet&quot

sql = &quot;select name, desc from master where code='&quot;& keyword & &quot;'&quot;

rs.open sql,con
%>

thanks for attention.

 

[Guest_imported]

It is not possible to use external Indexes created using

INDEX ON .....

in SQL queries. You must create Structural Indexes for this. Such indexes are created by marking a field Ascending or Descending in CREATE TABLE or MODIFY STRUCTURE. SQL queries are able to use such indexes by default.

Thanks

S P Mall