Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Max. number of
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
ActiveVFP
Titre:
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
00963164
Message ID:
00963374
Vues:
7
The problem is that the
<pages>
string becomes part of an EVAL() which pushes it over 255 when there are so many records. If you take out the surrounding
< %= IIF(RECCOUNT() > 10,[<< <  =====   > >>],[]) %>
in the HTML, you'll see what I mean. It will output the page numbers, but, not formatted quite right. Take a look at the HTMLTable method in ActiveVFP.prg, at the bottom, starting where it says "IF llpagenumbers..."
We might want to do something like:
Pages: 1 2 3 4 5 6 1..63 Prev Next
or just take out the
<pages>
string from the html
when there are so many records ....

>Claude:
>
>The error is showed by the Internet Explorer....
>not for Visual Foxpro...the error occurs when the COM
>run a SELECT instruction...for a few records the
>SELEC block work fine, but when the records numers exceeds...
>the error is generated...
>
>This is the SELEC:
>
>*****************************************************
>SELECT *, ;
> IIF(precio=0,'Oferta',TRANSFORM(precio,'99,999.99')) AS nprecio ;
> FROM dbcars ;
> WHERE id_type==lcitem_id;
> AND active ;
> ORDER BY mark ;
>INTO CURSOR tCursor
>*
>lchtmlfile = 'PageResult1.htm'
>lchtmlout= FILETOSTR(oprop.htmlpath+lchtmlfile)
>lchtmlout= ohtml.htmltable('dbvehiculo',lchtmlout,15,.T.,'#E5E5E5',.F.;
>,VAL(orequest.querystring("page")),orequest.querystring("nav"))
>lchtmlout= ohtml.mergetext(lchtmlout)
>RETURN lchtmlout
>
>thanks Claude for your help.
>
>att William
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform