Hi, I wanted to know what could be wrong with :
int vt_best_index(sqlite3_vtab *p_svt, sqlite3_index_info *p_info){
sVTAB* p_vt = (sVTAB*)p_svt;
int i;
printf("vt_best_index %d\n", p_info->nConstraint);
p_info->idxNum=0;
if(p_info->nConstraint!=0){
p_info->idxNum=p_info->aConstraint[0].iColumn;
p_info->idxStr=p_vt->acNameTab;
printf("best index constraint column %d\n", p_info->aConstraint[0].iColumn);
for(i=0;i<p_info->nConstraint;i++){
p_info->aConstraintUsage[i].argvIndex=(1+i);
}
}
if(p_info->nOrderBy==0){
p_info->aOrderBy=NULL;
}
return SQLITE_OK;
}
thx you very much ^^
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
