Games List Organizer

[mecivic]

Can someone help how I would do this? Not used AMS for a while so am rusty.

The idea is that I want to catalogue my 1500 games with Publisher, Year and Picture of the game.

This is what I want. There is a list of games.
You select (highlight) a game from the list and it shows the publisher, year and a picture of the game.
But I also want to be able to Input, Rename and Delete new games.

Can anyone help the best way to do this.
Is there any examples what I can work from.

[Thedary]

Hi mecivic, you can store the movie files, urls, pictures in a sqlite database.

The SQLite database acts like as library.

Sorry my poor english.

[mecivic]

I have found some examples on the AMSFile

I will have a play with them
Thank you

[mecivic]

I am familiarising myself with the Agenda SQLite3 I downloaded from AMSFiles.

I have added a list but they are not in alphabetical order. How can I have my list in alphabetical order.

[mecivic]

Hi all
I am struggling with my project.
I have added the apz below.

What I am aiming to do is remove the numbers within the list and I cant get the list to sort A-Z

https://mega.co.nz/#!hg4W1aqA!TgekJvzfl ... IHfeKIqGpM

https://mega.co.nz/#!QtQwSAiB!3lMXAwUNz ... UgnSW0mrII

Can anyone help me please

[Dow Sher]

Hola mecivic!

Perdón por no responder en ingles, esque no se mucho
Bueno respecto a tu problema, has intentado con un order by

SELECT * FROM Ussers ORDER BY RecordID

for row in db:nrows("SELECT * FROM Ussers ORDER BY RecordID") do
	ListBox.AddItem("ListBox1", row.RecordID.."  "..row.Nombre, row.RecordID)
end

ORDER BY es un comando de SQL que (como su nombre lo dice) ordena los datos obtenidos de una columna seleccionada, por defecto los ordena en forma asendente, Si desea ordenar los datos en orden descendente, se debe especificar de forma explí­cita, ejemplo:

SELECT * FROM Ussers ORDER BY RecordID DESC

Más indormacion: SQL ORDER BY

[mecivic]

Thanks for the help but I am confused with it.

[Dow Sher]

http://www.w3schools.com/sql/sql_orderby.asp

Esa página te puede ayudar. Si entiendes como funciona el order by comprenderás que podrías usarlo para lo que necesitas.