Re: One more question ,Ask about SQL ?

Posted by webmaster Guido on September 24, 2000 at 00:32:30:

In Reply to: One more question ,Ask about SQL ? posted by Tien Ho Van on September 13, 2000 at 11:15:48:

: Hi ! I want to use SQL command to filter range of records
: i.e to get all records from record number 4 to 10 in my table , I coded as:
: Select * from mytable A where A.recno > 4 and A.recno<10
: I get message "Invalid field name recno "
: So how can I write to let Delphi know Recno is a function not a field ?
: Thanks !
---
You say: "let Delphi know Recno is a function"... but in fact, you send the SQL statements to "Local SQL", not to the Delphi compiler.
The SQL-engine translates SQL-statements to Delphi "BDE" calls. SQL understands only SQL reserved words and expressions, table names and field names. You can not use a Delphi function command in a SQL statement, SQL accepts only SQL "language". For a list of reserved words of the SQL that is used, you can look up "local SQL" in Delphi's help system.