Search results for query: *

Hey dudes, I'm new to Informix..any tip why this is not working? CREATE PROCEDURE Phtotgraph_Summary_SP(photograph_classification LIKE fotografs.classificacio_fotograf) RETURNING CHAR(100) as Photograph, INTEGER as total_Expositions, CHAR(50) as record_Exposition, INTEGER as num_photos...

Hi ousoonerjoe, Perhaps I must try to use a multivarible report variable? I've seen one article referencing it. Thanks for the tip it makes a lot of sense.

Hi all. I've a dataset select like this: DECLARE @reprcodistr VARCHAR(1000) SELECT @reprcodistr = COALESCE (@reprcodistr, '') + FilteredHCG_CodigoRepresentante.hcg_codigo + ',' FROM FilteredSystemUser INNER JOIN FilteredBusinessUnit ON FilteredSystemUser.businessunitid =...

Thanks, r937. You're completely right. Thanks for the link.

Damm. firebird doesn't support subquerys in FROM statment (perhaps doesnt support in join too) Firebird uses Stored procedures emuling that situation or in where clause. any hints how to show my output in these terms? (without the subquery, I mean) Thanks,

Ok, But I suspect that Firebird doesn't like the join (select..) statment. see my Firebird SQL: Select A.ARTI_CODI, A.alvl_unidades,A.alvl_precio, A.Alvc_fecha_alta from dib_consum_last_articles_2(20013) A INNER JOIN ( Select ARTI_CODI, MAX(ALVC_FECHA_ALTA) LastDate FROM ALVC JOIN ALVL on...

Hi all, I've been searching for the way to do it. I need to show the order details in a sigle row per product. I want to get the results formated as: orderproductid orderproductunits orderproductprice orderdate 101102 6 40,35 19/10/2007 100100...

From manual input. I have the relation: Id_object1------->price1 Id_object2------->price2 Id_object3------->price3 Id_object4------->price4 Id_object5------->price5 In a sheet. And IdobjectX and priceX doesn't have any logic relationship, it's only a external decision.

Hi folks, I need to update several prices of several objects that I have the ID: Object1:ID1 Object2:ID2 OBJECT3:ID3 .... I want to update a field from each obecjt with a relation: Object1:price1 Object2:price2 Object3: price3 ... There is a way to do this in one statement? Thanks for your...

Is a very newbye question but I don't know how to manage this situation. I'm using de bdpconnection components in delphi 2006.NET and I'm tryng to comunicate 2 database throught a dataset in this kind of schema: DB1 (read tables via Bdpconection1) | | Dataset( used for store Winform input...

Sorry I've made an error The correct query is SELECT ALMA.ALMA_CODI, CLIE.CLIE_CODI FROM ALMA INNER JOIN CLIE ON CLIE.CLIE_CODI=MID(ALMA.ALMA_CODI,5,5); And access lets me to save but running the query I receive: ODBC: Falló la llamada [ODBC Firebird Driver][Firebird]Dynamic SQL error SQL...

doing SELECT ALMA.ALMA_CODI, CLIE.CLIE_CODI FROM ALMA INNER JOIN ALMA ON CLIE.CLIE_CODI=MID(ALMA.ALMA_CODI,5,5); Message: "sintaxis error in Join clause" And I can't do the query.

This Select you wrote down't work. I've tested something like: Select alma_codi, clie_codi from alma INNER JOIN clie ON Val(clie_codi) = Val(alma_codi); Is this you want me to try? Then it doesn't work. Access say that "This expression of combination is not admited".

The second. In fact I was thinking that the problem was this one. I'ven't been aware that CLIE_CODI is a varchar but include with this mental fix tha code doesn't work yet.

At the end of the query. At the last character of the sentence GROUP BY.

Exacly the same error.

Same error message. I've managed to make the report to the old fashioned way that it is exporting the query results to xls from ibexperts and importing the table in access to deal with the data. Perhaps the problem is the kind of join that doesn't like access, because the join: Join clie on...

I'm lost. I don't know why access give me an error like "Doesn't match types in the expression", I've double checked every column in the joins and all is correct. Perhaps the problem is in the Mid() function, but CLIE_CODI is a varchar(12), alma_codi is a varchar(18) and Mid(alma_codi,5,5) may...

Ok, but I receive a message that the type of data doesn't match because I'm using: SELECT ALMA.ALMA_CODI, ALMA.ALMA_DESC, REPR.REPR_DESC, ARTIALMA.ARTIALMA_STOCK_ACTUAL, ARTI.ARTI_DESC FROM (REPRCLIE INNER JOIN REPR ON REPRCLIE.REPRCLIE_REPR_PK = REPR.REPR_PK) INNER JOIN ((ARTIALMA INNER JOIN...

I mean that the characters from place 5 to 10 is the string that I want.