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: xcata
  • Order by date
  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)...
  16. xcata

    My question is: Is there a way to

    It depends what do you want to do. For example if you have in your system scrrun32.dll, you may use FileSystemObject to gain acces to disk. For this you must use extended stored procedures sp_OACreate, sp_OAMethod to create and call methods from activeX objects. Another way, much more limited...
  17. xcata

    how to: select * from table where combobox = textbox

    Hi, With the help of sp_executesql you may also variables inside a dynamic sql statement. Example from BOL: DECLARE @IntVariable INT DECLARE @SQLString NVARCHAR(500) DECLARE @ParmDefinition NVARCHAR(500) /* Build the SQL string once.*/ SET @SQLString = N'SELECT * FROM pubs.dbo.employee...
  18. xcata

    Alter Table

    Hi, You may try dynamic sql: Declare @ColName varchar(15),@sSql varchar(255) Set @ColName = 'NEW' set @sSql = 'Alter Table ProjAct Add ' + @ColName + ' varchar(15)' exec(@sSql)
  19. xcata

    Do I have to write all the SQL?

    Hi, You may use view designer in Entrprise Manager. It is not so powerfull like Access but may help.
  20. xcata

    Return last 2 digits of the Year ??

    Hi, select substring(convert(varchar,getdate(),101),9,2) or select substring(convert(varchar,datepart(year,getdate())),3,2) xcata.

Part and Inventory Search

Back
Top