Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Field Names as Variables

Status
Not open for further replies.
hilbertl3

hilbertl3

Technical User
Sep 22, 2004
77
US
Is it possible to use a variable instead of a field name in a cursor? I want to be able to run the cursor for a set of fields, but I want to pass the names of the fields into the cursor as part of the SQL statement.

Hilbert l
 
Sort by date Sort by votes

You would need to use dynamic sql. [3eyes]


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Show value from DATA_DEFAULT field 1
Replies
2
Views
890
Andrzejek
Andrzejek
LarrySteele
  • Locked
  • Question
Trying to Transpose Columns to Rows w/ Field Names 1
Replies
9
Views
550
carp
carp
Andrzejek
  • Locked
  • Question
TOAD - Data display, highlight PK field 1
Replies
4
Views
307
Andrzejek
Andrzejek
rk68
  • Locked
  • Question
Display rows as column header
Replies
3
Views
142
Beilstwh
Beilstwh
kernal
  • Locked
  • Question
CONCAT DayofWeek Fields if Field Value =Y 3
Replies
4
Views
149
kernal
kernal

Part and Inventory Search

Sponsor

Back
Top