TheunisP
Posts: 342
|
Posted: 05/12/2008, 1:33 PM |
|
Hi all, I need to put a custom expression into the order by column/expression e.g. CONVERT(DATETIME,SUBSTRING(strTMSFolderEventDate,1,10),103)
but vqb keeps on deciding that the expression is actually multiple paramaters so it breaks it up at each , and makes it into 5/6 parameters - any ideas?
|
|
|
Chris__T
Posts: 339
|
Posted: 05/12/2008, 1:50 PM |
|
single quotes?
|
|
|
TheunisP
Posts: 342
|
Posted: 05/12/2008, 1:56 PM |
|
sorry Chris - I;m bit slow this late at night - single quotes?
|
|
|
Chris__T
Posts: 339
|
Posted: 05/12/2008, 2:22 PM |
|
'CONVERT(DATETIME............,103)'
|
|
|
TheunisP
Posts: 342
|
Posted: 05/12/2008, 3:09 PM |
|
nope still breaks it up and the order doesn't get used at all - mmmm... this got me I mean it must be possible to have custom order in VQB the heading clearly states column or expression
|
|
|
wkempees
|
Posted: 05/13/2008, 4:06 AM |
|
Indeed VQB keeps seaparatin it on the comma's.
I would report this to support, seems like a oversight.
Meanwhile, an option is to change your VQB from TABLE to SQL and add the
ORDER BY manually.
second alternative is to set the order by in the events
Walter
"TheunisP" <TheunisP@forum.codecharge> schreef in bericht
news:64828c0301b898@news.codecharge.com...
> nope still breaks it up and the order doesn't get used at all - mmmm...
> this got
> me I mean it must be possible to have custom order in VQB the heading
> clearly
> states column or expression
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|