I need to add an entry for our invoices... I got the SQL query down pat, but I have no clue how to use it in CR...
The query is the following :
SELECT Response
FROM ispServiceInfoResponse
WHERE (ServiceInfoCode = 'DOMAIN') AND (ServiceKey =
(SELECT ServiceKey FROM ispJournal WHERE JournalKey = tblJournal.JournalKey))
It's a simple query that grabs the domain name associated with a ServiceKey... I put the following code when trying to
create a SQL expression in CR but when testing it, it would complain that there is a syntax error, but that's all the info it
would give me... I am not really into learning the ins and outs of CR, but I need to get this darn thing working so I can work
on bigger and better things
. From my small amount of searching it looks like CR does not even like normal SQL syntax! What
gives?
The query is the following :
SELECT Response
FROM ispServiceInfoResponse
WHERE (ServiceInfoCode = 'DOMAIN') AND (ServiceKey =
(SELECT ServiceKey FROM ispJournal WHERE JournalKey = tblJournal.JournalKey))
It's a simple query that grabs the domain name associated with a ServiceKey... I put the following code when trying to
create a SQL expression in CR but when testing it, it would complain that there is a syntax error, but that's all the info it
would give me... I am not really into learning the ins and outs of CR, but I need to get this darn thing working so I can work
on bigger and better things
. From my small amount of searching it looks like CR does not even like normal SQL syntax! What gives?
Facebook
Twitter