Simple search function

[Former Member]

Hello everyone,

i'm trying to add a little text in my search function field.

my search sql command is:

SELECT $[OJDT.Ref2]

(the forum read it for some reason as an adress.. there is just [ ] outside of the OJDT.Ref2)

and when i'm doing it like this:

SELECT $[OJDT.Ref2] + 'text'

i get an error about the command line.

does anyone has an idea how can i do it?

Thanks&Regard

Moise

Edited by: moshababo on May 7, 2009 8:39 AM

[former_member204969 · Accepted solution]

1. If you want to see the code properly in your message, you should use the < .> icon (Click the display the text as code) at the top of the window.

2. The code Select

$[OJDT.Ref2]+'text'

should work if you use it as an FS inside a journal entry. (This reference is valid only inside an active journal entry transaction.)

[Former Member]

Thank you very much