Re: [sqlite] .NET Assembly and VB Wrapper
Hello Greg, Can I see your code where the wrapper crashes . I have done some test with read-only directories and I don't get any crashes. the code is very simple: If FileExists(msDatabaseFile) Then mhDatabase = sqlite_open(msDatabaseFile, 0, msErrs) If msErrs = "" Then mvTableArray = ags_sqlite_get_table(mhDatabase, "PRAGMA empty_result_callbacks = ON;", msErrMsg) mbOpenDatabase = True Else mbOpenDatabase = False End If Else [ ... ] End If Best Regards Markus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] .NET Assembly and VB Wrapper
Hi Markus, Can I see your code where the wrapper crashes . I have done some test with read-only directories and I don't get any crashes. Regards Greg O -Original Message- From: Markus Huhn [mailto:[EMAIL PROTECTED] Sent: Wednesday, 7 January 2004 5:17 PM To: Greg Obleshchuk Cc: SQLite Users Subject: Re: [sqlite] .NET Assembly and VB Wrapper Hello Greg, >VB Wrapper changes >Introduced a new function called ags_number_of_rows_from_last_call, >which as the name suggests returns the number of rows from the last query run. This is help in the situation where the SQL command executed correctly but didn't return any rows. You should check this value before accessing the variant array. > > Thank you, this is a great Feature, because VB is not very funny, if i will check the empty return value :-( If have an other feature request. If i try to connect to a database on an network drive which has only Read-Rights, the Wrapper crashes. The command-line utility returns "Unable to open database". It is very useful, if the Wrapper can return also an Error Value. Best Regards Markus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] .NET Assembly and VB Wrapper
Hello Greg, VB Wrapper changes Introduced a new function called ags_number_of_rows_from_last_call, which as the name suggests returns the number of rows from the last query run. This is help in the situation where the SQL command executed correctly but didn't return any rows. You should check this value before accessing the variant array. Thank you, this is a great Feature, because VB is not very funny, if i will check the empty return value :-( If have an other feature request. If i try to connect to a database on an network drive which has only Read-Rights, the Wrapper crashes. The command-line utility returns "Unable to open database". It is very useful, if the Wrapper can return also an Error Value. Best Regards Markus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] .NET Assembly and VB Wrapper
Hello, I have updated my .NET Assembly and VB Wrapper for SQLite to support version 2.8.9. Both can be downloaded from http://www.ag-software.com/SQLite.aspx .NET Assembly Changes None VB Wrapper changes Introduced a new function called ags_number_of_rows_from_last_call, which as the name suggests returns the number of rows from the last query run. This is help in the situation where the SQL command executed correctly but didn't return any rows. You should check this value before accessing the variant array. Samples Changes Both updated regards Greg O