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!
-
Using SUBST command for linked databases.
The long forgotten SUBST Dos command can be very useful for using linked, network mapped, tables in an "off network" develpment setup. SUBST creates a virtual drive letter and enable the develper to "simulate" the network drive. I recently has one client who had a...- lcapece
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
-
Help with enabling PK / Rollback segment problems
I am having a problem with enabling a primary key constraint on a large table: Table has apprx 100 Million rows, the PK is disabled due to the fact that there are about 1 Million dupe rows. My problem is when I enable the PK using the EXECEPTIONS into EXCEPTIONS clause, the rollback rollback...- lcapece
- Thread
- Replies: 1
- Forum: Oracle: All versions
-
Referencing Column #2 in Multi Select Listbox
Help: I have a multiselect listbox with 2 colums, when looping throgh the .itemdata of the .selected collection, I need to reference both Column #1 and #2 current selected values. Not sure if you use the .column property, which I can not get to work at all. Any help is much appreciated. Louis...- lcapece
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Need help with PL/SQL procedure
Although I have SQL/DBA experience in Oracle8, I am not versed in PL/SQL; pehaps someone can help: I need to create function to build a "word list index" by extracting all unique words from a varchar2 field. (I realize Context/Intermedia will do this, however I can not install it at...- lcapece
- Thread
- Replies: 3
- Forum: Oracle: All versions
