Search Results - CodeGuru Forums
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: antares686

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. How to display Embedded Resource JPG file with Web Component .NET 1.1

    I have a JPG file embedded in a Web Component DLL written in C#. I am trying to figure out how to render this as an HtmlImage at runtime on th page the component is added to. Looking to render as th...
  2. Replies
    2
    Views
    575

    Re: Backup problem

    Can you reexplain. You does not start after 24hrs. What are you doing, how big is the database?
  3. Thread: Help me

    by antares686
    Replies
    1
    Views
    542

    Re: Help me

    Can you explain more. Do you mean you want to store a file or you want to create a data object in SQL from a stored set?
  4. Thread: Is Report

    by antares686
    Replies
    1
    Views
    670

    Re: Is Report

    What reporting tool are you talking about first?
  5. Replies
    1
    Views
    715

    Re: Object required error in page

    Try creating a variable setting the vairbale equal to your string and passing in the variable to the execute. Have seen builing a string throw issues before.

    Dim strSQL

    strSQL = "EXEC...
  6. Replies
    4
    Views
    1,155

    Re: MS SQL setup trouble

    I have installed SQL 2000 on 2K Pro but I believe it was Developer Edition of SQL not others. Unfortunately I no longer use Win 2K Pro.
  7. Replies
    3
    Views
    643

    Re: sp_help problem

    Another way to do is like so

    EXEC test..sp_help 'tt'
  8. Replies
    3
    Views
    717

    Re: Double Byte to Single Byte

    Potentially you could but it would be neither pratical and may cause a number of issues when you try to query the data.
  9. Replies
    4
    Views
    657

    Re: oracle query help

    Actually should be

    SELECT * FROM Patients where ADD_MONTHS(DOB,12*18)>=SYSDATE
  10. Replies
    3
    Views
    458

    Re: Trigger Tables

    Updated deosn't exist.

    Updates use both the inserted and deleted names inserted is the entire row as it will look after the update completes. deleted is the snapshot of before.
  11. Re: What is the difference between inner join and outer join?

    INNER JOIN means that any data that is matched in the ON clause has to be matched btween both tables. So say one tabl has Bob, Jeb, and Fred and the other has Bill, Bob and Fred and you join on first...
  12. Replies
    2
    Views
    904

    Re: MS SQL Server database path rules

    Can you post a snippet of hat code section so I can understand exactly what you are doing?
  13. Thread: count

    by antares686
    Replies
    1
    Views
    379

    Re: count

    Yes using a case wrapped by sum will make it work.

    select table1.column1, table1.column2, (case table1.column5 when 10 then '10'
    when 11 then '11' end) as result, table1.column6, sum(case when...
  14. Replies
    3
    Views
    480

    Re: MySQL password

    I assume you store the password encrypted in the database from your question. As long as you are using the same encryption method and keys then doing a straight copy thru code should do the trick....
  15. Replies
    2
    Views
    1,141

    Re: Oracle Client Installable

    1) My understanding is the Oracl client is not free it has to be licensed with your server (cal).

    2) Don't know sorry.

    3) Refer to 1.
  16. Replies
    6
    Views
    2,895

    Re: timestamp data type in MSSQL

    Read this from SQL BOL and try to chang from using timestamp to rowversion so when they change the funtion in the future it will not impact you.
    ...
  17. Replies
    6
    Views
    470

    Re: Joining tables

    First what database are you using and can you describe the individual tables and what fields you will bring back from each?
  18. Replies
    3
    Views
    592

    Re: sql2000 select question

    Or if you prefer that if either condition is met as opposed to both use

    SELECT G, H
    FROM Score_BD
    WHERE F IS NOT NULL OR A = 10
  19. Replies
    3
    Views
    502

    Re: return null fields ok

    First off let's see what yo are after. Can you post an example of the table data and what yu expect the results to be. Also, you are using the older ansi join syntax method which most databases have...
  20. Replies
    13
    Views
    831

    Re: Database Design Help

    First off names of tables should be plural no matter what else you do with them as they represent more than one object.

    But as for your question it depends on the type of database system you are...
  21. Replies
    4
    Views
    691

    CREATE MyProcedure @newID int, @oldID int AS...

    CREATE MyProcedure
    @newID int,
    @oldID int
    AS

    INSERT INTO MyTable(ExperimentID, Threshold, Energy) VALUES(@newID, Select Threshold, Energy from OldTable where ExperimentID = @oldID)

    The key...
  22. Replies
    2
    Views
    483

    Are all the records primary key 6 in length and...

    Are all the records primary key 6 in length and if not do you pad in the other table? Also what is the error you are getting?
  23. Replies
    6
    Views
    1,192

    Are your data sources on the same server or...

    Are your data sources on the same server or coming from various locations. If the same then create a view on the server and save soem time and the temp table resource can be eliminated.

    If remote...
  24. Replies
    6
    Views
    1,192

    Re: ADO Recordset::sort help

    SQL sorting does use memory and tempdb space to sort the data. Just happens on the server and SQL may already have the memory allocated. Large disconnected recordsets are not usually a good idea...
  25. Replies
    5
    Views
    569

    Re: SQL suggestion requested

    You can only

    use the concatinated method as long as the submitted data length will not exceed 8000 bytes (char/varchar type limit).

    If this is for inserts only then use ADO to create your...
Results 1 to 25 of 309
Page 1 of 13 1 2 3 4


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center