pardox do not support this syntax?

Category: C/C++ -> Database Author: cfy_ppdove Date: 2008-05-27 11:58:23
 
cfy_ppdove
2008-05-27 11:58:23
select top 1 * from MyTable pardox do not support this syntax that you want to achieve this function pardox how to write it. Is to return only the specified number of records
kuermashang
2008-05-27 12:01:50
Or you are to think about it I said above methods, the primary key with auto-increment type on it.
booohe
2008-05-27 12:12:49
does not support, but I did not think there is anything in the way SQL statements can be directly implemented. So rarely used Paradox database (unless required under the procedures very efficient)
Average I control the number of records in the program, or their maintenance a primary key (mainkey), allowed the same value and the record number (but this a lot of trouble).
Select * from table1 where mainkey <100
chengliang2004
2008-05-27 12:27:46
pardox does not support top, but the landlord here is very simple queries, plus without top, the database query speed are not affected.
sports448
2008-05-27 12:40:04
is the case, a different database is a little different, such as interBase and SQL Server have different annotations in a different way and so on ......
xuqiang87
2008-05-27 12:45:40
does not support, but I also I did not expect in an SQL statement directly what can be achieved. So rarely used Paradox database (unless required under the procedures very efficient)
Average I control the number of records in the program, or their maintenance a primary key (mainkey), allowed the same value and the record number (but this a lot of trouble).
Select * from table1 where mainkey <100
/ / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / /

my program is a real-time control system and the amount of data it is very, very used pardox
shenn2005
2008-05-27 12:52:56
pardox does not support top, but the landlord here is very simple queries, plus without top, the database query speed are not affected.
/ / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / /

is actually very complex queries, I am here just In order to write a good expression was so simple