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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: XaRz
  • Order by date
  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

    ...arti_pres varchar(10), alvl_precio decimal(15,2), alvl_uni integer, arti_codi varchar(10), alvc_codi varchar(10)) as begin /* Procedure Text */ for select alvc_codi,arti.ARTI_codi, arti.arti_presentacion,arti.arti_desc, alvl_unidades,alvl_precio,MAX(alvc_Fecha_alta) from...
  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.
  16. XaRz

    Dealing to convert the substring TSQL function to InstrRev

    Exacly the same error.
  17. XaRz

    Dealing to convert the substring TSQL function to InstrRev

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

    Dealing to convert the substring TSQL function to InstrRev

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

    Dealing to convert the substring TSQL function to InstrRev

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

    Dealing to convert the substring TSQL function to InstrRev

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

Part and Inventory Search

Back
Top