https://bugs.documentfoundation.org/show_bug.cgi?id=90337
Bug ID: 90337
Summary: Access2Base simple dlookup fails with SQL error 1510
Product: LibreOffice
Version: 4.4.1.2 rc
Hardware: Other
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Extensions
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
