I find out where is the problem, but I don't really know how to solve it. That is the code. THe problem is dat `database is locked`. Which means, when I open that select, I can't use that update because i already have an opened select. But I;m looking for a solution without using oepn() and...
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'"...
...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 (username=@username and password=sha1(@password));";
cmd.Parameters.AddWithValue("@password", password);
OR...
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()...
This is source code:
SELECT bilete
LOCATE FOR thisform.Text13.Value = serie
IF FOUND()
thisform.Text13.Value = INT(RAND() * 1000)
endif
GO BOTTOM
APPEND BLANK
replace bilete.cod1 WITH thisform.Text1.value, bilete.cod2 WITH thisform.Text2.value,bilete.cod3 WITH thisform.Text3.Value,bilete.cod4...
I managed to fix it, but now, when I insert records via form, I reset all textbox fields with initial value (0) and return, but if I try to insert another records in same session, I receive: File is in use. I know this concept from C#, I guess that the table is not closed after first attempt
I tried those solutions but no one works for me, I guess because I have to use also "go bottom" and "append blank" for each table..so I can't use them without "select table", right?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.