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

  1. Thread: SQL Issue

    by jp140768
    Replies
    3
    Views
    1,110

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

    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
    653

    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
    653

    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
    928

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

    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
    1,021

    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
    921

    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
    1,025

    Re: Oacle database connection

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

    Re: Access 2002 EXISTS / IN clause problems

    I did suggest that joins be used.
  13. Replies
    7
    Views
    1,079

    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
    1,021

    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
    2,061

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

    Re: Insert and Select in 1 statement - help

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

    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
    1,067

    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
    1,037

    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
    906

    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
    635

    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





Click Here to Expand Forum to Full Width

Featured