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
    580

    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
    545

    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
    674

    Re: Is Report

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

    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,157

    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
    660

    Re: sp_help problem

    Another way to do is like so

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

    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
    668

    Re: oracle query help

    Actually should be

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

    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
    911

    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
    381

    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
    484

    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,154

    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
    3,074

    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
    477

    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
    598

    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
    508

    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
    849

    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
    693

    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
    489

    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,287

    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,287

    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
    576

    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


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center