Questions tagged as 'informix'

Tagged questions
1
answer

Query does not return WHERE set

I'm trying to query the Informix Database, and it's bringing in the data normally, but it's ignoring the search criteria. SELECT cnnfcapa.id_nfcapa, cnnfcapa.filial, cnnfitem.tpordem, cnnfcapa.ordemserv, cnnfcapa.dtnota, cnnfcapa.cgccpf,...
asked by 19.10.2017 / 04:05
1
answer

Query a field formatted datetime year to second, asking to bring only today's records?

I would like to know how to fetch a date record, but bring this dat_entrada only with the current date? Here is the query: select a1.cdg_filial Filial, a1.cdg_fornecedor Fornecedor, a2.dcr_fornecedor NomeFornecedor, a1.nmr_d...
asked by 27.10.2018 / 01:53
0
answers

Subquery at Banco Informix

I have a query that searches sales for a period: SELECT cxpdvend.filial, cxpdvend.dtpedido, cxpdvend.pedvenda, ciendere.nro_endere, cipessoa.nomepessoa, ciendere.celular, cxpdvend.codagente,...
asked by 19.10.2017 / 11:14
3
answers

Add hours to an array

I need to total the column hora_agente of type time . I need the value returned in hours. Can be longer than 24 hours. In the example I did, it is returning 5:55, and should return 53:55. I believe that when he gives 24 hours, he...
asked by 22.09.2017 / 13:15
0
answers

Syntax error in Informix database query

I made a prototype of a informix database in Access to optimize the construction of my queries. I use with MySQL and through some syntax adjustments I get a good one. But in%% of% I can not. I want to believe it's a little detail b...
asked by 06.09.2017 / 09:52
1
answer

Create Informix ODBC Data Source

Problem: I need to register a INFORMIX data source and I can not. I enter the parameters, but there is always an error. What should I do?     
asked by 20.05.2016 / 21:19
1
answer

How to transform an output from an already xml query into Informix?

It is possible to take any exit from a query directly from the bank and to bring the result already formatted into XML text? This using IBM Informix v11.50 database and native mode in the database. Where instead of the database returning...
asked by 03.04.2014 / 01:46
1
answer

How to give count to a limited value, "count up to 90 in a table that has 100"

I have set the following Query - "INFORMIX" SELECT COUNT(1) FROM (SELECT * FROM NOTA_FISCAL_NFE LIMIT 90); That returns me the following error:    An error occurred when executing the SQL command: SELECT COUNT (1) FROM   (SELECT * FROM N...
asked by 13.04.2018 / 16:29