DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Author Topic: Error: SQL query and Gruop-Icon  (Read 9,093 times)

AbteriX

  • Member #520
  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Posts: 1,150
Error: SQL query and Gruop-Icon
« on: August 15, 2005, 01:51 PM »
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.
Greetings, Stefan.

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,931
    • Gathering Badge
    • Plugin Coding Medal
    • Participated in NANY Challenge Seventeen Times
    • Cody Award
    • Coding Snacks
    • Volunteers/Staff
Re: Error: SQL query and Gruop-Icon
« Reply #1 on: August 15, 2005, 02:18 PM »
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

  • Member #520
  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Posts: 1,150
Re: Error: SQL query and Gruop-Icon
« Reply #2 on: August 15, 2005, 03:11 PM »
Thanks.

Iam think this Quick paste example is not correct ?

Code
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"
Code
.... DateTimeMinusTwoDays .....
...... the last two days....
isn't it ?
Greetings, Stefan.

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,931
    • Gathering Badge
    • Plugin Coding Medal
    • Participated in NANY Challenge Seventeen Times
    • Cody Award
    • Coding Snacks
    • Volunteers/Staff
Re: Error: SQL query and Gruop-Icon
« Reply #3 on: August 15, 2005, 03:16 PM »
yes you are right

Original address: https://www.donationcoder.com/forum/index.php?topic=706.0