Unsupported Screen Size: The viewport size is too small for the theme to render properly.

ODBC Import – SQL Where & Mapping

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › ODBC Import – SQL Where & Mapping

  • This topic is empty.
Viewing 12 reply threads
  • Author
    Posts
    • July 21, 2005 at 5:25 pm #9119
      rbma
      Member

      Currently, fields specified in the 'SQL Where' have to be selected in the Mapping. Please consider not making this a requirement. Thank you.

    • July 21, 2005 at 7:02 pm #18665
      Ritesh
      Member

      I am not sure if I understood your problem. Can you explain it a little more?

    • July 21, 2005 at 7:07 pm #18666
      rbma
      Member

      In 'SQL Where' window,:

      STATUS='A' AND MEMBER_TYPE != 'NM' AND MEMBER_TYPE!='CL' AND PAID_THRU='12/31/2005'

      then in the 'Transform' window:

      Status, Member_Type, Member_type have to be checked. If they are not checked, then an error occurred.

    • July 21, 2005 at 7:15 pm #18667
      Ritesh
      Member

      By default SQLyog checks all the columns.

      Are those 3 columns not checked at your side?

    • July 21, 2005 at 7:23 pm #18668
      rbma
      Member
      Ritesh wrote on Jul 21 2005, 07:15 PM:
      By default SQLyog checks all the columns.

      Are those 3 columns not checked at your side?

      [post=”6535″]<{POST_SNAPBACK}>[/post]

      Yes they are checked initially. However, I don't want them to be included.

    • July 21, 2005 at 7:50 pm #18669
      Ritesh
      Member

      I have forwarded this issue to my development team.

    • July 22, 2005 at 6:40 am #18670
      Ritesh
      Member

      Are those columns part of an Index or FK?

    • July 22, 2005 at 6:44 am #18671
      Ritesh
      Member
      Quote:
      then an error occurred

      What is the error you are getting?

    • July 22, 2005 at 3:53 pm #18672
      rbma
      Member
      Ritesh wrote on Jul 22 2005, 06:40 AM:
      Are those columns part of an Index or FK?

      [post=”6541″]<{POST_SNAPBACK}>[/post]

      Nevermind. Problem fixed. Thank you.

    • July 22, 2005 at 3:59 pm #18673
      Ritesh
      Member

      What was the issue?

    • July 22, 2005 at 4:02 pm #18674
      rbma
      Member

      I can't reproduce the error. It was either downloading the latest beta or unchecking 'Import Index' and 'Import Foreign Keys'.

    • July 22, 2005 at 4:04 pm #18675
      rbma
      Member

      When is the next beta being released? Thanks.

    • July 22, 2005 at 4:06 pm #18676
      Ritesh
      Member

      Tomorrow or monday latest.

  • Author
    Posts
Viewing 12 reply threads
  • You must be logged in to reply to this topic.