[Xojo] 5.4b8 SQL_Problem

[Karl Grob]

Hi,   Since yesterday I get a immediate crash with this one

DB is open, in Studio there is no problem, but wooms (no error at all)

--------
dim cmd as string
 dim cur as VCursor

 if parent <= 0  then
   cmd = "SELECT ** FROM " + TBL_Inhalt.name + " WHERE " + TBL_Inhalt.ptrToParent.Name + " IS NULL AND " + _
   TBL_Inhalt.fldETextFile.name + " IN ('THEIN', 'TSELD' , 'TZUER' , 'TSINN','TLEGEND', 'TSAL', 'TGED', 'THEINA', 'TGEDA', 'TGEDH', 'TGEDNG', 'TGEDV',  'TNOTIZ', 'TPROS', 'TAC', 'TAUFS')"
 else
   cmd = "SELECT ** FROM " + TBL_Inhalt.name + _
   " WHERE " + TBL_Inhalt.ptrToParent.Name + " = " + str(parent) + " AND " +  _
   TBL_Inhalt.fldETextFile.name + " IN ('THEIN', 'TSELD' , 'TZUER' , 'TSINN','TLEGEND', 'TSAL', 'TGED', 'THEINA', 'TGEDA', 'TGEDH', 'TGEDNG', 'TGEDV',  'TNOTIZ', 'TPROS', 'TAC', 'TAUFS')"
 end if
 if myDB <> NIL then
------------

Before I had this:
   cmd = "SELECT ** FROM " + TBL_Inhalt.name + " WHERE " + TBL_Inhalt.ptrToParent.Name + " IS NULL AND (" + _
   TBL_Inhalt.fldETextFile.name + " = " + "'THEIN' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TSELD' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TZUER' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TSINN' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TLEGEND' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TSAL' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TGED' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'THEINA' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TGEDA' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TGEDH' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TGEDNG' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TGEDV' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TNOTIZ' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TPROS' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TAC' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TAUFS')" // OR" + _
   //TBL_Inhalt.fldETextFile.name + " = " + "'

 else
   cmd = "SELECT ** FROM " + TBL_Inhalt.name + " WHERE " + TBL_Inhalt.ptrToParent.Name + " = " + str(parent) + " AND (" +  _
   TBL_Inhalt.fldETextFile.name + " = " + "'THEIN' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TSELD' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TZUER' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TSINN' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TLEGEND' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TSAL' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TGED' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'THEINA' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TGEDA' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TGEDH' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TGEDNG' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TGEDV' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TNOTIZ' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TPROS' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TAC' OR " + _
   TBL_Inhalt.fldETextFile.name + " = " + "'TAUFS')"
 end if
 if myDB <> NIL then
 -------------

Not very elegant and it made wooms too.

The  strange thing is: If I build the Table 'TBL_Inhalt' (a rather complex import) with a flush at the end and open then the Window with this statement, it works. (Until 2 days ago it worked (with 5.4b!), but I am not shure If I ever tried to open the Window directly after reopening the DB - The import-statements are not yet finished and probably I just tried after adding new statements.)
In Studio the links (hierarchical) work fine, but if I reopen the DB, it crashes. Other SQL-Statements do work.

Any suggestion?

Thanks
Karl


Mac Pro 10.8.4