Search:
Type: Posts; User: paulw
Search:
Search took 0.25 seconds.
-
How did you create the foreign key?
You could try dropping the constraint, checking that you can add to table 1 and then re-addig the FK constraint. There should be no problems as you describe it....
-
Are the databases native or is it linked or what. What kind of indexes have you got. Clustered is likely to be the fastest in SQL Server but depending on the structures non-clustered can sometimes...
-
What version of SS are you using Jemima, 2000 could let you use a User Defined Function to return a table type structure.
P.
-
Could be possible, depends on the missus.
P.
-
I have just been incredibly busy. I ought to 'phone the 'Gaff' and get him to take me to lunch.
Where in Londres are you? We must beer, soon.
And you are right, I don't love any of you any more...
-
Course I will post. Some of us have a day job you know....
How's it all going. Long time since I was here.
P.
PS well noticed.
-
You sure you are comparing like with like. Depends how the data is indexed etc. SQL Server will eat Access for breakfast but if you put a slow network link in front or do it ISAM style.
I'd need...
-
What version of SQL Server exactly - it could be a limitation on the connections allowed. Never really used it under w98.
Cheers,
P.
-
Invisible - you rat you - I only wanted a half <ahem>. Anyway my ravishing days are over - it's too dangerous - see the biog...
Cheers,
P.
-
Yeh, right. The US has a real history of clean, well defined campaigns that go flawlessly and never escalate
Vietnam; Yugoslavia; Desert Storm (my, are we STILL there?)
Yours doubtfully.
P.
-
OK Here we go - back to the top.
A little vignette of married life.
The scene: a terraced house in Outer London - an ordinary house. A family house.
Scene 1: Late Evening
[Enter Father,...
-
OI Gaffer, td, STOP CHIT CHATTING and do some WORK!!!
P.
-
You can use & to concatenate with a zero length strings but it is a kludge and "" may not be allowed either. Don't allow nulls in the database in the first place.
If the data is numeric you would...
-
cya HW
Gaff - Friday's deadline - 6 at Cannon's...
P.
-
Especially if it is alot of code.
P.
-
Still workin'
Homework would be nice... Now I have a mortgage and responsibilities... sigh.
:(
P.
-
Seeing as your invisible, you can hang around and listen to the conversations for ages...
I don't know Cannons too well, I've only ever been there with Vbers! but it only has one bar so it...
-
Does setting to nothing actually destroy the object or set the object pointer to null? It may be the object exists but is marked for overwriting, rather like deleting a file.
Academic interest...
-
Well I know what Gaffer and td look like and I'll be the one trying to pretend I'm not with them really....
P.
-
Have you set the reference to the Access Object Model?
Check out your references list.
Cheers,
P.
-
That is late binding which ASP must use since it is stateless. You can use the same syntax in VB but early binding is much quicker. It requires a reference to the oject model required and would be of...
-
Have you noticed the (Cancel As Integer) part of the BeforeUpdate?
If you do not want to update then you set Cancel to true.
It does work - I use it.
Cheers,
P.
-
Much more efficient to use an INSERT SQL statement with the VALUES parameter. The field names and values are available form your recordset - In fact you might be able to do the whole thing in one...
-
-
Just learnt that td was shagging my missus Monday - ***** her then, I'm coming boozing Friday...
[paul gets a slap from his missus]
No, of course I won't be late dear....
Hope to see you...
-
It is a bug in the way in which VB handles dates - it does not perform as documented. You can try the same thing in Excel. The number returned is the count of days since 1/1/1980. This is counted as...
-
Why would your sheep want to wear shin pads?
Cheers,
P.
-
You surround the words with Code tags
code
/code
and enclose those in square brackets
[ code]
some code here
[/ code]
-
You have to get the train up. F***in Railtrack. Tell 'em to get the train out of bed earlier...
Cheers,
P.
PS Told you we were fated not to meet. (AND NO GAY JOKES PLEASE)
-
Mmmm. Maybe I can't make it after all...
P.
-
Ok I can feel the pressure building. What time was it?
I'll see if the wife can spare me for a cheeky half...
Cheers,
P.
-
Create a table with that structure and add the data to it using standard SQL.
Cheers,
P.
-
'noon all; back from lunch now.
Gaffer: **** van Dyke is an unusual Dutch sexual practice, the Welsh have their sheep, the Dutch have dykes.
Cheers,
P.
-
Probably NOT on balance...
This could be the start of something BIG - secret programmers why is the defence ministry MOD? What about...
Maybe it isn't the start of something BIG :rolleyes:
P.
-
BLEEUGHHHH! (Same as English - it's international).
Cheers,
P.
-
Just noticed the famous auto-moderation - lucky my name is not Richard!
P.
-
Is that moral or morale?
Gaffer, you are as good a cockney as **** van Dyke... You're meant to be born within the sound of Bow bells, not pissed every night within the sound of them....
Cheers,...
-
Dying, dying, dead...
Yep, its going methinks.
Morning all remaining acolytes.
Cheers,
P.
-
The biggest problem with RecordCount is one of speed. To get an accurate count each and every record has to be visited. It only has real meaning for a static set. It is much preferable to use the...
-
What problem are you getting and what are the details of strAdoCon?
P.
|
Click Here to Expand Forum to Full Width
|