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

Search:

Type: Posts; User: jp140768

Page 1 of 31 1 2 3 4

Search: Search took 0.06 seconds.

  1. Thread: SQL Issue

    by jp140768
    Replies
    3
    Views
    749

    Re: SQL Issue

    I'm not really sure what you're trying to achieve here, but instead of having a sub query, could you replace it with an inner join? Refer to the table in the first From statement as a (for example),...
  2. Replies
    5
    Views
    1,184

    Re: problem with output stored procedre

    How about using a SET statement instead?

    Not sure if you can use:
    SELECT @CustomerId=@@Identity

    But you can definitly use Set @CustomerId = Ident_Current('Shippers') - well you can in SQL...
  3. Replies
    1
    Views
    560

    Re: Array Lists and general help please

    Hi,

    Just a quick update, to say that I got it partially to work, I change the definition in my calling program to:



    Dim aAccessories As List(Of...
  4. Replies
    1
    Views
    560

    Array Lists and general help please

    Hi Guys,

    I am trying to write a system, for a shop that hires out equipment, when you hire certain pieces of equipment, you should be offered other pieces, eg if you hire a chain saw, you should...
  5. Replies
    2
    Views
    808

    Re: using Cursors within a sp

    Attached is an example of a cursor being used, but from what I've read they're not always the most efficient way of working.



    --Drop Procedure spRemoveAPAKDuplicates
    --Go

    Create Procedure...
  6. Thread: SQL Table

    by jp140768
    Replies
    8
    Views
    1,354

    Re: SQL Table

    Hi Shers,

    As Consola said you want to create a database where information is not being duplicated if possible.

    Can you identify the unique characteristics of the data. You said you want to...
  7. Replies
    8
    Views
    846

    Re: Need help on SHAPE command

    Using Union, it shouldn't matter that there are a different number of fields in each table, unless you are doing Select *, provided you select the same number of fields in each table, and the...
  8. Re: Where can I download SQL Server 2000 and Oracle Database for Linux

    You can download the Express edition of Oracle for Linux from here:
    Linux Oracle

    SQL Server 2000, as far as I know, there is no free version of SQL Server 2000, the product you are looking for...
  9. Re: A bug in ADOX when creating one-to-one relationship?

    You say your using MDAC2.8, have you downloaded the Jet file (sorry I can't remember its name, but it will be in the download section of the Microsoft site), and its service pack?

    Also DAO and...
  10. Replies
    4
    Views
    643

    Re: Tough Group Query

    Hi,

    This is more of a database question than a VB one isn't it? What databse are you using?

    If I was doing it, I think I'd create a temporary table which contains records from the 8 group...
  11. Replies
    1
    Views
    883

    Re: Oacle database connection

    When you say it is not installing, what is happening - are you getting an error?
  12. Replies
    5
    Views
    1,496

    Re: Access 2002 EXISTS / IN clause problems

    I did suggest that joins be used.
  13. Replies
    7
    Views
    902

    Re: Please check the SQL statement...

    Is OrderComplete a boolean / logical etc type field? If so, you shouldn't need the last line of your Where statement



    The other thing, is what is the format of cdate? I'm wondering because if...
  14. Re: Plzzz: Varchar yyyymmdd column and datediff?

    DateDiff works on dates, not character fields, so you may need to convert the character field to a date time one.

    The following might work for you:
    cast(VESSEL_ETA as datetime)
    eg
    DATEDIFF(dd,...
  15. Re: How to get Driver do Microsoft Access (*.mdb)

    I think you'll get it in Jet 4 Service Pack 8, which can be downloaded from the Microsoft website.

    HTH
  16. Replies
    1
    Views
    938

    Re: reading .pdb database

    I have to be honest and say that I don't know what a .pdb database is, but could you use a "DSN-less" connection to various databases?

    You say that you want to be able to read and write any kind...
  17. Replies
    5
    Views
    1,496

    Re: Access 2002 EXISTS / IN clause problems

    The above wouldn't have worked, because in your sub query you are selecting mutiple fields (SELECT *), you should only return one field, so that you Where Students.Employee_id could be equated to the...
  18. Re: How to query events between an interval ?

    How often are you going to want to run this report? What database are you using?

    If the job was only to run once, could you create a trigger which wrote the specific event to a table, which could...
  19. Re: Using a List control to update yes/no fields on a table in access using VBA

    If I understand you correctly, you are going to use values on the second screen to insert a record into the database?

    Is your problem in building the SQL statement? or in issuing the statement on...
  20. Replies
    8
    Views
    1,234

    Re: Insert and Select in 1 statement - help

    You may be able to use the @@Identity function?
  21. Replies
    3
    Views
    800

    Re: Good database for Visual C++

    This website Connection Strings suggests that you can get MySql to work with .Net.

    I would have thought that SQL Server should work fine with Visual C++.

    Hopefully this will be of help to you...
  22. Replies
    4
    Views
    767

    Re: What is wrong with this SQL?

    I wonder if the problem is actually with Amt_PD_MTD? If you select this field from the database, what value do you get? Does the problem occur for all records or only some?

    I think in SQL...
  23. Replies
    3
    Views
    833

    Re: Return Blank data in a Stored Proc

    Most versions of SQL, contain a CASE statement. Look it up on your database documentation, it should help you out.

    HTH
  24. Replies
    1
    Views
    689

    Re: In Need of a regular expression.

    Are these numbers or character based fields. If numbers, in your first question, you could use the BETWEEN operator (depending on your database, it might be RANGE).

    I'm not really sure what...
  25. Replies
    1
    Views
    503

    Re: Strange problem with delete

    Are you getting any errors or messages?

    Is there a condition on the Delete statement, that would prevent the records from being selected for deletion?

    Can you post any code etc?
Results 1 to 25 of 769
Page 1 of 31 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