Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by XaRz

  1. XaRz

    Problem with SP and Foreach statment

    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...
  2. XaRz

    Passing string variables to a Select don't work..why?

    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.
  3. XaRz

    Passing string variables to a Select don't work..why?

    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 =...
  4. XaRz

    Help me with getting recent value of multivalue rows

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

    Help me with getting recent value of multivalue rows

    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,
  6. XaRz

    Help me with getting recent value of multivalue rows

    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...
  7. XaRz

    Help me with getting recent value of multivalue rows

    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...
  8. XaRz

    How to update several fields in one Select statment?Is possible?

    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.
  9. XaRz

    How to update several fields in one Select statment?Is possible?

    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...
  10. XaRz

    How to update a database field from a dateset field-BDP in Delphi2006

    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...
  11. XaRz

    Dealing to convert the substring TSQL function to InstrRev

    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...
  12. XaRz

    Dealing to convert the substring TSQL function to InstrRev

    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.
  13. XaRz

    Dealing to convert the substring TSQL function to InstrRev

    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".
  14. XaRz

    Dealing to convert the substring TSQL function to InstrRev

    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.
  15. XaRz

    Dealing to convert the substring TSQL function to InstrRev

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

Part and Inventory Search

Back
Top