🤘 0 reputation

PShute

Standard

Joined: 6/6/2019

Last seen: 6/7/2019

Activity
  • It looks like the database is sqlite. select sqlite_version returns 3.27.2. I found this list of string functions: https://www.guru99.com/sqlite-functions.html

    Instead of select left(Applications.Name,5) from Applications I used select substr(Applications.Name,1,5) from Applications

  • The answer was to rename one of the columns called Name. Eg. select Applications.Name as App , Computers.Name from Computers left join Applications on Applications.ComputerId=Computers.ComputerID

    The message that was coming up was offering to submit a bug report, but if I looked closer, in among the diagnostic information it says "Error : A column named 'Name' already belongs to this DataTable."

    Strange way to offer diagnostic information.

  • SQL functions list?
  • SQL query crashing