Hi Simon ,
Thank you for your fast reply:
SO: Windows 7.
VB.net 2010
//
OpenConnection(TMP_ConnectionString, OBJ_Connection)
sql= "UPDATE ANG_Operatori Set NomeOperatore = 'Amministratore',UserID =
'admin',ParolaChiave = 'prova',DataUltimoAccesso = '08/04/2012
15:04:00',Supervisore = 1,ID_Dentista = 1 where ID_ANG_Operatore = 1"
Execute("BEGIN TRANSACTION") '''''''''''''''''''''("BEGIN EXCLUSIVE
TRANSACTION")
Execute(SQL)
Execute("END TRANSACTION")
//
With this code the db don't save.
If I add 'EXCLUSIVE' the program stop after 30 seconds and return "The
database file is locked"
If I remove the transaction some result.
With MS access this query work without need to insert transaction.
How I can solve this problem ?
thank you !
Marco
Simon Slavin-3 wrote:
>
>
> On 8 Apr 2012, at 2:32pm, marco1 <i...@pro-software-support.it> wrote:
>
>> Hi , I don't know how is possible save record with Sqlite.
>>
>> I was try i different way:
>>
>> 1) With vb.net updatecommand (The database file is locked)
>> 2) With "Insert Into" (The database file is locked)
>> 3) With transaction Begin ..... Commit (The database file is locked)
>
> Which operating system are you running ?
>
> What programming language are you using ?
>
> What is the development environment you're using ?
>
> Please show us the command you're using to specify which file on disk you
> are opening.
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/Update-problem-with-Sqlite-%28one-PC-one-single-operation%29-Vb.net-tp33651706p33651759.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
