Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

how to extraxct data from a view.

Former Member

‎04-26-2007 8:39 AM

0 Kudos

hi,

i'm tying to extrct data from a view vbdka, with select. but i;m getting a syntax error that it anot a DB Table or DB view, pls tell me how to extract data from that view.

thanks.

4 REPLIES 4

Former Member

‎04-26-2007 8:49 AM

0 Kudos

Hi,

Please ensure that you have declared tables : vbdka at the top.

Former Member

‎04-26-2007 8:51 AM

0 Kudos

You are getting error because vbdka is not a VIEW, it is structure.

you need to find the table for same from where you can select the data.

Former Member

‎04-26-2007 8:54 AM

0 Kudos

hi,

just check out if u have declared the table or not n see if it is not a structure also

madhuri.

Former Member

‎04-26-2007 8:58 AM

0 Kudos

Hi

I checked vbdka, its only a stucture, you cant use that to retrieve data,Please collect from correct table.