How can we help you today? How can we help you today?

Updates with fields losing table context

I started with the following statement:
UPDATE Table SET
	Complete = 0,
	UpdateCustomer = 1,
	UpdateMember = 1,
	Update

If i press the hotkey when i've typed the word "upd" it will work correctly and show me a list of fields for that table (all starting with "update").

If i press the hotkey after completing the word update it will give me the list of:
UPDATE, UPDATE DIMENSION, UPDATE DIMENSION MEMBER, UPDATETEXT
But will lose all fields starting with the word "update".
lysp
0

Comments

4 comments

Sort by
  • Tilman
    Hi,

    I'm afraid I can't reproduce your problem. I never get the columns in the 'All' list apart from for the first column. It is obvious that we need to do some more work on parsing the UPDATE statement correctly.

    Regards,

    Tilman
    Tilman
    0
  • lysp
    Create the following table:

    CREATE TABLE TestCase (UpdateCustomer bit, UpdateMember bit)

    Refresh cache..



    Case 1 works correctly:
    UPDATE TestCase SET
	Upda[ctrl-space]

    Case 2 works incorrectly:
    UPDATE TestCase SET
	UpdateCustomer = 1,
	Update[ctrl-space]
    lysp
    0
  • Tilman
    Sorry, I still can't get it to happen. Although i had it that right after 'SET' it wouldn't display any columns. We will definitely improve this before the fina release.

    Thanks,

    Tilman
    Tilman
    0
  • lysp
    Picture tells a thousand words.

    update.jpg
    lysp
    0

Add comment

Please sign in to leave a comment.