Forum Replies Created

Viewing 15 posts - 31 through 45 (of 112 total)

  • RE: Videos and Images

    Thhat covers images...any chance of mpegs for example?

    😉

    quote:

    Take a look at the image data type

    Sorry Jeremy, another standard link from me


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    December 4, 2003 at 9:28 am

    #484652

  • RE: sql server/vb references

    Thought about Vaughns book but ive heard it doesnt have many examples......but this is the only one people keep recommending. Have you have any experience of it?


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    November 17, 2003 at 8:06 am

    #482227

  • RE: Connecting SQL Server 2000 and Visual Basic 6.0

    Its fine now.........just a stupid mistake

    Cheers Frank

    quote:

    Did you reference Microsoft ActiveX DataObjects in your project?

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    If...


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    November 10, 2003 at 6:30 am

    #481403

  • RE: Connecting SQL Server 2000 and Visual Basic 6.0

    Only skydivers know why birds sing.........

    quote:

    Eagles fly. Turkeys skydive.

    If...


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    October 29, 2003 at 5:10 am

    #480066

  • RE: Connecting SQL Server 2000 and Visual Basic 6.0

    Thanks guys..Im sure ill come back very soon for some more advice!

    Cheers

    quote:

    hi!

    concerning the example: don't forget to use "tools/references" to add...


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    October 21, 2003 at 4:30 am

    #478912

  • RE: Connecting SQL Server 2000 and Visual Basic 6.0

    Cheers Frank......Basically the VB app is going to be a UI for the database.....does this make a difference to any methods ill need?

    quote:


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    October 20, 2003 at 6:42 am

    #478767

  • RE: Frank

    Well Frank..your secrets out, we can never look at you the same again!

    If riding in a plane is flying, then riding in a boat must be swimming....


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    August 21, 2003 at 9:01 am

    #470794

  • RE: Self referencing tables & Identity columns

    Im no expert, but when you insert the first time, does it not some how reference to the foreign key, so when you delete it there is still some kind...


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    August 21, 2003 at 6:49 am

    #470750

  • RE: INNER JOINS

    Frank...sorry, overlooked your last post...in the SUM() Im getting an obviously incorrect large number.....

    If riding in a plane is flying, then riding in a boat must be swimming. To experience...


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    August 21, 2003 at 5:16 am

    #470734

  • RE: INNER JOINS

    OK, have played around with OUTER JOIN but the result is still too huge.....

    If riding in a plane is flying, then riding in a boat must be swimming. To experience...


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    August 21, 2003 at 5:03 am

    #470731

  • RE: INNER JOINS

    So you reckon if I replace INNER JOIN with LEFT (OUTER) JOIN it may correct my problem?

    If riding in a plane is flying, then riding in a boat must be...


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    August 21, 2003 at 4:52 am

    #470725

  • RE: INNER JOINS

    >>Might you should consider using LEFT

    >>(OUTER) JOIN ?

    would that be in each instance or just to join the 3rd table?

    Cheers,

    Frank

    [/quote]

    If riding in a plane is flying, then riding in...


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    August 21, 2003 at 4:44 am

    #470723

  • RE: INNER JOINS

    WORKGROUPS

    ----------

    38.01.0100.0Styling ...


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    August 21, 2003 at 4:39 am

    #470721

  • RE: INNER JOINS

    Is there a way to paste portions of tables into the forum?

    If I have to type out some sample data itll take me yeears!

    If riding in a plane is...


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    August 21, 2003 at 4:33 am

    #470718

  • RE: updates on new tables

    No, I think I have a solution though, the table was in fact empty..what a bloody fool!

    sorry guys..ill use an isert instead.

    just goes to show what staring at a screen...


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

    August 19, 2003 at 4:53 am

    #470385

    • Viewing 15 posts - 31 through 45 (of 112 total)