Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB Tools

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 04-12-2013, 08:28 PM
mibo4you mibo4you is offline
Junior Member
 
Join Date: Oct 2010
Posts: 5
Question SQlite help :)

How can i make this to insert value from editbox to sql

'INSERT INTO mytable(Name,OtherID,Number,Notes) VALUES ("Another Name",12,4758.3265,"More notes");';

I will have like 'INSERT INTO mytable(Name,OtherID,Number,Notes) VALUES (editbox1.text,editbox2.text,memo1.text);';
Reply With Quote
  #2  
Old 04-12-2013, 08:31 PM
mibo4you mibo4you is offline
Junior Member
 
Join Date: Oct 2010
Posts: 5
Default

how to input edit.text in sql question sqlite
Reply With Quote
  #3  
Old 04-13-2013, 06:36 PM
mibo4you mibo4you is offline
Junior Member
 
Join Date: Oct 2010
Posts: 5
Default

Quote:
Originally Posted by mibo4you View Post
how to input edit.text in sql question sqlite
Yes i mean that, or with variable
like name :=edit1.text;
Reply With Quote
  #4  
Old 04-16-2013, 06:47 PM
mibo4you mibo4you is offline
Junior Member
 
Join Date: Oct 2010
Posts: 5
Default have also try

sSQL := 'INSERT INTO testtable(Name,OtherID) values('+QuotedStr(Edit1.Text);';

but get error (red underline) on last ;
Reply With Quote
Reply

Tags
insert into, sql, sqlite

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:46 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.