Hallo Klaus,
hier der Code des Cardscripts:
[Code]local sDatabaseID
command setDatabaseID pDatabaseID
put pDatabaseID into sDatabaseID
end setDatabaseID
function getDatabaseID
return sDatabaseID
end getDatabaseID
command databaseConnect
local tDatabasePath, tDatabaseID
## gebraucht wenn db im selben Verzeichnis
## set itemDel to “/”
## set the defaultFolder to item 1 to -2 of (the effective fileName of this stack)
## The database must be in a writeable location
put specialfolderpath(“documents”) & “/graphik.db” into tDatabasePath
put specialfolderpath(“documents”) & “/graphik.db” into tZielDatei
if there is NOT a file tZielDatei then
answer “DB Datei nicht vorhanden!”
exit to top
end if
## Open a connection to the database
## If the database does not already exist it will be created
put revOpenDatabase(“sqlite”, tDatabasePath, , , , ) into tDatabaseID
## Store the database id so other handlers can access it
setDatabaseID tDatabaseID
end databaseConnect
command read_database
local tData
put 2 into schluessel
put 0 into x
put getDatabaseID() into tDatabaseID
repeat while schluessel <=13
add 1 to x
put “SELECT Monat from Temperaturen WHERE Lfd_Nr=” & schluessel into tSQL
— query the database
put revDataFromQuery(tab,return,tDatabaseID,tSQL) into tMonat
if tMonat begins with “revdberr” then
answer “Error:” && tMonat
end if
put “SELECT Grade_1 from Temperaturen WHERE Lfd_Nr=” & schluessel into tSQL
— query the database
put revDataFromQuery(tab,return,tDatabaseID,tSQL) into tGrade_1
put “SELECT Grade_2 from Temperaturen WHERE Lfd_Nr=” & schluessel into tSQL
— query the database
put revDataFromQuery(tab,return,tDatabaseID,tSQL) into tGrade_2
put tMonat & “,” & tGrade_1 & “,” & tGrade_2 into tData[x]
add 1 to schluessel
end repeat
put tData[1] & return & tData[2] & return & tData[3] & return & tData[4] & return & tData[5] & return & tData[6] & return & tData[7] & return & tData[8] & return & tData[9] & return &tData[10] & return &tData[11] & return & tData[12] into tData
set the graphData of widget “Line Graph” to tData
end read_database
[/Code]
Habe deine oben erwähnten Prüfungen eingebaut. Keine der beiden zeigt eine Meldung.
Die Fehlermeldung weiterhin:
Error revdberr DatabaseError No such table: Temperaturen
Muss die Endeung .db angegeben werden? Spielt Groß-/Kleinschreibung eine Rolle?
Gruße
