Hi Chris/Oleg, I have the following questions for JDB: 1. Would it be possible to use JDB without creating the physical file structure? I.e. Folders and files. 2. How do I find out the existing tables in a database without reading the "dir" file? 3. Isn't it logical to get a "Read" verb at the table level? To explain further, consider the following example: NB. test table definition testfields=: 0 : 0 field1 int field2 varchar field3 char field4 boolean )
NB. Load the library and open may data directory load 'data/jdb' hf=: Open_jdb_ '/home/arufon/Temp/data' NB. Create a new database named test hd=: Create__hf 'test' NB. Create a new table named test ht=: Create__hd 'test';testfields NB. Insert a sample data Insert__ht 1;'first row';'a';0 NB. Retrieve the data from the table Reads__hd 'from test' +------+---------+------+------+ |field1|field2 |field3|field4| +------+---------+------+------+ |1 |first row|a |0 | +------+---------+------+------+ What I am saying is that to read the data from the table, I need to access the database locale 'hd' while I already have a reference for the actual table locale in 'ht'. I can already do Insert on the table level as show in this code: NB. Insert a sample data Insert__ht 1;'first row';'a';0 I would be logical to be able to do the other DML commands on both the table and database level right? Let me know what you think. :) r/alex -- "The right questions are more important than the right answers to the wrong questions." -Dr. John Romagna ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
