Two problems with prepared statements in ver 5.0.0

2004-05-08 Thread Ken Paradox
Hello, I have been working with the C API in version 4.1.1. I encountered a problem which I thought might be resolved in version 5.0.0, so I have loaded the RPMs for version 5.0.0 onto my development RedHat Linux system. - Problem 1 - can't

Presorting

2001-02-19 Thread Paradox
I have a table with an integer auto increment primary key, INVNUM, and a CHAR(48) field NAME. Is there a way I can have my table presorted by the text field, so that a select call with "ORDER BY NAME" is just as fast as "ORDER BY INVNUM"? I have tried indexing the textfield, both a few leading ch