I am currently using PB 9.01 and I am getting an error on one particular persons records during the retrieve of the dw. The person has 374 rows that should come up in the dw when the retrieve is finished but all that happens is that I receive a "2 Select error: ". There are a ton of other people in the database with more records than 374 and they are all coming up fine. Any ideas???
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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
2 Select error on a datawindow
- Thread starter leppy
- Start date
well, normally select errors are due to incorrect column specifications in the datawindow.
say, for example surname is defined as varchar(50) in database, whereas it is defined as varchar(20) - you will get a "select error" when a row that has a surname of more than 20 chars is retrieved.
to fix this, double check your column specifications & goto sql mode of datawindow, press a space and delete it [pretend to make a change] and save the datawindow...
say, for example surname is defined as varchar(50) in database, whereas it is defined as varchar(20) - you will get a "select error" when a row that has a surname of more than 20 chars is retrieved.
to fix this, double check your column specifications & goto sql mode of datawindow, press a space and delete it [pretend to make a change] and save the datawindow...
- Status
Similar threads
- Locked
- Question
- Locked
- Question