dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: SELECT f1, f2, f3 FROM table1 -> if I want to hide f3 how to write sql statement

  1. #1
    Join Date
    Aug 2001
    Posts
    60

    Question SELECT f1, f2, f3 FROM table1 -> if I want to hide f3 how to write sql statement

    SELECT f1, f2, f3 FROM table1

    if I want to hide f3 but f1, f2 still display and f3 include in the recordset.

    how to write sql statement.

    remove the colomn of grid is not fit in my project.

    Thank guru.

  2. #2
    Join Date
    Dec 2002
    Posts
    218
    The columns you include in the sql statement will be included in the recordset. If you don't want to display it then hide the column of the grid (set width = 0). If you're not actually using the value in that column but only as a constraining value then you don't need to include it in the column list of the sql statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)