php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #66247 ROW Type
Submitted: 2013-12-09 11:43 UTC Modified: 2014-01-15 10:02 UTC
Votes:2
Avg. Score:2.0 ± 1.0
Reproduced:0 of 1 (0.0%)
From: bernhard dot walter at profile dot co dot at Assigned:
Status: Open Package: PDO_INFORMIX (PECL)
PHP Version: 5.4.22 OS: PHP 5.3.10-1ubuntu3.8
Private report: No CVE-ID: None
 [2013-12-09 11:43 UTC] bernhard dot walter at profile dot co dot at
Description:
------------
Hello

in informix you can use datatype SET, LIST, MULTISET.

We created a table like this
create table "informix".td_action
  (
    act_no serial not null ,
    act_serial integer not null ,
    act_acty_no integer not null ,
    act_mtc_no integer not null ,
    act_period smallint not null ,
    act_minute smallint not null ,
    act_datetime datetime year to fraction(3) not null ,
    act_updatetime datetime year to fraction(3) not null ,
    act_properties  SET(ROW(name VARCHAR(30), value integer) not null) ,
    unique (act_no)
  );

The problem is that we can't get the result of the act_properties.
Maybe you can help us?

Thanks a lot

Best regards
Walter Bernhard



Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2014-01-15 10:02 UTC] bernhard dot walter at profile dot co dot at
Hello

I'm afraid that I didn't hear something.
Hope you can help me with this case.

Best regards
Walter Bernhard
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Oct 13 23:01:26 2024 UTC