Clomosy | Forum : SQL Bağlantı Sorunu https://forum.clomosy.com.tr/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 29 Jul 2026 12:24:59 +0000 Wed, 29 Jul 2026 10:15:35 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.07 30 https://forum.clomosy.com.tr/RSS_post_feed.asp?TID=1637 <![CDATA[Clomosy | Forum]]> https://forum.clomosy.com.tr/forum_images/logo.png https://forum.clomosy.com.tr/ <![CDATA[SQL Bağlantı Sorunu : Merhaba Enes,Kodun devamını göremiyorum...]]> https://forum.clomosy.com.tr/forum_posts.asp?TID=1637&PID=3794#3794 Yazar: Emr.Erkmn
Konu: 1637
Gönderim Zamanı: 29 Temmuz 2026 Saat 10:15

Merhaba Enes, 

Kodun devamını göremiyorum ama sql bağlantın mevcut mu?

Veri eklemek için 

var
  MyForm : TclForm;
  editUserName , editUserPhone , editUserEmail , editUserPassword , editUserRole , editUserDate : TclProEdit;
  btnInsert : TClProButton;
  insertQuery : TclSqlQuery;
  
void InsertToDatabase;
{
  Clomosy.DBSQLServerQuery.Sql.Text = 'INSERT INTO Users (UserID, UserFullName, UserPhone, UserEmail, UserPasswordHash, UserRole, CreateDate) VALUES (10, ' + 
    QuotedStr(editUserName.Text) + ', ' + 
    QuotedStr(editUserPhone.Text) + ', ' + 
    QuotedStr(editUserEmail.Text) + ', ' + 
    QuotedStr(editUserPassword.Text) + ', ' + 
    QuotedStr(editUserRole.Text) + ', ' + 
    QuotedStr(editUserDate.Text) + ')';
    
  Clomosy.DBSQLServerQuery.Open;
  ShowMessage('insert işlemi tamamlandı');
}

kullanabilirsin
https://static.cloudflareinsights.com/beacon.min.js/v4513226cdae34746b4dedf0b4dfa099e1781791509496" integrity="sha512-ZE9pZaUXND66v380QUtch/5sE9tPFh2zg45pR2PB0CVkCtOREv2AJKkSidISWkysEuQ0EH8faUU5du78bx87UQ==" data-cf-beacon="{"version":"2024.11.0","token":"439455f3e46c40b98dbd42a2f1a954d8","r":1}" crossorigin="anonymous">]]> Wed, 29 Jul 2026 10:15:35 +0000 https://forum.clomosy.com.tr/forum_posts.asp?TID=1637&PID=3794#3794 <![CDATA[SQL Bağlantı Sorunu : RUNTIME ERRORFile library Main:...]]> https://forum.clomosy.com.tr/forum_posts.asp?TID=1637&PID=3793#3793 Yazar: AcarPlus
Konu: 1637
Gönderim Zamanı: 29 Temmuz 2026 Saat 09:46

RUNTIME ERROR
File library Main: Could not convert variant of type (UnicodeString) into type (Double) when evaluating instruction OperAdd ($0,$0,$0,$0,'').
Stack content is: [2569648557504,2569648450080,2569718091152,2569718087536...].
Source position: 9,242
Position: 9, 242
ilgili kod bloğu:
var MyForm : TclForm; editUserName , editUserPhone , editUserEmail , editUserPassword , editUserRole , editUserDate : TclProEdit; btnInsert : TClProButton; insertQuery : TclSqlQuery; void InsertToDatabase;{ Clomosy.DBSQLServerQuery.Sql.Text = 'INSERT INTO Users (UserID , UserFullName , UserPhone , UserEmail , UserPasswordHash , UserRole , CreateDate) VALUES (10 , ' +editUserName.Text+ ' , ' +IntToStr(editUserPhone.Text)+ ' , ' +editUserEmail+ ' , ' +IntToStr(editUserPassword)+ ' , ' +editUserRole+ ' , ' +editUserDate+')'; ShowMessage('insert işlemi tamamlandı');
}

Göderilmek İstenen Tablo Tasarımı:


UserID int UncheckedUserFullName varchar(100) UncheckedUserPhone varchar(10) UncheckedUserEmail varchar(100) CheckedUserPasswordHash varchar(320) UncheckedUserRole char(1) UncheckedCreateDate date Unchecked
https://static.cloudflareinsights.com/beacon.min.js/v4513226cdae34746b4dedf0b4dfa099e1781791509496" integrity="sha512-ZE9pZaUXND66v380QUtch/5sE9tPFh2zg45pR2PB0CVkCtOREv2AJKkSidISWkysEuQ0EH8faUU5du78bx87UQ==" data-cf-beacon="{"version":"2024.11.0","token":"439455f3e46c40b98dbd42a2f1a954d8","r":1}" crossorigin="anonymous">]]> Wed, 29 Jul 2026 09:46:07 +0000 https://forum.clomosy.com.tr/forum_posts.asp?TID=1637&PID=3793#3793