>>Hi All,
>>
>>Can someone please tell me whether the following query (using SQL pass-through) would take long time if the table grows into millions?
>>
>>=SQLExec(nMyHandle, "SELECT * FROM mytable WHERE 1=2", "mycursor")
>>
>>Actually what I want was the exact structure of back-end table and that is why I put a false WHERE clause.
>>
>>Or is there another way to get the table structure into array or cursor?
>>
>>Thanks for your time.
>>
>>Regards
>>Vijay
>
>
SQLCOLUMNS(nMyHandle,"mytable", "FOXPRO | NATIVE", "myresults")
Sorry, that gets you the structure, but not an empty cursor with the same structure.
Your above query should be as quick as your network.
Insanity: Doing the same thing over and over and expecting different results.