Hello, I have this table:

ID                 AUTOINC
OPC              STRING 30
VALOR          STRING 10
DESCRICAO  STRING 30

ID   OPC                          VALOR   DESCRICAO
1     [TOLANDON]N20:83       1          TURNO
10   [TOLGF04]B3:1/1           0          INTERVALO_REFEICOES
20   [TOLANDON]S:18        2007       ANO
30   [TOLANDON]S:20           3         DIA
40   [TOLANDON]S:19          10        MES    


And I need this result

ANO  MES  DIA
2007   10    3

OR

DATA
2007-10-03


Thanks!

Roger Oliveira.

"Roger Oliveira" <roger@puxtreme.com.br> wrote in message
news:F37704A4-C08C-4105-9AE3-1DA584D171B9@news.elevatesoft.com...
>
> Hello, I have this table:
>
> ID                 AUTOINC
> OPC              STRING 30
> VALOR          STRING 10
> DESCRICAO  STRING 30
>
> ID   OPC                          VALOR   DESCRICAO
> 1     [TOLANDON]N20:83       1          TURNO
> 10   [TOLGF04]B3:1/1           0          INTERVALO_REFEICOES
> 20   [TOLANDON]S:18        2007       ANO
> 30   [TOLANDON]S:20           3         DIA
> 40   [TOLANDON]S:19          10        MES
>

See my reply to the other post. Basically, you create a memory table with
the fields you need and an empty record

create table memory\temp1
(ano  integer, dia  integer, mes  integer);
insert into memory\temp1 values(0,0,0);

and then you update using your table
set memory ano = table.ano where descricao = 'ANO', etc.

Robert

>
> And I need this result
>
> ANO  MES  DIA
> 2007   10    3
>
> OR
>
> DATA
> 2007-10-03
>
>
> Thanks!
>
> Roger Oliveira.
>
>

"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote in message
news:750B7491-3E76-4A79-B2F3-6607DED0716B@news.elevatesoft.com...
>
> set memory ano = table.ano where descricao = 'ANO', etc.

should be set memory.ano = table.valor

R