Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • December 08, 2016, 04:05:59 PM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Error: SQL query and Gruop-Icon  (Read 4531 times)

AbteriX

  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Posts: 1,115
    • View Profile
    • Donate to Member
Error: SQL query and Gruop-Icon
« on: August 15, 2005, 08:51:40 AM »
I create a new gruop
 with SQL "ModificationDateTime >= DateTimeMinusTwoDays  AND NOT IsInRecycleBin"

gives me an DBISAM error # 10051 Invalid column name "IsInRecycleBin"

If i delete "  AND NOT IsInRecycleBin" the gruop works.



2.)

if i choose an icon for this new group
i get the icon what is above the icon i choosed.

So i had to choose an icon below the icon i want
to get the icon i want.

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,417
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Error: SQL query and Gruop-Icon
« Reply #1 on: August 15, 2005, 09:18:05 AM »
IsInRecyleBin is failing because of a spelling mystake in my program that is looking for IsInRecyleBin instead of IsInRecycleBin.
i will fix in next version coming out this week.

i'm experiencing same problem as you now in group icon, i will fix that too!
thanks for the bug report - lot's of improvements on the way for this program.

AbteriX

  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Posts: 1,115
    • View Profile
    • Donate to Member
Re: Error: SQL query and Gruop-Icon
« Reply #2 on: August 15, 2005, 10:11:31 AM »
Thanks.

Iam think this Quick paste example is not correct ?

ex. ModificationDateTime > DateTimeMinusTwoDays  AND NOT IsInRecycleBin
will show all items added in the last two weeks that is not currently in the recyclebin

should be "two days"
.... DateTimeMinusTwoDays .....
...... the last two days....
isn't it ?

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,417
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Error: SQL query and Gruop-Icon
« Reply #3 on: August 15, 2005, 10:16:44 AM »
yes you are right