Suneido

Integrated Application Platform

  • Home
  • Learning
    • Suneido Manual
    • Beginners
      • Inside Suneido
      • The Suneido Programming Language
      • The Suneido Database
      • Installing Suneido
      • Building Suneido
      • IDE Go To Tour
      • Upgrading To A New Release
    • Advanced
      • Canvas Control
      • DrawControl Part 1
      • DrawControl Part 2
      • DrawControl Part 3
      • SAX Like XML Processing
      • A Plug-In Architecture
      • A Simple Wizard Framework
      • An HTML Include Facility
      • An RSS 2 Feed Creator
      • MIME Generation
      • A New Add-on Facility
      • Workspace Improvement Hack
    • Mockito for Suneido
    • The Suneido Task Scheduler
    • Contributing To Suneido
    • Contributor Assignment of Copyright
    • Language Translation
    • Future Directions
    • Interview With Andrew Mckinlay
  • Forum
    • Announcements
    • Internals & Enhancements
    • Cookbook
    • General
  • FAQ
  • Screenshots
  • Downloads
  • Links

A curious quote

Integrated Application Platform › Forums › General › A curious quote

  • This topic has 2 replies, 2 voices, and was last updated 8 years, 2 months ago by ajith.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • November 19, 2014 at 10:11 am #798
    ajith
    Participant

    Hi,

    I was working with QueryView and found something curious:

    update dengueMaha where dateAdmn = "1.8.13 P" set doAdmn = ' $ Display(Date(day:1, month:8, year: 2013))

    -> works well! [Note that there is only one quote and not a pair]

    'update dengueMaha where dateAdmn = "1.8.13 P" set doAdmn = ' $ Display(Date(day:1, month:8, year: 2013))

    -> generates an error message [a pair of quotes]

    update dengueMaha where dateAdmn = "1.8.13 P" set doAdmn =  $ Display(Date(day:1, month:8, year: 2013))

    -> also generates error [no quotes]

    Are you able to get the same results? Why does QueryView need one quote and not a pair? Is it a bug?

    This doesnt give the result I want. How does one update a field to have a date?

    QueryDo('update dengueMaha where dateAdmn = ".7.13" set doAdmn = Date(day:15, month:7, year: 2013)')

    is throwing an error

    ajith

    November 19, 2014 at 3:02 pm #1117
    j_ferguson
    Moderator

    Hi Ajith,

    That behavior is a bit curious. It looks like it is assuming the one quote is the beginning of the string you are going to set doAdmn to. It seems if you are setting a column to a string in queryview, the last quote is not needed.

    If you query the table after the request, you’ll see it is not setting the value properly.

    If you want to set the field to a variable date you could use the following:

    QueryDo(‘update dengueMaha where dateAdmn = “1.8.13 P” set doAdmn = ‘ $ Display(Date(day:1, month:8, year: 2013)))

    If you are just setting to a date constant you can do:

    update dengueMaha where dateAdmn = “1.8.13 P” set doAdmn = #20130801

    November 20, 2014 at 6:03 am #1118
    ajith
    Participant

    Hi Jeff,

    Thanks for the reply. Both the ways you suggested are working.

    ajith

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.
Log In

Search Forums

Log In
Welcome to the new Suneido Web Site and Forum.
Register
Lost Password
users of the previous PHPBB Forum should be able to log in with their previous username and password.

Recent Topics

  • Alpha copy of gSuneido to play with
  • how to start jsuneido ?
  • Problem Starting Suneido…
  • Dialog not showing buttons
  • New link for Suneidojo

Contact Us | Legal Statement | Privacy Statement | SiteMap

Copyright © 2023 Axon® Development Corporation. All Rights Reserved. - Open Source Integrated Database and Programming Language