cur.execute ("CREATE TABLE IF NOT EXISTS Visitors (AD_SOYAD TEXT NOT NULL, TELEFON TEXT NOT NULL, FIRMA_ADI TEXT NOT NULL, KISI_BOLUM TEXT NOT NULL, ACIKLAMA TEXT NOT NULL, KART_NO NUMERIC NOT NULL, TARIH TEXT NOT NULL, GIRIS_SAATI TEXT NOT NULL, CIKIS_SAATI TEXT NOT NULL, ID INTEGER NOT NULL UNIQUE PRIMARY KEY AUTOINCREMENT)")
dbss:
[url=https://ibb.co/Smny6mb][img]https://i.ibb.co/B6Z3f6b/DB.png[/img][/url]
GUI ss:
[url=https://ibb.co/w77xGLK][img]https://i.ibb.co/f99P6SC/QT.png[/img][/url]
The number of GUI code characters is too many, but I am creating an example by reducing it. On other forums I will share the codes after miniaturization.
When I close the field below, the '#' GUI opens. The problem is all about this area.
/*#cur.execute("INSERT INTO Visitors (AD_SOYAD, TELEFON, FIRMA_ADI, KISI_BOLUM, ACIKLAMA, KART_NO, TARIH, GIRIS_SAATI, CIKIS_SAATI, ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, NULL)", (VisitorsName, VisitorsPhone, VisitorsCompany, VisitorsPersonDepartment, VisitorsExplanation, VisitorsCardNo, VisitorsDate, VisitorsIn, VisitorsOut))*/