I've no word for this ! .....
On Fri, Jul 4, 2014 at 9:46 AM, Keith Medcalf <kmedc...@dessus.com> wrote: > > The spacing and indentation are atrocious? > > >-----Original Message----- > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > >boun...@sqlite.org] On Behalf Of Micka > >Sent: Friday, 4 July, 2014 01:29 > >To: General Discussion of SQLite Database > >Subject: [sqlite] Error xBestIndex returned an invalid plan > > > >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 > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users