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 strongm 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
  • Content: Threads
  • 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 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 =...
  3. 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...
  4. 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...
  5. 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...
  6. XaRz

    Dealing to convert the substring TSQL function to InstrRev

    Here is the TSQL query: Select alma_codi, alma_desc, repr_desc, artialma_stock_actual,arti_desc from alma Join artialma on artialma_alma_pk = alma_pk Join arti on arti_pk = artialma_arti_pk Join clie on clie_codi = substring(alma_codi from 5 for 10) join reprclie on reprclie_clie_pk = clie_pk...
  7. XaRz

    6 Joins in Jet hangs my access query

    I'm trying to export an TSQL select to JET and I'm not able to do it, because the query hangs msaccess. Here comes the JET SQL command: SELECT ALVC.ALVC_CODI, FRVC.FRVC_CODI, SECC.SECC_DESC, Max(ALVCTOTL.ALVCTOTL_IMPORTE_BRUTO) AS Expr1, CLIE.CLIE_DESCUENTO2, ALVC.ALVC_IMPORTE_NETO FROM FRVC...
  8. XaRz

    Concatenating One to many in another field where "many" is variable

    I have a query that shows a One to many relationship: SELECT CLIE.CLIE_CODI, TLOC.TLOC_DESC, TLOC.TLOC_CODI, CLIETLOC.CLIETLOC_DESC FROM (CLIETLOC INNER JOIN TLOC ON CLIETLOC.CLIETLOC_TLOC_PK = TLOC.TLOC_PK) INNER JOIN CLIE1 ON CLIETLOC.CLIETLOC_CLIE_PK = CLIE1.CLIE_PK GROUP BY CLIE1.CLIE_CODI...
  9. XaRz

    Five Inner Join in Jet

    Hi to all, [I'm a newbie in JET SQL please don't blame me!] I've a SQL query that I need to convert to JET SQL but I don't understand the sintaxis of FROM and INNER JOIN when 3 or more are involved. Here I paste to you my SQL Query.. any hint would help SELECT CLIE_CODI,ALVC_CODI,FRVC_CODI...

Part and Inventory Search

Back
Top