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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Temporarily bypassing unique constraint
Hey I am trying to do an insert into ... select * from ... I am basically migrating some old data into a table with an identical schema. If I try and do this as a straight insert into select * ... the pkey field unique constraint stops this from working.. I know I can do it by using...- Quilmes
- Thread
- Replies: 3
- Forum: PostgreSQL Inc.: PostgreSQL
-
How to use WINAPI functions from c#
Hi, I am trying to use the WINAPI function: GetColorDirectory which is located in mscms.dll. I have done the DLLImport statement properly and i can get one of the buffers to fill. The spec for this function is: BOOL WINAPI GetColorDirectory( PCTSTR pMachineName, PTSTR pBuffer, PDWORD...- Quilmes
- Thread
- Replies: 3
- Forum: C# (C sharp): Microsoft
-
Access allowing duplicate primary keys
Hi I am creating primary keys using a random number generator with some other modifications. The primary keys are of type double. I have witnessed a situation where I inserted two primary keys which appear exactly the same when I look at the table in Access, however Access allowed their...- Quilmes
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
-
How can I pass query string containing underscores in netscape?
Hi I have written some Perl scripts which allow users to manipulate a database from a web interface. The problem I am experiencing is that when a particular script tries to pass data to another script in the query string, Netscape gives an invalid URL error. I am quite sure that the problem is... -
Sorting text databases with perl's sort function
Hi, I have a flat file text database with fields separated by pipes. I have to be able to sort any text field in descending or ascending order. I have tried to use the perl sort function in combination with building up a hash as I have seen in other posts. I can get it to work if I make the...
