Re: :MEMORY: databases and Windows
On 2022-03-16 22:07, Bob Sneidar via use-livecode wrote: Once again you nailed it. Still, this is a bug, minor though it may be. In the past I was told that it MUST be capitalized. Now it seems capitalized only works on the mac while all lowercase works on both platforms. squared. FWIW I don't think this is a bug. In the SQLite documentation it explicitly states ':memory:' lowercase. We don't process the filename we pass to the SQLite library, so I can't explain the difference between macOS and Windows. Looking at the sqlite sourcecode - it does a case-sensitive comparison between the filename passed and ':memory:'. So, I suggest using ':memory:' as stated by SQLite and all will be well :) Warmest Regards, Mark. -- Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/ LiveCode: Everyone can create apps ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: :MEMORY: databases and Windows
Once again you nailed it. Still, this is a bug, minor though it may be. In the past I was told that it MUST be capitalized. Now it seems capitalized only works on the mac while all lowercase works on both platforms. squared. Bob S > On Mar 16, 2022, at 15:00 , matthias rebbe via use-livecode > wrote: > > You don't have to... ;) > > I assume you wrote :MEMORY: in capital letters, right. > > Write it in lower letters :memory: and it should work. I just tested it > successfully with :memory: > > > >> Am 16.03.2022 um 22:54 schrieb Bob Sneidar via use-livecode >> : >> >> OK I'll open a bug report. >> >> Bob S >> >> >>> On Mar 16, 2022, at 14:51 , matthias rebbe via use-livecode >>> wrote: >>> >>> I just tested under Win in the IDE, it does not work there either. >>> >>> Error message is 'Database Error: Unable to open the database file' >>> >>> >>> Am 16.03.2022 um 22:32 schrieb Tom Glod via use-livecode : Whats the error message you get when you check the result of databaseconnect? ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode >>> >>> >>> ___ >>> use-livecode mailing list >>> use-livecode@lists.runrev.com >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> >> ___ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: :MEMORY: databases and Windows
Wow. Why does it work on MacOS I wonder?? Bob S > On Mar 16, 2022, at 15:00 , matthias rebbe via use-livecode > wrote: > > You don't have to... ;) > > I assume you wrote :MEMORY: in capital letters, right. > > Write it in lower letters :memory: and it should work. I just tested it > successfully with :memory: > > > >> Am 16.03.2022 um 22:54 schrieb Bob Sneidar via use-livecode >> : >> >> OK I'll open a bug report. >> >> Bob S >> >> >>> On Mar 16, 2022, at 14:51 , matthias rebbe via use-livecode >>> wrote: >>> >>> I just tested under Win in the IDE, it does not work there either. >>> >>> Error message is 'Database Error: Unable to open the database file' >>> >>> >>> Am 16.03.2022 um 22:32 schrieb Tom Glod via use-livecode : Whats the error message you get when you check the result of databaseconnect? ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode >>> >>> >>> ___ >>> use-livecode mailing list >>> use-livecode@lists.runrev.com >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> >> ___ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: :MEMORY: databases and Windows
You don't have to... ;) I assume you wrote :MEMORY: in capital letters, right. Write it in lower letters :memory: and it should work. I just tested it successfully with :memory: > Am 16.03.2022 um 22:54 schrieb Bob Sneidar via use-livecode > : > > OK I'll open a bug report. > > Bob S > > >> On Mar 16, 2022, at 14:51 , matthias rebbe via use-livecode >> wrote: >> >> I just tested under Win in the IDE, it does not work there either. >> >> Error message is 'Database Error: Unable to open the database file' >> >> >> >>> Am 16.03.2022 um 22:32 schrieb Tom Glod via use-livecode >>> : >>> >>> Whats the error message you get when you check the result of >>> databaseconnect? >>> ___ >>> use-livecode mailing list >>> use-livecode@lists.runrev.com >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> >> ___ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: :MEMORY: databases and Windows
OK I'll open a bug report. Bob S > On Mar 16, 2022, at 14:51 , matthias rebbe via use-livecode > wrote: > > I just tested under Win in the IDE, it does not work there either. > > Error message is 'Database Error: Unable to open the database file' > > > >> Am 16.03.2022 um 22:32 schrieb Tom Glod via use-livecode >> : >> >> Whats the error message you get when you check the result of >> databaseconnect? >> ___ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: :MEMORY: databases and Windows
Curiously, this works fine in a MacOS standalone. I think there may be an issue with Windows and :MEMORY: databases. Bob S > On Mar 16, 2022, at 14:49 , Bob Sneidar via use-livecode > wrote: > > I get an error creating the database. I went back into my code and checked > that the database id was an integer upon creation and it was not. > > Bob S > > >> On Mar 16, 2022, at 14:32 , Tom Glod via use-livecode >> wrote: >> >> Whats the error message you get when you check the result of >> databaseconnect? >> ___ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: :MEMORY: databases and Windows
I just tested under Win in the IDE, it does not work there either. Error message is 'Database Error: Unable to open the database file' > Am 16.03.2022 um 22:32 schrieb Tom Glod via use-livecode > : > > Whats the error message you get when you check the result of > databaseconnect? > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: :MEMORY: databases and Windows
I get an error creating the database. I went back into my code and checked that the database id was an integer upon creation and it was not. Bob S > On Mar 16, 2022, at 14:32 , Tom Glod via use-livecode > wrote: > > Whats the error message you get when you check the result of > databaseconnect? > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: :MEMORY: databases and Windows
Whats the error message you get when you check the result of databaseconnect? ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: :MEMORY: databases and Windows
Which LC version are you using? Does it work in the Windows IDE? Did it work already in the past with other LC editions? There are some things that do not work on single platforms after the big rework on the LC DB drivers in v7 in general. E.g. ODBC connection strings on macOS do not work anymore since v7, but still work on Windows. Maybe this does not work on Windows, although it works on Mac. But that is just a guess. > Am 16.03.2022 um 22:09 schrieb Bob Sneidar via use-livecode > : > > Hi all. > > I have a simple app that creates a :MEMORY: sqLite database, then populates > it with some small bit of data. On the Mac in the IDE it works fine, but in a > Windows standalone, it fails to create the database. I have manually included > the sqLite and database libraries in the standalone settings. What else do I > require? > > Bob S > > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode