View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000836 | Hopper | General | public | 2014-02-25 12:27 | 2014-04-01 16:15 |
| Reporter | Martijn Tonies | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 1.5.0 | ||||
| Summary | 0000836: 'NULL' character data returned as <null> | ||||
| Description | I have a SP declared as follows CREATE PROCEDURE "SP_TROF_VARCHAR" ("DATA" VARCHAR(255)) RETURNS ("RESULT" VARCHAR(20)) AS BEGIN IF (data IS NULL) THEN result = 'NULL'; ELSE result = CAST(data AS VARCHAR(20)); END; It works perfectly in IB but when called in Hopper as aVariable = NULL; SP_TROF_VARCHAR(aVariable) it returns NULL instead of string 'NULL' . Kind regards, JK | ||||
| Tags | No tags attached. | ||||
| DBMS Version | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-02-25 12:27 | Martijn Tonies | New Issue | |
| 2014-04-01 09:38 | Martijn Tonies | Summary | NULL character data returned as <null> => 'NULL' character data returned as <null> |
| 2014-04-01 11:33 | Martijn Tonies | Status | new => resolved |
| 2014-04-01 11:33 | Martijn Tonies | Fixed in Version | => 1.5.0 |
| 2014-04-01 11:33 | Martijn Tonies | Resolution | open => fixed |
| 2014-04-01 11:33 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2014-04-01 16:15 | Martijn Tonies | Status | resolved => closed |
