Unknown column in unique constraint: "Double"

48 views
Skip to first unread message

Magicloud Magiclouds

unread,
Dec 25, 2012, 4:40:47 AM12/25/12
to yeso...@googlegroups.com
I am using sqlite backend, with model as following. What should I do?

ProcessPathRullup
    report Text
    lineNumber Int
    lineitemId Text
    lineitemName Text
    mainProcess Text
    coreProcess Text
    unitType Text
    actualVolume Int
    actualHours Double
    actualRate Double
    planProductivity Double
    hoursAtPlanRate Double
    planVarianceHrs Double
    PctToPlan Double
    YoyBaselineVolume Double
    YoyRate Double
    YoyVolDBActualRateHrs Double
    YoyVolDBPyRateHrs Double
    YoyPct Double

--
竹密岂妨流水过
山高哪阻野云飞

And for G+, please use magiclouds#gmail.com.

Michael Snoyman

unread,
Dec 25, 2012, 4:53:36 AM12/25/12
to yeso...@googlegroups.com


On Tue, Dec 25, 2012 at 11:40 AM, Magicloud Magiclouds <magicloud....@gmail.com> wrote:
    PctToPlan Double
    YoyBaselineVolume Double
    YoyRate Double
    YoyVolDBActualRateHrs Double
    YoyVolDBPyRateHrs Double
    YoyPct Double

By using a leading upper case character, you're indicating that you wish to create a uniqueness constraint instead of a field. It then looks for the field "Double" which doesn't exist. if you switch to lower case, it should work.

Michael

Magicloud Magiclouds

unread,
Dec 26, 2012, 4:05:15 AM12/26/12
to yeso...@googlegroups.com
Sorry, must be too sleepy to do this, capitalized all following....
Reply all
Reply to author
Forward
0 new messages