Recent content by 2m.lt

The reason of using it is the following: I have a table in an Oracle DB. This table has indexed customer_id CHAR(20) field. The problem is writing queries using these CHAR fields. For example the following three statements do not return anything: FOR EACH phone WHERE customer_id = "1"...

Is this still not quite possible? For example I can use this statement to select result to a variable if select returns only one row DEF VAR ch AS CHAR NO-UNDO. SELECT name INTO ch FROM customer WHERE customer_id = 123 However, it does not seem to be working with temp tables or handles to...