Topic: SOLVED: Problem with Tablegrid and SQL Statement
Dear Dimitry,
I get the attached error Message from Version 3.4 on a SQL statement which I use to fill a table grid.
Rechnerverwaltung.RSoftware.sqlValue := ('select software.id,software.softwarename from software left outer join softwarerechner on software.id=softwarerechner.id_software where softwarerechner.id_rechner='+inttostr(rechnerid));
Table structure:
SOFTWARE:
isdictionary=0
_Softwarename=TEXT
_Erfassung=DATETIME
_LetzteAenderung=DATE
_Bemerkungen=TEXT
_Freeware=BOOLEAN
_Lizenziert=BOOLEAN
_Demo=BOOLEAN
_Eigenentwicklung=BOOLEAN
_Shareware=BOOLEAN
_Sonderlizenz=BOOLEAN
%CALC_LizenzenTotal=(select count(ID) from Lizenzen where lizenzen.id_Software ^equally^ software.ID)\r\n
%CALC_LizenzenBenutzt=(select count(ID) from SoftwareRechner where SoftwareRechner.id_Software ^equally^ software.ID)\r\n
RECHNER:
isdictionary=0
_Rechnername=TEXT
_IP=TEXT
_Bemerkung=TEXT
_Erfassung=DATETIME
_LetzteAenderung=DATE
_Subnet=TEXT
_Seriennummer=TEXT
_Server=BOOLEAN
_Workstation=BOOLEAN
_Firewall=BOOLEAN
_Router=BOOLEAN
_USV=BOOLEAN
_Webcam=BOOLEAN
_Drucker=BOOLEAN
_NAS=BOOLEAN
_Sonstiges=BOOLEAN
_Notebook=BOOLEAN
SOFTWARERECHNER:
isdictionary=0
>id_Rechner=Rechner
>id_Software=Software
Its for a n:n relation. One "Rechner" can have many "Software" and one "Software" can be installed on many "Rechner"
DB Browser for SQLite is working with this statement, but not MyVisualDatabase.
Any idea?
Complete project is in german language and can be send only to you by email. Its not a public application.