Run Time Access |
RTA comes with a table editor which lets you view and edit any of the tables in your RTA program. The table editor is composed of four short PHP programs which use the information in the two system tables to figure out how to display and edit the other tables in the program.
Click on the link below to give it a try.
You might want to try changing one of the "notes" fields in
mytable. Be sure to hit 'reload' to see the effect of
your changes.
RTA provides a /proc-like access to your program's tables as well as PostgreSQL-like access. In our demo application we have mounted the RTA virtual file system under the root of Apache. This lets you browse the application's tables as directories and files visible with your web browser. Click on the link below to give it a try.
If you have the 7.2 or 7.3 PostgreSQL command line tool psql on your system you can access our demo application directly with
psql -h www.runtimeaccess.com -p 8888
Once connected, try a few of the following simple SQL commands.
SELECT * FROM mytable;
UPDATE mytable SET myint=4 LIMIT 5 OFFSET 10;
SELECT * FROM mytable;
UPDATE mytable SET notes="Hi Mom!" LIMIT 1 OFFSET 0;
SELECT name FROM rta_tables;
\q