Search results for query: *

I think you mis-understood this levity of this post. Yes, UNC'ing is the proper way, but if you are developing or fixing a front-end/back-end db offsite, SUBST is a quick way to resolve the links to the table when you can't get access to the network and it's UNCs or dont want do write code to...

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...

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...

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...

Nebuchednezzar , Thanks VERY MUCH! This procedure works great. I am now able the seach any embedded word within the description of a product in under 5 seconds. The main table has about 480K rows and the index table has 5.2M rows. I would suggest this procedue to anyone who needs high...

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...