Ask Your Question
1

Getting database functions to work? [closed]

asked 2013-07-19 16:42:01 +0100

Mikko gravatar image

updated 2013-10-11 21:18:24 +0100

manj_k gravatar image

Sorry for a beginner question, but I've tried everything I can think of already. I'm doing a large database of over 900 entries/rows, and a list which puts them in numeric order from smallest to biggest, and thus I use function as a parameter. I checked your example and advices from help pages regarding DGET(Database; DatabaseField; SearchCriteria) and tried several approaches. Maybe it was a ghost bug because I had done already worked the table, but it should had gone away if that was the case because I tried all the approaches. Tried putting everything on the same line, tried using both functions and numeric values as search criterias, tried using both brackets '' and """" for the column tag, put the database and searchcriteria on different and same columns. Changing brackets gave me #VALUE! error instead of 504.

Do only numeric values work in DGET(Database; DatabaseField; SearchCriteria) , or can I use functions as SearchCriteria? Also, if I understood right, DatabaseField is the syntax which determines the kind of result (column) shown in the cell. Also, should Database always be positioned above SearchCriteria in the table?

I think you should put that to your help page with highlighted font if it accepts certain functions with only very restricted formalities, because knowing that would save a lot of time and experimenting from users like myself who are not familiar with programming and why programs are built the way they are.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-04 02:32:48.917944

1 Answer

Sort by » oldest newest most voted
0

answered 2013-07-20 01:00:20 +0100

m.a.riosv gravatar image

updated 2013-07-20 01:00:50 +0100

Hi Mikko. sometimes is no easy understand how the functions works, and many times the issue is with a mistake that one can not see and any other see right.

Find attached a file with a couple of samples with DGET().

DGET_Sample.ods

Depending on what you are looking for. you can use other functions that do not need put data in external ranges in the restricted way that database functions do it, and easy to use.

edit flag offensive delete link more

Question Tools

2 followers

Stats

Asked: 2013-07-19 16:42:01 +0100

Seen: 820 times

Last updated: Jul 20 '13