Improve database functions to make them similar to VB. EOF, BOF, Move.Last, next, first etc. Text file databases should also be handled using similar commands. For example we can store database passwords in files on server such as in CGI-BIN directory and call it from app. Or whatever way you think is most secure. Better database handling would make it very nice as most apps require databases of some sort. Games and serious apps use text files or SQL databases nowdays.

I agreed with several things in first post: Jabaco 1.4.2 always opens up the samples folder when you click open,save,new commands..... I think it would be better to give us an options dialog box. Items on the Options Dialog Box could include: 1. Language Selection 2. Default Project Folder (as already stated before) 3. Auto Remove Unused Dependancies/References 4. Editor Options Font Size atleast. Another feature that could be added is that when you go to references and click on the Directory it...

Ok im trying the non ODBC example but I updated the references and it seems to work now. The only problem I am having now is assigning values from the ResultSet into text boxes. I don't want the JGrid object because I want to build a GUI and prefer to have Text Boxes or Labels display the results. Text1.Text = res.getString("id") or text1.Text = CSTR(res.getString("id")) doesnt work.

I seem to be getting errors all the time: From what I gather the getString function always fails me. Also for some reason it will not allow me to use the line "Dim res as ResultSet". Source code 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Exception in thread "AWT-EventQueue-1" java.lang.Exception: CallByName 'getString' failed! at VBA.Interaction.CallByName(Interaction.java:182) at VBA.Interaction.CallByName(Interaction.java:180) at VBA.Interactio...

Source code 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Public Sub cmdButton_Click() 'On Error Resume Next Dim strSQL As String Dim rSet As ResultSet strSQL ="SELECT * FROM Test" If Database1.ConnectMDB("C:\myMDB.mdb") Then rSet = Database1.ExecuteStatement(strSQL) rSet.getRow() rSet.moveToCurrentRow rSet.findColumn("Test1") text1.Text = rSet.getString(1)'?????????????? End If rset.close End Sub My fields are ID, Test1, Test2 in the table Test in the database myMDB.mdb. All i want to know is how do ...