You are not logged in.

spysonic

Trainee

  • "spysonic" is male
  • "spysonic" started this thread

Posts: 88

Date of registration: Jul 11th 2014

About me: A beginner programmer.

Location: ...Jabaco Academy

Occupation: i have some but still not enough...

Hobbies: Jabaco

  • Send private message

1

Wednesday, July 16th 2014, 8:53am

BASIC JABACO - DATABASE workarrounds

Hello everyone,

Id like to ask for help in getting familiar with Jabaco in terms of Database manipulation or some basic database work-around.

I wanted to create a simple login in Jabaco.
1. Textbox for username
2. Passwordfield for password
3. command button for enter

Expected Result:
1. after pressing "enter button", Id want it to search on the database for an entry matching whatever entry I have in the Textbox AND password field and display a msgbox if it exist or not in the database.

I dont know how to do it with Jabaco. Any help would be deeply appreciated!.
spysonic has attached the following image:
  • login.jpg
.
.
Spare me, im new to Programming

This post has been edited 1 times, last edit by "spysonic" (Jul 16th 2014, 9:15am)


spysonic

Trainee

  • "spysonic" is male
  • "spysonic" started this thread

Posts: 88

Date of registration: Jul 11th 2014

About me: A beginner programmer.

Location: ...Jabaco Academy

Occupation: i have some but still not enough...

Hobbies: Jabaco

  • Send private message

2

Wednesday, July 16th 2014, 9:00am

Iv seen this post by dani Vorstellung Desi / Bauteildatenbank / das Jabaco-Projekt


but I cant understand the language :( but i know it would've been a great help for me.
.
.
Spare me, im new to Programming

Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

  • Send private message

3

Wednesday, July 16th 2014, 11:02pm

Hey there,

search the forum for 'database':

http://www.jabaco.org/board/905-database…e.html#post3663

Download the sample code, have a look at Private Sub grdMain_init()

Everything that's German is only the tablenames and fields!!


Dani

spysonic

Trainee

  • "spysonic" is male
  • "spysonic" started this thread

Posts: 88

Date of registration: Jul 11th 2014

About me: A beginner programmer.

Location: ...Jabaco Academy

Occupation: i have some but still not enough...

Hobbies: Jabaco

  • Send private message

4

Thursday, July 17th 2014, 3:36am

Thanks Dani.. and sorry i wasnt able to check it the last time i saw the other post because all your conversation there were german and Im not yet familiar with the langauge. but thank you so much for this great help :).
.
.
Spare me, im new to Programming

spysonic

Trainee

  • "spysonic" is male
  • "spysonic" started this thread

Posts: 88

Date of registration: Jul 11th 2014

About me: A beginner programmer.

Location: ...Jabaco Academy

Occupation: i have some but still not enough...

Hobbies: Jabaco

  • Send private message

5

Thursday, July 24th 2014, 8:22am

Hello again,

im new in programming so please spare my coding abilities in my example...
i have a problem with JBGRID when it comes to the click event...

i wanted to display the current data of the jbgrid by simply clicking on the data of database being displayed on the jbgrid. the problem occurs on the middle to last part of the jbgrid where it doesnt recognize a click.

Source code

1
Public Sub JBGrid_user_Click()   txtuserid.Text = JBGrid_user.TextMatrix(JBGrid_user.Row ,0)   txtusername.Text = JBGrid_user.TextMatrix(JBGrid_user.Row ,1)   txtpassword.Text = JBGrid_user.TextMatrix(JBGrid_user.Row ,2)   txtlevel.Clear    txtlevel.AddItem (JBGrid_user.TextMatrix(JBGrid_user.Row ,3))         MsgBox JBGrid_user.TextMatrix(JBGrid_user.Row ,0)End Sub


i tried uploading my proj but it wont allow me since it has 200kb size the allowable attachment is 160kb only
TIA
.
.
Spare me, im new to Programming

spysonic

Trainee

  • "spysonic" is male
  • "spysonic" started this thread

Posts: 88

Date of registration: Jul 11th 2014

About me: A beginner programmer.

Location: ...Jabaco Academy

Occupation: i have some but still not enough...

Hobbies: Jabaco

  • Send private message

6

Thursday, July 24th 2014, 8:23am

sorry i dont know how to display code in a comment ?( :(
.
.
Spare me, im new to Programming

spysonic

Trainee

  • "spysonic" is male
  • "spysonic" started this thread

Posts: 88

Date of registration: Jul 11th 2014

About me: A beginner programmer.

Location: ...Jabaco Academy

Occupation: i have some but still not enough...

Hobbies: Jabaco

  • Send private message

7

Thursday, July 24th 2014, 8:23am

Public Sub JBGrid_user_Click()
txtuserid.Text = JBGrid_user.TextMatrix(JBGrid_user.Row ,0)
txtusername.Text = JBGrid_user.TextMatrix(JBGrid_user.Row ,1)
txtpassword.Text = JBGrid_user.TextMatrix(JBGrid_user.Row ,2)
txtlevel.Clear
txtlevel.AddItem (JBGrid_user.TextMatrix(JBGrid_user.Row ,3))

MsgBox JBGrid_user.TextMatrix(JBGrid_user.Row ,0)
End Sub
.
.
Spare me, im new to Programming

spysonic

Trainee

  • "spysonic" is male
  • "spysonic" started this thread

Posts: 88

Date of registration: Jul 11th 2014

About me: A beginner programmer.

Location: ...Jabaco Academy

Occupation: i have some but still not enough...

Hobbies: Jabaco

  • Send private message

8

Thursday, July 24th 2014, 9:45am

here... i deleted some of the files...

admin
username: x1
password: x2

user
z1
z2

please observe the JBGRID in creating a new user...
when having at least 10 records you cant click on the frid to display the record on the text fields anymore.
spysonic has attached the following file:
  • SQLite sample.zip (63.51 kB - 200 times downloaded - latest: Jun 1st 2021, 12:19pm)
.
.
Spare me, im new to Programming

This post has been edited 1 times, last edit by "spysonic" (Jul 25th 2014, 2:39am)


Dani

Intermediate

Posts: 325

Date of registration: Nov 19th 2009

Location: GERMANY

  • Send private message

9

Thursday, July 24th 2014, 9:48am

Hey there,

the problem occurs on the middle to last part of the jbgrid where it doesnt recognize a click.


Are you using the latest framework, Jabaco.jar?

See the link at the bottom of this post. Download the .zip file and extract to your Jabaco installation folder.


Dani

spysonic

Trainee

  • "spysonic" is male
  • "spysonic" started this thread

Posts: 88

Date of registration: Jul 11th 2014

About me: A beginner programmer.

Location: ...Jabaco Academy

Occupation: i have some but still not enough...

Hobbies: Jabaco

  • Send private message

10

Thursday, July 24th 2014, 10:59am

oh no!. dont know what happened but after using the latest framework my project gives me this "java.sql.SQLException: SQLite.Exception: no such table: system_user" its working on the previous framework though..

i'll investigate....
.
.
Spare me, im new to Programming

spysonic

Trainee

  • "spysonic" is male
  • "spysonic" started this thread

Posts: 88

Date of registration: Jul 11th 2014

About me: A beginner programmer.

Location: ...Jabaco Academy

Occupation: i have some but still not enough...

Hobbies: Jabaco

  • Send private message

11

Friday, July 25th 2014, 2:39am

got it now..

i just replace the "App.path" to "CurDir" and its working again. ^^

thanks Dani
.
.
Spare me, im new to Programming

Rate this thread
WoltLab Burning Board