Does CLNG work in Sql Compact?

Hi,

When I execute following query against to SqlCE 3.0.53, I am getting an error, could someone guide where it is wrong.

SELECT SLCTD_MENUENTRYID FROM GEN_ENTRY WHERE EXAMID = 'EFBC0657145840CF88184BDCE71430EE'

AND TYPEVALUE IN ('SURG_PROC', 'CV_PROC') AND CLNG(SLCTD_MENUENTRYID) < 0

Error:

Major Error 0x80040E14, Minor Error 25921

> SELECT SLCTD_MENUENTRYID FROM GEN_ENTRY WHERE EXAMID = 'EFBC0657145840CF88184BDCE71430EE'

AND TYPEVALUE IN ('SURG_PROC', 'CV_PROC') AND CLNG(SLCTD_MENUENTRYID) < 0

The function is not recognized by SQL Server Compact Edition. [ Name of function = CLNG,Data type (if known) = ]

CLNG is not availabel in SQL CE. For documention on the SQL CE SQL syntax, see http://msdn2.microsoft.com/en-us/library/ms173372.aspx. You could use CONVERT(int, SLCTD_MENUENTRYID) instead.

|||I feel the above CONVERT function always returns non fractional value.

For ex:
select CONVERT(int, 4.7)= 4
select CONVERT(int, 4.4)=4
select CONVERT(int, -4.7) =-4
select CONVERT(int, -4.4) =-4

But where as CLNG function does the following:
select CLNG(4.7)=5
select CLNG(4.4)=4
select CLNG(-4.7)=-5
select CLNG(-4.4)=-4

I feel the following line will work for us:

select CONVERT(int, round(4.7,0)) =5
select CONVERT(int, round(4.4,0)) =4
select CONVERT(int, round(-4.7,0)) =-5
select CONVERT(int, round(-4.4,0)) =-4

Please let me know if I am wrong.

Thanks|||If that works for you, you are of course right. CLNG is not available in SQL CE, but other conversion functions are.

Does CLNG work in Sql Compact?

Hi,

When I execute following query against to SqlCE 3.0.53, I am getting an error, could someone guide where it is wrong.

SELECT SLCTD_MENUENTRYID FROM GEN_ENTRY WHERE EXAMID = 'EFBC0657145840CF88184BDCE71430EE'

AND TYPEVALUE IN ('SURG_PROC', 'CV_PROC') AND CLNG(SLCTD_MENUENTRYID) < 0

Error:

Major Error 0x80040E14, Minor Error 25921

> SELECT SLCTD_MENUENTRYID FROM GEN_ENTRY WHERE EXAMID = 'EFBC0657145840CF88184BDCE71430EE'

AND TYPEVALUE IN ('SURG_PROC', 'CV_PROC') AND CLNG(SLCTD_MENUENTRYID) < 0

The function is not recognized by SQL Server Compact Edition. [ Name of function = CLNG,Data type (if known) = ]

CLNG is not availabel in SQL CE. For documention on the SQL CE SQL syntax, see http://msdn2.microsoft.com/en-us/library/ms173372.aspx. You could use CONVERT(int, SLCTD_MENUENTRYID) instead.

|||I feel the above CONVERT function always returns non fractional value.

For ex:
select CONVERT(int, 4.7)= 4
select CONVERT(int, 4.4)=4
select CONVERT(int, -4.7) =-4
select CONVERT(int, -4.4) =-4

But where as CLNG function does the following:
select CLNG(4.7)=5
select CLNG(4.4)=4
select CLNG(-4.7)=-5
select CLNG(-4.4)=-4

I feel the following line will work for us:

select CONVERT(int, round(4.7,0)) =5
select CONVERT(int, round(4.4,0)) =4
select CONVERT(int, round(-4.7,0)) =-5
select CONVERT(int, round(-4.4,0)) =-4

Please let me know if I am wrong.

Thanks|||If that works for you, you are of course right. CLNG is not available in SQL CE, but other conversion functions are.

document map

hi all -
i am trying to make a document map for my report. now correct me if i'm
wrong, but when i click on a link in the document map, the my
drill-down menus in my table should 'automatically' expand as needed.
well i can't get it to work. i have a bookmark ID set for the drilldown
parents in my table, and document map set on the grouping properties of
the table and and can navigate the document map just fine, but it
doesn't do anything with the table (like pull up relevant information).
any ideas on how to fix this?
thanks so much in advance and let me know if i totally confused you! i
can re-explain.I am having the exact same issue. Have you managed to find a solution?
"roadie.girl@.gmail.com" wrote:
> hi all -
> i am trying to make a document map for my report. now correct me if i'm
> wrong, but when i click on a link in the document map, the my
> drill-down menus in my table should 'automatically' expand as needed.
> well i can't get it to work. i have a bookmark ID set for the drilldown
> parents in my table, and document map set on the grouping properties of
> the table and and can navigate the document map just fine, but it
> doesn't do anything with the table (like pull up relevant information).
> any ideas on how to fix this?
> thanks so much in advance and let me know if i totally confused you! i
> can re-explain.
>