StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>For you testing purposes you will want to have Advantage Data Architect, downloadable from the Advantage DevZone. <a href="http://devzone.advantagedatabase.com" rel="nofollow noreferrer">http://devzone.advantagedatabase.com</a> In addition, you will want the full help file which includes a copy of Cary Jensen's marvelous "Advantage Database Server, a Developer's Guide", available the same place, which will help you with the getting up to speed on SQL in Advantage, and SQL in general. You have a couple of options depending on exactly what it is you are trying to accomplish. You could create an SQL script and take your statement into a temporary table as in</p> <pre><code>Select into #MyTemp --all the rest of the complex SQL command-- </code></pre> <p>Then you can do what you want with that file to pare it down. If, however, you just want a list of patients that have a certain diagnosis code, you can do something like</p> <pre><code>Select pat.id, pat.name, pat.address from pat where pat.id in (Select id from tran where diag1 in ('123.3','123.4') UNION Select id from tran where diag2 in ('123.3','123.4') UNION Select id from tran where diag3 in ('123.3','123.4') UNION Select id from tran where diag4 in ('123.3','123.4'); </code></pre> <p>And if you need to do it in Crystal, you can create that union set using the AddCommand section...just make sure you are using the Advantage Crystal Driver, set up correctly, and obtainable from...you guessed it...Advantage Devzone</p> <p>Hope that helps.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload