LiveCode Forums.

Hi Phil, Thanks for your reply. I must say I am new to databases but I bought a program called SQLITE EXPERT which I used to build the query, the script of which I sent. This did work in the SQLITE EXPERT software in that using ... AND PROJECTS.NAME = 'LINCOLN' extracted all the projects for LINCOLN...

Have created 2 databases, PROJECTS and DOORS. My d/base runs correctly in sqlite. I have tried to execute the following button script in Revolution: select * from projects, doors where projects.projectID = doors.projectID and projects.name = 'a non literal' which will be input on a card This will no...

When the Query Builder is launched it has several fields to be completed to make a connection but I am unsure as to what goes where. Could you provide a short guide to enable me to connect to a Valentina database I have created called Projects. If I choose SQLITE from the dropdown TYPE list then cli...

Is it possible to transfer the various scripts, buttons etc that run the sqlite example across to a new stack. This example seems to contain all the database scripts and buttons that I need. If I can get the stuff into my own stack I can then modify to suit my requirements. Will save me a lot of typ...

I can find various commands/functions for creating tables in a database but can anyone give me the basic code to create a sql database named surveyor with 4 tables called doors, windows, height, width.

Any help would be appreciated.

Michael

Klaus wrote:Hi Michael,

simply provide the NUMBER or NAME of the card you want to navigate to:
...
go cd 3
...
or
...
go cd "my third card"
...

You can also
...
go first cd
..
or
...
go last cd
...

Best from germany

Klaus

Thanks for your help Klaus. Problem solved. Michael

I ma setting up a project which uses 6 cards. I want to be able to navigate to any card from any other card rather than moving from one card to another sequentially. What script should I use in my buttons ???