Search found 175 matches
Re: SQLite
No problems. I do a lot of work with SQLite but nothing so complex or large that would require multiple indexes to speed up search functions. Instead, I found that a bit of effort on good validation in the input form is a better solution and you can give you users a better constructed error message ...
Re: SQLite
Hi - I'd try creating the name field as an additional index. You can read about it here on the SQLite site . As a side note, you can create tables by storing the creation script as a file, reading it in and executing it as a SQL command. This is an example that I've used to create a 'Category' table...
- Saturday 13th April 2024 10:19pm
- Forum: General
- Topic: Suggestions for checking that all array values are unique
- Replies: 7
- Views: 3078
Re: Suggestions for checking that all array values are unique
Replied to an earlier version of the code Doh.
- Wednesday 10th April 2024 10:57pm
- Forum: General
- Topic: Suggestions for checking that all array values are unique
- Replies: 7
- Views: 3078
Re: Suggestions for checking that all array values are unique
If you want the check to fail on the first detection of a duplicate, it may be better to do the check with a loop/repeat rather than a For/next so that it drops as soon as it fails rather than running through the entire array.
It may shave off some more time in the process.
It may shave off some more time in the process.
- Friday 1st December 2023 10:19pm
- Forum: Project showcase
- Topic: Eight-Queen Puzzle Simulator on GAMBAS
- Replies: 1
- Views: 6084
Re: Eight-Queen Puzzle Simulator on GAMBAS
For others (like me) who have never heard of the eight queen puzzle, here is a Wikipedia Link: Eight Queen Puzzle
- Friday 3rd November 2023 2:16am
- Forum: General
- Topic: find a control
- Replies: 11
- Views: 12063
Re: find a control
Here is a recursive routine to 'reset' a form - normally some sort of maintenance form to add/modify records. It is called after the record is updated, resetting the input fields so new data can be entered. Aspects of the code may be useful if you want to do more than a simple search. It is designed...
- Monday 30th October 2023 9:49pm
- Forum: General
- Topic: Advise for a standalone database
- Replies: 4
- Views: 10448
Re: Advise for a standalone database
Hi Andy. I use SQLite extensively for any project that needs data storage/retrieval. Unless your data set has millions of records, then it should be more than sufficient for the task. How are your SQL skills and do you have a rough design for your database structure? Regardless of size and the under...
- Monday 23rd October 2023 12:33am
- Forum: General
- Topic: Music component - Editor Vs Compiled program.
- Replies: 3
- Views: 5598
Re: Music component - Editor Vs Compiled program.
Thanks for checking. I created a new project, copied in your code with a valid mp3 file and it has the same result - no sound. I checked the status of Music.Playing and it returns true, so this suggests that the component is not in an error state. I created an executable and the music played as expe...
- Sunday 22nd October 2023 1:43am
- Forum: General
- Topic: Music component - Editor Vs Compiled program.
- Replies: 3
- Views: 5598
Music component - Editor Vs Compiled program.
I have a strange issue. I have a number of programs that use the gb.sdl2.audio - Music component. If I use it to play any applicable media in the Editor (on Run application) there is no error and the file does not play. If I compile to executable and then run that, every works as expected. I've trie...
- Tuesday 17th October 2023 12:25am
- Forum: General
- Topic: Post a screenshot
- Replies: 18
- Views: 20702
Re: Post a screenshot
Parallaxis - Javigg's Fist Author [ Ian Rendell ]_001.png I'm in the process of developing a tool to write a novel. It has some basic document analysis such as checking for 'poor use' words, word frequency and use of cliche phrases. You can create story detailed characters with a reference image as...