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...
Yes very good point, i suppose it's the Engineer in me wanting to generate the largest pool of random numbers i can.
Thankyou very much for your comments re: other data types to use. I will definitely be reevaluating my approach when i come to migration to a grown up db.
Quilmes
Hi
It is adequate for now and probably for a while. This DB will be around for a while, even if and when it is migrated to a more powerful DBMS. So I was thinking about the future - allowing the greatest amount of primary keys.
Thanks
Quilmes
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...
Hi,
Thanks for your quick response.
I chose this method to get the advantage of the larger pool of numbers offered by Access' double type (8 bytes) as opposed to the Long which i think is only 4 bytes in Access (correct me if i'm wrong.)
I agree that it's a weird way to do it, and no i...
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...
Did you start the cygipc service first?
You can get it here: http://www.neuro.gatech.edu/users/cwilson/cygutils/cygipc/index.html
I've had a similar problem to yours (on Win2k), and it turned out that i'd forgotten to start the cygipc daemon.
HIH
quilmes
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.