Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DPaul1994
  • Content: Threads
  • Order by date
  1. DPaul1994

    SQLite update syntax

    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'"...
  2. DPaul1994

    SQLite encryption hashing with SHA1 or KDF

    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...
  3. DPaul1994

    Connection to MySql error

    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()...
  4. DPaul1994

    2 table in one button

    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...
  5. DPaul1994

    Report sum of all columns

    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?
  6. DPaul1994

    Update textbox value

    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...
  7. DPaul1994

    Multiplication of numeric with decimals

    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?
  8. DPaul1994

    Data type mismatch (numeric)

    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.

Part and Inventory Search

Back
Top