Member Avatar for uncertainty
uncertainty 0 Newbie Poster

How do I insert variables with data type as DOUBLE?
like in the code below, it is how you insert strings into mysql

myconnection->myquery->SQL->Clear();
myconnection->myquery->SQL->Add("insert into users (user,pass,email)");
myconnection->myquery->SQL->Add("values ('"+user->Text+"', '"+pass->Text+"', '"+email->Text+"')");
myconnection->myquery->ExecSQL();

in this statement:

myconnection->myquery->SQL->Add("insert into users (user,pass,email)");

user, pass and email are fields of users table, while in the statement below:

myconnection->myquery->SQL->Add("values ('"+user->Text+"', '"+pass->Text+"', '"+email->Text+"')");

user, pass and email are Edit boxes with Text as attribute, given that the value of Text is the string inputed by the user.

i need help on inserting values with DOUBLE data type, thanks

  • 1 Contributor
  • 0 Replies
  • 72 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.