Recent content by ghaleon

I have no idea what that is or how to do it :)

Nope this only works (that I know of in MySQL 4+). There are a couple work arounds in MS SQL tho. select top * from ( select top * from table order by column ) order by column and select * from ( select top * from ( select top (+) from table order by column ASC ) T1 order by column DESC )...

I tried to call them and ask if there was such a function but they wanted $250.00 or something like that... I'd rather deal with a little lag.

My Comment: Would be nice to have a variable in PSQL that returns the current row number or a function such as mysql's 'limit' function that selects a range of rows. ie select * from table limit 10, 20 ... basically that would select 20 records AFTER the first 10 OR select * from table where...

I would rather not if i can avoid it... Think there are any plans to change PSQLs limit function into one more similar to MySQLs in newer versions of Pervasive? http://php.about.com/od/mysqlcommands/g/Limit_sql.htm Personally I think that would be awesome... For now I guess my best option is...

After putting this into play I'm still going to run into issues. Basically now I will need to run 3 queries instead of 1 One to find the top number One to find the 20 records in the page data One to find the total values in the table Also when I am running the first query to find the top...

That works :) Kinda a different way of doing it but it works non-the-less. Thx for your help!

Here is one way IT COULD be done: select * from table where ROWNUMBER < $page*20 AND ROWNUMBER > $page-1*20 That is of course ROWNUMBER was a variable :)

Not really. Heres an example of the data and what I am trying to do. http://quicksilverbbs.com/itemlist.php?t=1 Basically it lists all of the weapons in the dat file. It displays 20 items per page. This gives a pretty big load time for my larger dat files and instead of selecting ALL items i...

no record numbers =) it was all created on an old version of btrieve and i guess the original designers didnt think to put it in :/

Maybe there is some global variable/function that returns the current row??

From my understanding ROWCOUNT is almost the same as TOP. ROWCOUNT returns the first # of values.. and so does TOP. I need something that makes the query START at a certain row # and then use TOP to pick the next set of numbers.

I was curious if you might know how I would do a range of rows in PSQL starting at row 10 with a limit of 20 rows. In MYSQL it would just be select * from table limit 10, 20 Thanks in advance.

CORRECTION CREATE UNIQUE NOT MODIFIABLE INDEX "key0" IN DICTIONARY ON "CHARACTERS"("userid"); CREATE INDEX "key1" IN DICTIONARY ON "CHARACTERS"("username"); CREATE INDEX "key2" IN DICTIONARY ON "CHARACTERS"("unsignedbinary"); Same results.

Can someone please tell me what I am doing wrong here?? EXECUTED IN PERVASIVE 9.5 CREATE TABLE "CHARACTERS" using 'wccuser2.dat'( "userid" VARCHAR(30), "username" VARCHAR(30), "unsignedbinary" UINTEGER ); CREATE UNIQUE NOT MODIFIABLE INDEX "key0" ON "CHARACTERS"("userid"); CREATE INDEX...