Problem with SQL syntaxes

[kltan]

Hi,

Anyone can help me with this?

I am attempting to add a SQL expression field. This is the background info of my databases and tables. I am using a ORACLE 7.3.4 server.

Under Current Connections in DataExplorer, the tree is as follows,
Current Connections
|
->Moon
|
->Star.1
->Star.2
-> and so on

I typed the following SQL syntax,
SELECT Star."1" FROM "Moon".Star

It dont seem to work, what should be the correct syntax if I want to do a SQL expression based on Star.1?

Thanks,

Jimmy

 

[marckssg]

If you are using a SQL Expression field you will not be able to use any SQL Statements (SELECT, FROM, WHERE) in this field.

The SQL Expression field is only meant to use specific SQL Functions on a field and to have this function be performed on the server.

Cheers

Marc