Bug 90337 - Access2Base simple dlookup fails with SQL error 1510
Summary: Access2Base simple dlookup fails with SQL error 1510
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Extensions (show other bugs)
Version:
(earliest affected)
4.4.1.2 release
Hardware: Other macOS (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-03-30 06:22 UTC by jay Arr
Modified: 2015-03-30 12:10 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description jay Arr 2015-03-30 06:22:54 UTC 
OSX=Yosemite

with table definition for usedType as

usedTypeID integer 
usedTypeName text

and with first record as

1  anything

using

sub STARTUP
dim svalue as string

svalue=dlookup("[usedTypeName]","[usedType]","[usedTypeID]=1")
end sub

gives

Error #1510 (DFunction execution failed, SQL=SELECT TOP 1 "usedTypeName" AS "TEMP48341" FROM "usedType" WHERE "usedTypeID"=1) occurred in DLookup

correct sql should be

SELECT usedTypename FROM usedType WHERE usedTypeID=1
Comment 1 jay Arr 2015-03-30 09:25:59 UTC 
Apologies FALSE ALARM - this is NOT a BUG

my mis spelling
of my table name as

usedType

when it was UsedType in my code

caused the 'error'

I'd wrongly assumed that arguments to the function were case Insensitive
Comment 2 steve 2015-03-30 12:10:56 UTC 
This is not fixed but an invalid bug.