You are viewing limited content. For full access, please sign in.

Question

Question

The SQL column type is not supported in LFQL.

Laserfiche
Updated November 5, 2015
asked on February 24, 2014

What column types are supported in LFQL?

 

A dynamic lookup from a view worked fine in Laserfiche 9.0.2 but gives the following error in 9.1.1.

9422: The SQL column type is not supported in LFQL.

 

The column types are uniqueidentifier, varchar and nvarchar. Changed the varchar to nvarchar but still getting the same error.

 

Any ideas on this?

 

 

0 0

Answer

APPROVED ANSWER
replied on February 24, 2014 • Show version history

In past versions of Laserfiche (i.e. 9.0.2) the uniqueidentifier column would just get ignored, but still allow you to configure dynamic fields using the other columns in the table. In 9.1.1 now, the column seems to be triggering an error instead. A bug has been filed for this issue. The workaround is to recreate the view but exclude the uniqueidentifier column or cast it as an nvarchar.

0 0

Replies

replied on February 5, 2015

This bug remains right?

 

Beacuse i got the same issue with 9.2.

0 0
replied on February 5, 2015

Correct. Please continue to workaround the issue by excluding the uniqueidentifier column.

0 0
replied on February 5, 2015

But this is not a view, its a table.

So i need to create a view just avoid this issue?

 

0 0
replied on February 5, 2015

The original question was posted almost a year ago. So, still no fix for this bug???

0 0
replied on November 4, 2015

I've just ran into this issue using 9.2.1.635.

 

Will this be fixed in LF10?! laughwink

 

Cheers!

0 0
replied on November 4, 2015

It is fixed in LF10. Columns defined as uniqueidentifier will appear as nvarchar columns to LF10 without any additional work.

1 0
replied on November 5, 2015

Sweet! yes

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...