Search results for query: *

I have a code in C# that should update a column form my table. Table is `accounts`, row is `totalsimyes` and new value that should be inserted in column is `totalsimda`. string updatecorect = "select totalsimyes from accounts where username = 'DPaul'"...

Hi everyone. I have an application which uses a SQLite database. In database, I have a table and in one column, I have a value inserted from SQL code which is encrypted with sha1. But, I want to use it in my C# application like this: cmd.CommandText = "Select * from accounts where...

Hi guys. I have a form where I have some labels, checkboxes and a button. For connection to MySql I have a class named ConnConfig and functions for open and closing connection(if needed, closeConn(), openConn()). So, I have a function which extracts from database some data: private void select()...

Hi. I want to use 2 free tables in one button. For example I have a textbox named Text1. I want to replace in 'tabel1' the 'tabel1.value1' with Text1 value and in 'tabel2.value1' with same value. I tried to use simple those 2 table, but I receive: File is in use. If I try to close tables after...

Hi guys. I have a report with 3 columns. One of columns is called "price". I want to insert in report one field where to store the sum of all "price" values from the report. Is that possible?

Hi. Let's just say I have a checkbox named Text1 and a checkbox named Text2. I would like to do this: if Text1 is empty, Text2 = 1 else Text2 = Text1 (thisform.Text1.Value, thisform.Text2.Value) How cna I do this? I tried like this: if empty(thisform.Text1.Value) thisform.Text2.value = 1 else...

Hi there. I want to multiplicate 5 numbers, each one with 2 decimals, but the final result have only 2 decimals. Anyone know how to do that?

I have a form with a textbox named Text1 and InputMask is set: 999.99 In free table, the column where I want to insert this value is numeric type with 2 decimals. But when I try to replace table_name.column with thisform.Text1.Value I receive: Data type mismatch. How can I solve this? Thanks.