Question

Offline Forms - DB Lookups

Forms

Updated March 28, 2017

asked on February 28, 2017 • Show version history

Hi All,

Has anyone managed to get the offline DB lookups working in offline forms? No matter what settings I try I cannot get a drop down to display anything other than [Loading List Items...] which stays like that forever (this is a static placeholder item which is overwritten in the live form with the DB List). I've also tried removing this just in case this is messing with the lookup but it's then just blank.

I've tried adding the table I need to the 'Local Lookup Tables' in data sources, but still no joy.

Is there something I am missing?

Cheers!

0 0

Answer

APPROVED ANSWER SELECTED ANSWER

replied on March 27, 2017 • Show version history

Thank you for opening a support case - to also update this thread the problem was caused by double quote characters in db column values not being properly escaped resulting in syntactically incorrect sqlite queries. This has been fixed in the apps and will be in the next release. As a workaround removing these (usually superfluous) double quotes from you db values will fix it as well.

2 0

Replies

replied on March 28, 2017

Hi All,

My resolution was a little different, My fault finding found the following:

Examples:

The character - is ascii code 45 where as the character – is 8211

The character ' is ascii code 39 where as the character ’ is 8217

Both look similar and would assume they work, but if the latter is in the SQL table, it will not work in offline mode. When using Browser or Forms online, the process works fine.

So having the name Peter O’Conner in the name field breaks the offline forms, where as Peter O'Conner works perfectly. Same goes for the dash in other fields like part number and description. (Wasn't that fun to find)

I have a feeling that the first 127 dec characters of the ASCII table are supported (maybe more) and some special characters are not supported? Is there is an unknown amount of characters that fall out of that scope?

1 0

replied on February 28, 2017

Do you know the number of rows on the DB as I recall something about a limit on this at Empower?

0 0

replied on February 28, 2017

Hi Ferg,

The DB only has 2k rows, if it can't handle that its not much use!

0 0

replied on March 19, 2017

Hi Chris,

As a Laserfiche Ninja, did you ever get this worked out? :-)

I am trying to do similar but my drop down won't populate at all. Mine has a lot less than 2k rows.

Regards Gary

0 0

replied on March 20, 2017

Ha ha, Ninja

Erm, no.......

0 0

replied on March 20, 2017

Hello Chris,

Would you be able to open a support ticket, so we can look more into this issue in detail? we apologize for the trouble/inconvenience.

Regards,

0 0

replied on March 21, 2017

Sure thing, will do.

0 0

You are not allowed to follow up in this post.

Question

Question

Offline Forms - DB Lookups

Answer

Replies

Sign in to reply to this post.