|
You have to alias them. It is the only option.
<br>(So, you must do something like:
<br>SELECT
<br> date AS MY_DATE,
<br> time AS MY_TIME
<br>FROM
<br> table
<br>)
<br>
<br>A couple of things to consider:
<br>
<br>1) I understand that the table has many fields, but are you actually using them all? Could you not have a short list of just the fields you need?
<br>(For example:
<br>SELECT
<br> f1,
<br> f2,
<br> f3,
<br> date AS MY_DATE
<br>WHERE
<br>etc.
<br>)
<br>
<br>2) Do a describe of the table and output it to a text file. Use that to actually reference every field in the table, changing date and time as above. Since a describe does most of the work for you, this isn't too bad.
<br>
<br>3) If you have control over the table, and it isn't required that the fields be named date and time, change the field names.
<br>
<br>You will probably also have a problem with the @USER$ variable. You won't be able to use it in your application, as it shouldn't be a valid variable name...
|
