| Problems with Substitute Variable Prompts [message #440397] |
Sat, 23 January 2010 13:28  |
Darknss
Messages: 4
Registered: January 2010
|
Junior Member |
|
|
Still kind of a beginner at this, but for some reason when I've tried to use substitute variables, they like to come up in 2's for the prompt. When I have the Set Verify option on, its even more disgusting.
Thank you for at least looking over my problem.
insert into orders
values(&order#, &customer#, &orderdate, &shipdate,
&shipstreet, &shipcity, &shipstate, &shipzip);
Enter value for order: Enter value for customer:
|
|
|
|
|
|
| Re: Problems with Substitute Variable Prompts [message #440399 is a reply to message #440398] |
Sat, 23 January 2010 13:33  |
Darknss
Messages: 4
Registered: January 2010
|
Junior Member |
|
|
|
I did, that is exactly how it responded. I apologize for not using the code. I just saw that now and was going to edit it with the blue outline. But in response to your statement, I did cut and paste my command and exactly what Oracle output to me.
|
|
|
|
| Re: Problems with Substitute Variable Prompts [message #440400 is a reply to message #440399] |
Sat, 23 January 2010 13:43 |
Darknss
Messages: 4
Registered: January 2010
|
Junior Member |
|
|
Apologies for not using the code the first time to isolate my SQL. The first portion is my command and the 2nd part is Oracle's response. Both are cut and pasted directly from the SQL+ Worksheet interface.
insert into orders
values(&order#, &customer#, &orderdate, &shipdate,
&shipstreet, &shipcity, &shipstate, &shipzip);
Enter value for order: Enter value for customer:
|
|
|
|
|
|
| Re: Problems with Substitute Variable Prompts [message #440402 is a reply to message #440401] |
Sat, 23 January 2010 13:55 |
Darknss
Messages: 4
Registered: January 2010
|
Junior Member |
|
|
Thank you very much, it worked just fine under the standard. I'd been using the worksheet plus ever since I started the class, I didn't really even know about standard version. It's mainly an online class, so there isn't a lot of interaction with the teacher. Thanks again for your help, sorry if it was such a simple solution.
TD
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
