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 Rhinorhino 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 xcata

  1. xcata

    Global variables (between dll's, exe's) creation

    I got your point but this way I must change all dll's to reference that cGlobal class(and I have many). Another problem is that most of the dll's are loaded when a property of a global multiuse class is used. I know it's dangerous for the programmer but that's it.It's dificult to find the load...
  2. xcata

    Global variables (between dll's, exe's) creation

    The original problem was that: I need a solution for sharing some data between a exe and all of his components (in activex dll's) without passing parameters each time. I found a very simple sollution by making a class (cGlobal) wich is instantieted in the main app. I add it to ROT and after...
  3. xcata

    Global variables (between dll's, exe's) creation

    Thx for yuor response. For the main-apps that did not logoff propermy I have a solution. Each time I start a instance of main app I can cleanup this table by finding all main windows and eliminating those wich are not. The problem I see here is how to make the link between an main application...
  4. xcata

    Global variables (between dll's, exe's) creation

    I need to create some global variables accesible from an exe and some activex dll. I found a solution by creating a class in the main program , register it in ROT(running object table) and after that in each dll I can get the instance of that class and use all his proprierties/methods. The only...
  5. xcata

    Choosing right datatype for a column

    Hi, I must design a Sql Server 7.0 database for a heavy loaded website. This database will receive 50k+ inserts/day and 10-20k+ selects. All selects are time dependant. Initially the column had datetime type. For speed reasons I created another column (integer type). This column store the...
  6. xcata

    Design database for optimum varchar grouping

    Hi, First of all I must to mention that the database will receive 40000 inserts/day and probably 10000+ requests. I have a table with many fields(20), most all of them are integer. Three of them are varchar(100). My question is how to design the table/tables to obtain maximum performance on...
  7. xcata

    join operation syntax needed

    No, the derived table are not good because I need this query for an application who knows only simple queries. For the second answer, what I need is the sum of quitt and the sum of others for each contract. In my opinion does not exist a sollution but maybe I'm wrong. Thnaks anyway.
  8. xcata

    join operation syntax needed

    Hi, I have a strange problem with calculating some amounts Ex. create table Contracts(contract_id int,contract_description varchar(15)) create table Quittances(quitt_contract_id int, quitt_amount decimal(12,2)) create table Others(oth_contract_id int, oth_amount decimal(12,2)) insert into...
  9. xcata

    Test if a com port is busy

    Hi, Does anyone have an example(or URL) for finding all the serial ports connected and their status(if they are in use or not) ? Thanks, Catalin.
  10. xcata

    Calculating XIRR in SQL?

    Hi, What do you mean by XIRR calculations ?
  11. xcata

    TESTING STORED PROCEDURE

    Hi, RAISERROR ('N', 16, 1) is the answer. With this you may generate a error with 'N' value. The other parameters are severity, state... For detailed information on parameters you may consult BOL.
  12. xcata

    Drop all indexes

    Hi, Has anyone a construction for dropping all indexes from a database? Thanks.
  13. xcata

    Declare a Cursor with dynamic from table name

    Hi, You may introduce the cursor definition is sql dynamic string too. or you may construct a temporary stored procedure to do the job. Hope this helps, xcata.
  14. xcata

    Include file as variable

    Hi, Sorry jitter but your example is not quite correct. If you do <%Select Case X Case &quot;1&quot;%> <!-- #include FILE=&quot;one.asp&quot; --> <%Case &quot;2&quot;%> <!-- #include FILE=&quot;two.asp&quot; --> <%End Select%> iis will include both files because #include is a...
  15. xcata

    SQL Phrase wanted.

    Hi, Try this, declare @x int,@y int,@z int,@t int select @x=0,@y=1,@z=2,@t=3 insert into t select * from ( select @x as col union all select @y as col union all select @z as col union all select @t as col ) as tbl where tbl.col <>0.0 select * from t --create table t(col int)...
See more

Part and Inventory Search

Back
Top