Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using CR. Is the syntax for a sql expression different in V8 from V10?

Status
Not open for further replies.
AndersonCJA

AndersonCJA

Programmer
Jul 30, 2003
57
US
This command works in V10 and although I can use the sql expression field for other selects in V8, the command below works using V10 but not V8.

The database is Oracle 8i.

(select distinct pack_TAXnbr.func_GETTAXnbr(taxnbr, null, null) from table1 where field = "table2"."field2")


Is there a way it can work using Version 8?
Are there limitations in V8 with using Functions and Stored procedures in the sql expression field?

Thank you,
 
Status
Not open for further replies.

Similar threads

s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
696
hilfy
hilfy
Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
897
Kennymc
Kennymc
dgillz
  • Locked
  • Question
Outlook as a Datasource?
Replies
0
Views
561
dgillz
dgillz
Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
611
dgillz
dgillz
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
586
Ivan Kok
Ivan Kok

Part and Inventory Search

Sponsor

Back
Top