Simple DAP Syntax Question

Capilano

Registered User.
Local time
Today, 21:29
Joined
Feb 19, 2001
Messages
63
Hi... I am trying to design my first Data Access Page and I have a really simple syntax question. I need to know the proper syntax for Microsoft Script for the following:

Ser = chr(34) & "LogicalCubeName=" & LogicalCubeName.value & chr(34)

This script works perfectly well if LogicalCubeName is a Numeric Data Type. What, however, is the proper syntax if LogicalCubeName is a String? In VBA it would be very simple, add the additional 1/2 quote marks:

Ser = chr(34) & '"LogicalCubeName="' & LogicalCubeName.value & chr(34)

but when I try this syntax, LogicalCubeName becomes Green similar to if I am trying to 'nest' comments in VB.

Can someone assist me with this real simple question?

Thanks

Pat
 

Users who are viewing this thread

Back
Top Bottom