| View previous topic :: View next topic |
| Author |
Message |
Brahmaputra Reddy
Beginner
Joined: 29 Feb 2004
Posts: 2
Topics: 1
|
 Posted: Wed Mar 03, 2004 4:06 am Post subject: Select statement in EZT |
 |
|
hi all,
i am using the select statement in the Easytrieve program and I am getting an error !
pls help me some in select statement in EZT !
I am using like this !
select field-name into host-varible from table name where col = host-var
is this correct or not pls confirm me any one !!
_________________
Thanks & Regards
C Brahmaputra Reddy
Last edited by Brahmaputra Reddy on Mon Mar 08, 2004 4:03 am; edited 1 time in total |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Wed Mar 03, 2004 9:00 am Post subject: |
|
|
Brahmaputra Reddy ,
Are you using a dynamic bind or STATIC bind in your program? If you are using dynamich bind then you need to define the sql statement as a cursor. You need to open , fetch and close the cursor.
For static bound programs you can use select column into host-variable directly.
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Brahmaputra Reddy
Beginner
Joined: 29 Feb 2004
Posts: 2
Topics: 1
|
| Posted: Fri Mar 05, 2004 12:14 am Post subject: |
|
|
Hi Kolusu,
I am using STATIC bind in the program.
executed as u said and got the result.
_________________
Thanks & Regards
C Brahmaputra Reddy |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
