Beginners - Example Database - Base Tutorial

Verystumbed · General User Joined: 31 Dec 2005 Posts: 11

Thanks Drew, I figured out my problem!!!

cityguy · Newbie Joined: 03 Feb 2006 Posts: 3

Hi, I m new into database. I was trying out the great tutorial can got into a problem.
I was changing the SQL statment SELECT "LastName", "FirstName", "MiddleName", "EmployeeID" FROM "Employees" "Employees" to SELECT "LastName" || ', ' || "FirstName" || ' ' || "MiddleName" AS "Name", "EmployeeID" FROM "Employees" "Employees"
and BASE just keep poping Syntax error in SQL expression parse error, expecting 'BETWEEN' or 'IN' or 'SQL_TOKEN_LIKE'. Can anyone help.[/img]

DrewJensen · Posted: Fri Feb 03, 2006 10:34 pm Post subject:

To use that query you must select 'Run SQL Direct'. To do this you select the toolbar button that has a green check mark over the letters SQL.

Drew
_________________
Blog - http://baseanswers.spaces.live.com/

cityguy · Newbie Joined: 03 Feb 2006 Posts: 3

Thanks a lot. Now I can continue with the tutorial Very Happy

brian4m · Posted: Mon Feb 13, 2006 1:40 pm Post subject:

I have enjoyed working my way through the tutorial.
My problem is with the form. I can set it up correctly and can input data to it. The data appears in the relevant table so the form is working. When I try to return to the form, to make corrections, I cannot toggle the Design Mode On/Off button and, on the top line, there is Employees (read-only) OpenOffice.org Writer. I have deleted the form, re-created it with the same result.
I am using Version 2.0.0.
Any ideas of things to try please.

Brian

duanecu · Posted: Thu Mar 02, 2006 5:44 am Post subject: Could this be wiki'ed?

Is it possible to make this begining tutorial into a wiki somewhere? I found it very helpful, but I still don't understand a few of the finer points. It would be nice if we could all improve on this, and correct the grammer or factual errors, and also improve on the more illusive portions.

ynui_nz · Posted: Sun Mar 05, 2006 3:20 am Post subject:

Excellent tutorial great insight. gives me strong confidences that openoffice will meet my needs. Smile

brian4m · Posted: Sun Mar 05, 2006 12:37 pm Post subject:

From another tutorial I got the answer to my problem - see 13 February 2006.

In the main database screen I highlighted the form, right clicked which opened a small window one of whose items was Edit. I clicked Edit and was able to edit the form. The nice thing was I was able to toggle the Design Mode Off/On button and trial the changes. I am now back on track to continue the tutorial.

Brian

orvilat · Newbie Joined: 08 Mar 2006 Posts: 1

Hi there,

found a solution for the problem posted in this tutorial see Thu Oct 13, 2005 12:36 pm

JHalcrow · General User Joined: 15 May 2006 Posts: 22

I am having a lot of difficulty creating a list box

Mentioned in the tutorial it said "So, the easy way is just always add a list box to a form, not change a control to a list box. OK then let's do it, add a list box control to the form. The List Box wizard opens"

I can't seem to find where you just add a list box???

Please Help

Jen

r4zoli · Posted: Wed May 17, 2006 1:55 am Post subject:

You activate View>toolbox>Form Control and on it click on listbox, and draw rectangle into form. You get a starting wizzard. If wizard not starting you must activate the most right side icon of Form control toolbox (new control wizard?- I'not sure in my translation from hungarian)
Zoltan

JHalcrow · General User Joined: 15 May 2006 Posts: 22

Thank you that was VERY helpful for an extreme beginner like me!

-Jen

Steve_jo · Newbie Joined: 21 May 2006 Posts: 2

Thanks for the tutorial - followed it for quite a while until the query bit

cut and pasted this in
SELECT CASE WHEN "MiddleName" <> '' THEN "LastName" || ', '|| "FirstName"||' '||SUBSTR( "MiddleName", 1, 1) ELSE "LastName" || ', '|| "FirstName" END AS "Name", "EmployeeID" FROM "Employees" "Employees"

but when I try to save the query i get

parse error, expecting 'BETWEEN' or ' IN' or SQL_TOKEN_Like

Obviously I'm missing something but I can't seem to see what it is.

Please does anyone have any ideas?

Thanks
Steve

Steve_jo · Newbie Joined: 21 May 2006 Posts: 2

OK so I'm an idiot - a line or two later and there is the answer

Sorry for wasting the bandwidth
Steve

midnite_gin · Newbie Joined: 22 May 2006 Posts: 3

Great thread, great tutorial - have really enjoyed working through it as a guide. but I keep running into one problem - the DB I am creating has a massive amount of fields (around 50) and there is no way to really get around it.

Once I create my tables and forms and get everything just the way I want it I save and exit. And when I open it up to start testing it out everything is out of place. Any ideas as to what is causing this and how I can avoid having it happen all together - And please don't say create a smaller form, I really don't have a choice - client's preference.
_________________
With regards,
Midnite_Gin