Comments (6)
I'm not sure what you're asking.
All your functions are returning 0, which means OK...
The demo routine tries to create a file in a temp directory, maybe that fails?
from sqliteforexcel.
Does the connection to Sqlite3.dll depend on any firewall settings?
Are there any security - options to switch in Excel?
By the way, I modified the path to a location that makes sense and commented out the kill statement.
TestFile = ThisWorkbook.Path + "\x64\TestSqlite3ForExcel.db3"
I also get run time error 53.
from sqliteforexcel.
No, the Sqlite3.dll is juat a library file that is read into the Excel process. There is not network stuff involved at all.
I don't know of any security options that affect these modules.
Error 53 means file not found. At which line to you get this?
You say your file access fails, but all your calls returned 0, meaning OK. So I don't really know where you are stuck.
Good luck...!
from sqliteforexcel.
Hi Govert, Any reason the exec statement is not included? I have a VBA program that updates many entries based on calculated values within excel, and calling Update many times through prepare, step, finalize is extremely slow, wondering if grouping into one "exec" command would be significantly faster.
Any advice is much appreciated!
Thanks,
Tom
from sqliteforexcel.
@pts925 From the documentation for sqlite_exec:
The sqlite3_exec() interface is a convenience wrapper around sqlite3_prepare_v2(), sqlite3_step(), and sqlite3_finalize(), that allows an application to run multiple statements of SQL without having to use a lot of C code.
It's tricky to implement in VBA if we're to support the callback function, and I doubt it would make much difference to the performance. You can do the same with regular API calls, and those will be extremely fast anyway. And performance bottlenecks you have in doing updates are due to the database, not the C API calls.
For better insert or update performance you should use transactions - these are called as regular statements.
from sqliteforexcel.
Wow, using a transaction much much better (clearly I am a novice). Thanks so much for your help!
from sqliteforexcel.
Related Issues (18)
- DateValue in demos is culture specific HOT 2
- Any dependency? HOT 2
- far slower reading data from cursor in Office 365 due to character encoding HOT 12
- How to get SQLite's window functions available since SQLite 3.25? HOT 1
- Support for encrypted databases HOT 1
- Issue with latest SQlite DLL HOT 2
- How to add SQLite Amalgamation function to SQLiteForExcel HOT 1
- Date error in some excel regions HOT 1
- Latest VBA engine compatibility HOT 1
- 64bit version crashes HOT 3
- Backup API does not work on 64-bit Excel HOT 13
- Timestamp support HOT 3
- Fichier introuvable : SQLite3_StdCall
- Please explain how SQLiteForExcel_64.xlsmworks in a simple example
- support for sqlite see (encryption)? HOT 1
- sqlite dot-commands HOT 1
- Implement Int64 support
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqliteforexcel.