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: ofsouto
  • Order by date
  1. ofsouto

    Dll reference.

    Hi, dear I have 3 ASP.Net systems that reference a VB.Net dll. I need 4 setups to install systems(3) and dll(1). If I alter code only in VB.Net dll, Do I need to generate all 4 setups or only the VB.Net setup? What about the systems(3) references to dll? Thank's Ofsouto Brazil
  2. ofsouto

    Increment Collumn

    I want to show all registers from a table(CODE, DESCRIPTION) and show an additional collum with the row number(INCREMENT). Select * from table_1 RESULT: CODE DESCTIPTION INCREMENT -------- ------------------------- ----------- 03354718 FIRST_DESCRIPTION 1 54654654...
  3. ofsouto

    OpenOffice

    Hi, dear How can I open an OpenOffice instance on ASP.NET code? Thank you very much Obede
  4. ofsouto

    Derived table

    Thank you, chekai. It works. Could you answer me another question? What's better? Subqueries or Derived Tables? I know I could use subquery to get the result but I don't know about the performance. Thank you again. Obede Brazil
  5. ofsouto

    Derived table

    I have two queries: SELECT DISTINCT tot.po_tble_cod FROM po_tabelatotal tot (NOLOCK), po_tabelaitem itm (NOLOCK), po_parametro par (NOLOCK) WHERE tot.po_tblt_cod = itm.po_tblt_cod AND itm.po_para_cod = par.po_para_cod AND par.po_bloc_cod = 99 returns: 42, 43, 65, 114...
  6. ofsouto

    Simple Query

    The problem was solved: SELECT DISTINCT fun.function_desc, fun.function_code FROM table_1 fun INNER JOIN table_2 itm ON fun.function_code = itm.function_code INNER JOIN table_3 par ON itm.parameter_code = par.parameter_code WHERE par.class_code = 1 AND fun.function_code NOT IN ( SELECT...
  7. ofsouto

    Simple Query

    I need to list all functions (codes and descriptions) with item functions that have only parameters with class code = 1. It is wrong if the function has item functions with one parameter with class code = 1 and another parameter with class code = 2. Thank you very much. Obede
  8. ofsouto

    Simple Query

    I have 3 tables table_1 function_code function_desc table_2 function_code itemfunction_code itemfunction_desc parameter_code table_3 parameter_code parameter_desc class_code I need to list all functions (code and description - table_1) where the item functions (table_2) have only parameters...
  9. ofsouto

    Getting XML nodes inner text

    Hi, dear How can I get the inner text of "user" and "quantity" nodes? <Monitore xmlns="Monitoramento por Lote"> <Lote> <user>SIABE001 SC01</user> <quantity>1</quantity> <register>MR2000000000001I1IMR </register> <register>MR2000000000002I1IMR </register>...
  10. ofsouto

    ADO.NET SQL-Server Text data type

    Hi, dear I just got full text but there are some chr(13) characteres inside text. I think I'm using wrong encoding. Obede Brazil
  11. ofsouto

    ADO.NET SQL-Server Text data type

    Hi, dear I need to get the full text of a text datatype collumn of a sql-server table. I tried the example of this link (http://www.kbalertz.com/Feedback_317034.aspx) and change getbytes to getchars and I didn't get the full text. What's wrong? How can I get the full text? Thank you very much...
  12. ofsouto

    SQL-Server Text datatype

    Hi, dear I need to get the value of a text datatype collumn in a SQL-Server table. The text length is 2196 characters, but when I try to get it by datareader or dataset the text length is 696. What's wrong? How can I get the full text? Thank you very much. Obede Brazil
  13. ofsouto

    XML DataSets files

    Thank you ca8msm. I have solved the problem.
  14. ofsouto

    XML DataSets files

    I intend to write more than one query in only one XML file. WriteXML permits write/save only one query. After write/save XML file I need to read/convert to dataset. Thank you.
  15. ofsouto

    XML DataSets files

    Hi, dear I need to save the result of some queries as XML files. I know that I can use datasets. I would like to know if it's possible to save these queries in only one XML file. Is it possible to read and convert this XML file in datasets? Thank you very much. Obede Brazil
  16. ofsouto

    How to get the last 13 month/year

    I'm querying data from a table. I have the table bellow CREATE TABLE [dbo].[AC_CARTEIRA] ( [ac_suplier_code] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [ac_date] [smalldatetime] NOT NULL , [ac_client_code] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ...
  17. ofsouto

    How to get the last 13 month/year

    Is there another way without creating any table?
  18. ofsouto

    How to get the last 13 month/year

    Hi, dear A date (GetDate()) is a stored procedure inside parameter. I need to list the last 13 month/year. I need to generate a query where I can get the result bellow: 01/2005 12/2004 11/2004 ... 02/2004 01/2004 Is it possible? How can I get it? Thank you very much Obede Brazil
  19. ofsouto

    Object variable or With block variable not set

    I had solved the problem. I created an object as an arraylist and I set it = session("config"). Dim arrConfig As ArrayList = Session("config") lblUsuario.Text = CType(arrConfig.Item(5), String).Trim Thank you very much.
  20. ofsouto

    Object variable or With block variable not set

    Dear sir I'm getting this error while trying to access an ASP.NET system on a Server. An user log on windows and can access the main page on ASP.NET system. Another user lon on windows and can't access the main page on ASP.NET System. Both are using the same machine. I tried again on another...

Part and Inventory Search

Back
Top