Author Topic: Query language  (Read 2671 times)

0 Members and 1 Guest are viewing this topic.

Kyle

  • Newbie
  • *
  • Posts: 11
    • View Profile
Query language
« on: July 19, 2020, 04:51:06 AM »
Planetdance Help gives an example of using isaspect in this way: 'isaspect(0, sun, moon, square, 5) = 1'. However, Query language does not find variable 'square' (nor 'conjunction' or 'opposition').

Conversely, it runs if in all caps as per AstroBasic help: 'isaspect(1, SUN, MOON, CONJUNCTION) = 0'. So this seems inconsistent with e.g. 'distance(sun,moon)<10'.
« Last Edit: July 19, 2020, 02:26:20 PM by Kyle »

Jean

  • Administrator
  • Hero Member
  • *****
  • Posts: 1312
    • View Profile
Re: Query language
« Reply #1 on: July 19, 2020, 07:16:38 PM »

Thanks Kyle.I changed the helpfile for that example.


This is another example.
Code: [Select]

isdeclaspect(jupiterdec, saturndec, 3) = 1
and
isaspectx(jupiter, saturn, CONJUNCTION, 3) = 1



Greetings from Groningen Netherlands.

Kyle

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: Query language
« Reply #2 on: July 19, 2020, 11:33:32 PM »
That explains why I couldn't get isaspect or isaspectx to work. Thanks for the update Jean!

Jean

  • Administrator
  • Hero Member
  • *****
  • Posts: 1312
    • View Profile
Re: Query language
« Reply #3 on: July 20, 2020, 07:50:25 AM »
Forgot to say, if you are curious, those queries generate scripts that do the work, they are here.
Code: [Select]
C:\Planetdance\time\query.ab
c:\planetdance\db\query.ab
Greetings from Groningen Netherlands.