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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Summarise a SQL List
I have a table ... ID TXT 1 dogfood 1 catfood 1 catfood 1 catfood 2 dogfood 3 dogfood 3 <null> 4 <null> 5 dogfood 5 dogfood 5 dogfood and I want it to produce ... ID TXT 1 mixed 2 dogfood 3 mixed 4 <null> 5 dogfood (in other words, if all txt values are the same for an id...- mark06
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
CLOB Storage Parameters - 8.1.5
If you explicitly define storage for your CLOB columns, make sure that initial_extent is the same as next_extent (I have pctincrease of 0), otherwise you'll find a HUGE index for the CLOB will be created. Don't know if this is addressed in 8.1.6. PS. Anybody got any tips on improving the...- mark06
- Thread
- Replies: 0
- Forum: Oracle: All versions
-
SQL Server Message 7370
"One or more properties could not be set on the query for OLE DB provider 'MSDASQL'. The provider could not support a required property."<br> <br> Connecting to a linked server (Oracle) from a network install of SQL Server and performing any SQL query gives the above message. When I...- mark06
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
DBGrid binding to a database
My select statement to generate the DBGrid in VB6 contains a join from the data table to the reference table so descriptive text is displayed instead of a code number. When I change the text entry (via a dropdown from the appropriate column - button property set to true) the reference table is...- mark06
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
