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

Search:

Type: Posts; User: chapran

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    322

    Re: Form on the form

    The previous attempt has frm, the last one is correct, no typo.
    Thank you
  2. Replies
    3
    Views
    322

    Form on the form

    I'm trying to implement VB.Net scenario in C#.
    In VB.Net I have an MDI application with MDI form and several child forms.
    MDI has a List Bar control on the left.
    Child forms load and occupying the...
  3. Thread: Select

    by chapran
    Replies
    2
    Views
    942

    Re: Select

    Sorry I do not understand your advice. Would you please give more details.

    Thank you
  4. Thread: Select

    by chapran
    Replies
    2
    Views
    942

    Select

    I need to create a select statement to get the list of PartialID with corresponding CommissionSplitPercent
    There is no direct relation between these values. This is my attempt graphically:

    35765...
  5. Re: Replace regular table with temporary in SQL Server

    Thank you very much for your help
  6. Re: Replace regular table with temporary in SQL Server

    Can you tell me if using ##TempTable is a bad way? If it is the same as #TempTable then I'm fine and wouldn't want to fight with this stuff anymore because my main area is VB6 development. SQL Server...
  7. Re: Replace regular table with temporary in SQL Server

    I cannot do this because I have dynamic selection (see my initial code).
    Thank you
  8. Re: Replace regular table with temporary in SQL Server

    I get this:


    Msg 208, Level 16, State 1, Procedure dbo.USP_TestTempTable, Line 11 [Batch Start Line 2]
    Invalid object name 'Status'.


    I understand that I have to have the table Status. It...
  9. Re: Replace regular table with temporary in SQL Server

    Any table I tried - Num, #TempTable and ##TempTable are used once. Num and ##TempTable work fine, #TempTable doesn't.
    Thank you
  10. Re: Replace regular table with temporary in SQL Server

    Sorry, but the sources I was working with say that the table may be created and populated with SELECT INTO, like my working code does:

    SET @sql = N'SELECT TOP ' + CAST(@QtyOfDays AS varchar(5)) +...
  11. Re: Replace regular table with temporary in SQL Server

    Right here by using SELECT INTO:

    ----Create Num table just for populating #Dates with all dates
    SET @sql = N'SELECT TOP ' + CAST(@QtyOfDays AS varchar(5)) + N' n = IDENTITY(INT, 1, 1) INTO...
  12. Replace regular table with temporary in SQL Server

    Replace regular table with temporary in SQL Server
    I have a stored procedure which has this code at the beginning (it is simplified to make it easier to understand)



    ALTER PROCEDURE...
  13. Replies
    2
    Views
    406

    Re: Copy SQL Server settings

    Doing research on internet I found some script allowing to see some settings. The difference I already see: On the production server the edition of SQL Server is standard, on my workstation it is...
  14. Replies
    2
    Views
    406

    Copy SQL Server settings

    My company upgraded SQL Server from 2008 R2 to 2017. I did the same upgrade on my development machine. Since that when I run VB6 program some processes produce errors on my local workstation with...
  15. Replies
    1
    Views
    1,072

    qbXML with QuickBooks Online

    My VB6 application communicates with Intuit QuickBooks desktop via special version of XML language qbXML. The application contains a pretty big number of procedures to send and receive data to and...
  16. Replies
    22
    Views
    1,821

    Re: SQL Server UNION

    Thank you. It looks to complex to work with variable table in my case - a lot of parameters and many tables are used in selections and filters. Variable tables are visible inside of dynamic string,...
  17. Replies
    22
    Views
    1,821

    Re: SQL Server UNION

    I have this in stored Procedure:



    DECLARE @1_Main TABLE (JobID int)

    --I create dynamic sql:
    If Not(@JobNumber Is Null)
    BEGIN
    SET @sql = N'
  18. Replies
    22
    Views
    1,821

    Re: SQL Server UNION

    2008 R2.
    As I know table variables are supported. I know nothing about table expression.

    Thank you
  19. Replies
    22
    Views
    1,821

    Re: SQL Server UNION

    Sorry for the delay. I had to finish and test to be sure that it works properly. The solution for AND I created looks like this:


    If Not(@JobNumber Is Null)
    BEGIN
    SET @sql = N'...
  20. Replies
    22
    Views
    1,821

    Re: SQL Server UNION

    I found solution.
  21. Replies
    22
    Views
    1,821

    Re: SQL Server UNION

    By some reason the button for code tag disappeared from my page. Next time I'll try to add manually.
    One more thing:
    The request was made more complex - users want to have the ability to set search...
  22. Replies
    22
    Views
    1,821

    Re: SQL Server UNION

    It looks like this now and it works. I just need to rewrite all IFs:

    If @DontDisplayArchivedData = 0
    BEGIN
    If Not(@JobNumber Is Null)
    BEGIN
    SET @sql = N'
    SELECT JobID
    FROM...
  23. Replies
    22
    Views
    1,821

    Re: SQL Server UNION

    You gave me a great scenario. Your code doesn't work, but it is my part to adjust. I beleive it will work.
    Thank you very much again.
  24. Replies
    22
    Views
    1,821

    Re: SQL Server UNION

    Wow! So elegant! Thank you very much!
  25. Replies
    22
    Views
    1,821

    Re: SQL Server UNION

    More help is required.
    How to add dependancy on parameters?
    Thank you very much
Results 1 to 25 of 88
Page 1 of 4 1 2 3 4


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)