Search:

Type: Posts; User: paulw

Page 1 of 13 1 2 3 4

Search: Search took 0.25 seconds.

  1. Replies
    21
    Views
    929

    How did you create the foreign key? You could...

    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....
  2. Are the databases native or is it linked or what....

    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...
  3. Replies
    9
    Views
    682

    What version of SS are you using Jemima, 2000...

    What version of SS are you using Jemima, 2000 could let you use a User Defined Function to return a table type structure.

    P.
  4. Thread: Paul W

    by paulw
    Replies
    5
    Views
    386

    Could be possible, depends on the missus. P.

    Could be possible, depends on the missus.

    P.
  5. Thread: Paul W

    by paulw
    Replies
    5
    Views
    386

    I have just been incredibly busy. I ought to...

    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...
  6. Thread: Paul W

    by paulw
    Replies
    5
    Views
    386

    Course I will post. Some of us have a day job you...

    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.
  7. You sure you are comparing like with like....

    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...
  8. Replies
    11
    Views
    785

    What version of SQL Server exactly - it could be...

    What version of SQL Server exactly - it could be a limitation on the connections allowed. Never really used it under w98.

    Cheers,

    P.
  9. Replies
    329
    Views
    8,341

    Invisible - you rat you - I only wanted a half...

    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.
  10. Replies
    42
    Views
    1,432

    Yeh, right. The US has a real history of clean,...

    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.
  11. Replies
    329
    Views
    8,341

    OK Here we go - back to the top. A little...

    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,...
  12. Thread: Post Race!

    by paulw
    Replies
    68,909
    Views
    18,137,021

    OI Gaffer, td, STOP CHIT CHATTING and do some...

    OI Gaffer, td, STOP CHIT CHATTING and do some WORK!!!

    P.
  13. Replies
    5
    Views
    6,911

    You can use & to concatenate with a zero length...

    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...
  14. Replies
    22
    Views
    731

    cya HW Gaff - Friday's deadline - 6 at...

    cya HW

    Gaff - Friday's deadline - 6 at Cannon's...

    P.
  15. Replies
    5
    Views
    437

    Especially if it is alot of code. P.

    Especially if it is alot of code.

    P.
  16. Replies
    22
    Views
    731

    Still workin' Homework would be nice... Now I...

    Still workin'

    Homework would be nice... Now I have a mortgage and responsibilities... sigh.

    :(
    P.
  17. Replies
    329
    Views
    8,341

    Seeing as your invisible, you can hang around and...

    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...
  18. Replies
    3
    Views
    414

    Does setting to nothing actually destroy the...

    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...
  19. Replies
    329
    Views
    8,341

    Well I know what Gaffer and td look like and I'll...

    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.
  20. Replies
    10
    Views
    628

    Have you set the reference to the Access Object...

    Have you set the reference to the Access Object Model?

    Check out your references list.

    Cheers,

    P.
  21. Replies
    1
    Views
    469

    That is late binding which ASP must use since it...

    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...
  22. Thread: Access

    by paulw
    Replies
    8
    Views
    566

    Have you noticed the (Cancel As Integer) part 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.
  23. Replies
    3
    Views
    587

    Much more efficient to use an INSERT SQL...

    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...
  24. Replies
    329
    Views
    8,341

    bitch... :D P.

    *****... :D
    P.
  25. Replies
    329
    Views
    8,341

    Just learnt that td was shagging my missus Monday...

    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...
  26. Replies
    10
    Views
    632

    It is a bug in the way in which VB handles dates...

    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...
  27. Thread: Post Race!

    by paulw
    Replies
    68,909
    Views
    18,137,021

    Why would your sheep want to wear shin pads? ...

    Why would your sheep want to wear shin pads?

    Cheers,

    P.
  28. Thread: VB Code

    by paulw
    Replies
    15
    Views
    489

    You surround the words with Code tags code...

    You surround the words with Code tags

    code
    /code

    and enclose those in square brackets

    [ code]
    some code here
    [/ code]
  29. Replies
    329
    Views
    8,341

    You have to get the train up. F***in Railtrack....

    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)
  30. Replies
    329
    Views
    8,341

    Mmmm. Maybe I can't make it after all... P.

    Mmmm. Maybe I can't make it after all...

    P.
  31. Replies
    329
    Views
    8,341

    Ok I can feel the pressure building. What time...

    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.
  32. Thread: merge recordsets

    by paulw
    Replies
    1
    Views
    483

    Create a table with that structure and add the...

    Create a table with that structure and add the data to it using standard SQL.

    Cheers,

    P.
  33. Thread: Post Race!

    by paulw
    Replies
    68,909
    Views
    18,137,021

    'noon all; back from lunch now. Gaffer: ****...

    '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.
  34. Replies
    4
    Views
    299

    Probably NOT on balance... This could be the...

    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.
  35. Replies
    329
    Views
    8,341

    BLEEUGHHHH! (Same as English - it's...

    BLEEUGHHHH! (Same as English - it's international).

    Cheers,

    P.
  36. Thread: Post Race!

    by paulw
    Replies
    68,909
    Views
    18,137,021

    Just noticed the famous auto-moderation - lucky...

    Just noticed the famous auto-moderation - lucky my name is not Richard!

    P.
  37. Thread: Post Race!

    by paulw
    Replies
    68,909
    Views
    18,137,021

    Is that moral or morale? Gaffer, you are as...

    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,...
  38. Thread: Post Race!

    by paulw
    Replies
    68,909
    Views
    18,137,021

    Dying, dying, dead... Yep, its going methinks....

    Dying, dying, dead...

    Yep, its going methinks.

    Morning all remaining acolytes.

    Cheers,

    P.
  39. Thread: RecordCount = 0?

    by paulw
    Replies
    9
    Views
    4,087

    The biggest problem with RecordCount is one of...

    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...
  40. Replies
    6
    Views
    460

    What problem are you getting and what are the...

    What problem are you getting and what are the details of strAdoCon?

    P.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width