Hi Mike, do you mean somethink like that? ' hide the title bars ' also to windows objects Option Explicit Declare "Function DrawMenuBar Lib ""user32"" (ByVal...
Hi guys. Spent a bit more time today working on a multi-user SQLite solution. Its a bit more in-depth than I originally thought it would be! Still, its coming...
#1: You're right. Unlike ADO, when you retrieve a recordset from SQLite the entire database is loaded into memory and manipulated there. The easiest way to...
Hello Michael, ... <<< That's normal when you dig deeper into the multi-user situation :-). Confusion gets worse the more you think about it. Sometimes the...
Hi Styskul, thats an excellent suggestion about using a second recordset. I could have the main recordset which contains all of the database information sorted...
Hi Thomas, thanks for info. I've been trying to get your suggestions working in response to my second question - Is it possible to update a single field in a...
Heiko mentioned the possibility of using TimeStamp Fields. Does that mean that there is a way of getting the time when a record is accessed or modified - not...
It really doesn't hurt to update all the columns in a row, especially since you have such a small amount of columns, but if you only want to save the changed...
I assume the users will be running the application of their desktop, correct? If so, the TimeStamp field will contain the date on the user's machine, not the...
Hi Styskul, thanks for the quick reply. This project is turning out to be painful! But I shall not be defeated! Still having problems unfortunately. Have tried...
I can't quite tell by your posted code what might be wrong, but I have uploaded a modified version of your original SQLiteTest.nsd to the files section that...
Thanks Styskul. Very interesting! My problem wasnt with the syntax of the UPDATE command, but with the way I was creating my database initially. This is your...
I think you might still have had some other error in your code. I just tried the sample I just uploaded with your table creation method, and it still worked...
Wierd. Anyway im cooking on gas now. All the record permissions (write, readonly or viewing) seem to be working robustly now. Just adding usernames and record...
I'm after a bit of 'real-world' advice here. Im looking at speed issues with SQL. Rather than update the recordset in memory as follows: Cmd="SELECT * FROM...
Generally, I wouldn't even load everything in memory at once. I'd do something more like this: Cmd = "SELECT Entry1 FROM NameDB ORDER BY Entry1" Set Lookup =...
You've given me some good ideas there for speeding-up my the database access. Off to do so rewritting (again!). Until now I have been doing everything within...
Hello Michael,
no, as SQLite isn't a client-server database system with a background process running on the server, there's no chance to get this done by a...
Hello,
I only read styskul's message after I wrote this; if you find a method to access the date on the server directly, that's of course much better than...
Hi Michael, just 1 remark about the 1st method to create your table: PRIMARY KEY is unique by definition, so the keyword "UNIQUE" isn't necessary in this...
Hello all - I have three questions about menus: 1. I have a project with multiple forms. The menu appears on all of them. How do I make the menus only appear...
Hi Dan, look into the language reference - setmenu. An example is in the sample files. And, I'm sorry, you have to organize the things by yourselfe ;) But the...
Hi, I'm new to using NSBasic and I'm actually using the demo version now. Does anyone know how to use NSBasic to execute Access database macros? An example...
MS Access Macros use VBA. NSBasic Desktop is based on VBScript. Therefore, MS Access Macros aren't useable directly. The most you could do is simply create a...
I don't have Access installed on my computer right now in order to verify this but something like this should work or at least point you in the right direction...
Hi George, if a textbox is Locked (TextBox.Locked=True) then you cannot TAB on the keyboard past the textbox that is Locked. This bug has been present since...
Ok, this brings up another question. If I send someone an Access db file (mdb) and an NSBasic exe that uses that mdb file, will the app work if that person...
It requires the user to have MDAC installed (ex. MDAC 2.6) along with the JET database drivers. These should already be there for Windows 2000 and XP. MDAC...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
