FiveTech Software tech support forums

MySql : LIMIT n
MsSql : TOP n

Mr. Rao:

You are right, it is just to see if the LIMIT 20 clause gains speed.

Greetings

Armando wrote:Friends:

In addition to the ORDER BY clause, try using the LIMIT 20 clause.

Best regards

He is already using TOP 20 clause.

Friends:

In addition to the ORDER BY clause, try using the LIMIT 20 clause.

Best regards

... the forum is unusable Do you want to find a solution for fivewin and print html? I didn't ask, when I ask then you can answer I don't want to limit freedom of expression but this is not just a disease now you are obsessed with html as you were obsessed with ER but I have shown you that ER ...

... and get back to you. Don't hurry, I've a workaround BTW: I missed [<lFindLast>] in ::Seek() :( have to torture myself with DESCEND and LIMIT :roll:

Just like Maurizio said :


If you use RC verify check GET parameter Auto horz scroll = Yes

Philippe

Sorry for the delay in responding ... life gets very busy these days. Nages' explanation made perfect sense. I shared it with my client. He is the only one complaining about this problem, and I expect he is just pointing the cursor at the middle of the field and pressing paste, which, as was explain...

I was not talking about the width of the Get control.
I was talking about the width of the Get variable.
The behavior of the Paste, as I explained has nothing to do with the issue of horizontal scrolling.

Tim ,

Dialogs are created with RC , DLL or use commands @ GET ?

If you use RC verify check GET parameter Auto horz scroll = Yes

Maurizio

Jimmy wrote:hi Tim,

what about

Code: Select all  Expand view

PICTURE "@K"

PICTURE @K is superfluous in Windows.
Useful only in DOS Clipper/Harbour applications.

hi Tim,

what about

Code: Select all  Expand view

PICTURE "@K"

No limits in FWH. If we are talking about pasting into a Get, then the copied text is pasted from the cursor position till the end of the Get. Example -Width of Get is 80 chars -Copied text is 70 chars -User has his cursor position 60 in the Get and then pressed Ctrl-V, the text is pasted from 61st ...

I have received complaints from some clients that they are limited to how much they can cut and paste in an application. In other words, if a text is 35 characters long, highlighted, then copy is selected, then they try to paste it into a field ( ie. ...

... MB *.XLSB with all 351287 Record :D ADO Records = 351287 Time = 288.54  1217.47 Rec/Sec XLSwriter RECNO() = 109571 MEMORY( 3 ) = 31044 // have set Limit at 32 Kb it is just before available Memory "crash" so leave loop i "think" it have to do that ADO "read/write" ...