Hello, All! Server - SAP DB 7.3.0.23 Linux RedHat 7.1 Client - SQL Studio 7.4 or ODBC Application on Windows 2000 SP2
I have a table of the type: create table flat_prd ( name varchar(20), s_use float, s_kuh float ) I necessary to select from table on condition with expression: select * from flat_prd where s_use/s_kuh = 2 herewith appears mistake "General error;-3024 POS(1) Invalid numeric expression." But requests of the next: select * from flat_prd where s_use+s_kuh = 2 select * from flat_prd where s_use-s_kuh = 2 select * from flat_prd where s_use*s_kuh = 2 select * from flat_prd where s_use/2 = s_kuh they are executed orderly. Why? Pavel Konovalov ________________________________ JS RCOM, Russia http://www.rscom.ru _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
