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

Search:

Type: Posts; User: BryanGR

Search: Search took 0.00 seconds.

  1. Replies
    8
    Views
    2,099

    Re: How to run a very long SQL statement

    Thanks jggtz

    I made it

    strSQL = strSQL & "WHERE " & ODBC1_FIELD_NAME & " = ' "& strKeyValue & "'"
  2. Replies
    8
    Views
    2,099

    Re: How to run a very long SQL statement

    Also I'm going to look up creating a stored procedure and see if that looks better.
  3. Replies
    8
    Views
    2,099

    Re: How to run a very long SQL statement

    I wish I could try it now, but the db is at another customers location and while there I don't have accses to anything other than WinSQL to trouble shoot.

    Thanks for the heads up on the spaces....
  4. Replies
    8
    Views
    2,099

    Re: How to run a very long SQL statement

    Thanks DataMiser

    So would you think this should work?
    I'm concerned about the FROM and WHERE.


    strSQL = "SELECT TOP 1"
    strSQL = strSQL & "ShipHead.PackNum,"
    strSQL = strSQL &...
  5. Replies
    8
    Views
    2,099

    How to run a very long SQL statement

    Hey I was wondering if someone here can help me. I have a very long sql statement but I'm running into errors when trying to run as part of my script. My normal sql statements are like

    ' Set SQL...
Results 1 to 5 of 5


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center