Search found 131 matches

by NathanH
Wed Jan 14, 2026 12:21 am
Forum: General programming
Topic: Help with SQLite Prepared Statements
Replies: 2
Views: 244

Re: Help with SQLite Prepared Statements

Thanks lazi,

I was using stmt:step() when I should be using stmt:dostep(). That should make all the difference in the world. Thanks very much!!

NathanH
by NathanH
Tue Jan 13, 2026 10:13 pm
Forum: Wishlist
Topic: Caveats added to readme of SQLite wrapper
Replies: 0
Views: 95

Caveats added to readme of SQLite wrapper

Hi, The latest sqlite version on Aminet for all amigoids is 3.34a. This version is 100s of times faster than the 3.6.1 version it replaced so is my preferred setup. Using this version from the shell accepts views with CTEs and window functions and accepts partial indices. The current SQLite wrapper ...
by NathanH
Thu Jan 08, 2026 8:16 pm
Forum: General programming
Topic: Help with SQLite Prepared Statements
Replies: 2
Views: 244

Help with SQLite Prepared Statements

Hi, I recently ventured into this area while trying to optimize some code. I have had success using prepared statements with SELECT queries and For row In stmt:rows(sql$). I haven't been able, however to use them with an INSERT or UPDATE action query. I tried stmt:exec() and get an error and stmt:St...
by NathanH
Tue Oct 21, 2025 5:16 pm
Forum: Wishlist
Topic: AROS x86_64 bit
Replies: 2
Views: 3370

AROS x86_64 bit

Hi, You've probably been asked this a million times but reading some of the threads on AROSWorld it looks like 32-bit AROS is pretty much legacy now with all development focusing on 64-bit. Deadwood is writing an emulator so it can also run 32-bit apps and Hollywood itself and its apps are a big par...
by NathanH
Thu Sep 11, 2025 3:35 pm
Forum: Hollywood bugs
Topic: HollywoodPlayer crashes on Apple M1 Max
Replies: 2
Views: 1281

Re: HollywoodPlayer crashes on Apple M1 Max

That did the trick! Sorry I didn't catch that in the FAQ about HollywoodPlayer. Thanks for the help, he can run some of my applets now.

NathanH
by NathanH
Thu Sep 11, 2025 2:46 pm
Forum: General programming
Topic: How to tell if a file is a valid sqlite database?
Replies: 5
Views: 1599

Re: How to tell if a file is a valid sqlite database?

Thanks guys, that's perfect.

NathanH
by NathanH
Wed Sep 10, 2025 10:20 pm
Forum: General programming
Topic: How to tell if a file is a valid sqlite database?
Replies: 5
Views: 1599

How to tell if a file is a valid sqlite database?

Hi, I thought that I could trap an error in trying to open a file that isn't a database with the following code. It still gives a Hollywood error message though. Am I doing something wrong or is there another way to test the file? Thanks. NathanH @DISPLAY 1, {hidden=True} @REQUIRE "sqlite3"...
by NathanH
Wed Sep 10, 2025 5:07 pm
Forum: Hollywood bugs
Topic: HollywoodPlayer crashes on Apple M1 Max
Replies: 2
Views: 1281

HollywoodPlayer crashes on Apple M1 Max

Hi, My brother tried the HollywoodPlayer HWPlayer_MacOS_arm64.dmg for "Apple Silicon" on his Apple M1 Max machine. Its got 64Gb RAM and is running macOS Sequoia 15.6.1. When he tried to run it he got a requestor stating "HollywoodPlayer is damaged and can't be opened. You should move ...
by NathanH
Sat Aug 30, 2025 4:44 am
Forum: Wishlist
Topic: arg$=GetRawCommandLine()
Replies: 3
Views: 1382

Re: arg$=GetRawCommandLine()

Thanks, I was thinking that may be the case.

NathanH
by NathanH
Sun Aug 24, 2025 1:49 am
Forum: Wishlist
Topic: arg$=GetRawCommandLine()
Replies: 3
Views: 1382

arg$=GetRawCommandLine()

I've been sitting on this for a few years now. Is it possible to get the command line as a string with no parsing/help from Hollywood/C/DOS/whatever? GetRawArguments() reads the greater-than sign as redirection rather than passing it as an argument. I need to capture and process everything myself in...