Recent content by xcata

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

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

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

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

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

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

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.

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

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.

Hi, What do you mean by XIRR calculations ?

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.

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

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.

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

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