Thank you! That was it. I've been pulling my hair out over this all day.
I should have seen it. I've never used STRING in my own tables and I
inherited this from someone else and didn't even think twice that the type
difference would be the issue.
Thanks you again.
sorka wrote:
>
> This is
Igor Tandetnik wrote:
> sorka wrote:
>> This is driving me nuts. I have two tables I'm trying to join
>> together on two text fields.
>>
>> CREATE TABLE tmp_role ( programId INTEGER,
>> roleNameINTEGER,
>> positionINTEGER,
>> isNew BOOL,
>> personIdINTEGER,
>> name
sorka wrote:
> This is driving me nuts. I have two tables I'm trying to join
> together on two text fields.
>
> CREATE TABLE tmp_role ( programId INTEGER,
> roleNameINTEGER,
> positionINTEGER,
> isNew BOOL,
> personIdINTEGER,
> nameSTRING);
>
> This table has up
This is driving me nuts. I have two tables I'm trying to join together on two
text fields.
CREATE TABLE tmp_role ( programId INTEGER,
roleNameINTEGER,
positionINTEGER,
isNew BOOL,
personIdINTEGER,
nameSTRING);
This table has up to a few dozen records at any
4 matches
Mail list logo