Forum Replies Created

Viewing 13 posts - 16 through 28 (of 28 total)

  • RE: Increment dates for a set of records

    Thanks PietLinden.  This seems very simple and easy to implement.

    I will play around with it and see how I go.

    thanks

  • RE: Write Conflict

    Hi Mark.  that's Interesting.  Thanks for the tip.  I'll look into it. For example can i create the table with the 0 value as the default?
    Thanks again.
    Cheers

  • RE: Write Conflict

    Thanks to all those responded.

    I solved the issue by altering all the bits fields to TinyInt fields. This them solved the write conflict issue, but created an issue...

  • RE: How to do a basic loop in SQL

    Thanks for the warning Lynn.
    As I said, I want it to work before I make it pretty.  So far, I have not found a method that does what I...

  • RE: How to do a basic loop in SQL

    Thank you pietlinden, but in both of those examples, you are required to provide a SourceString and a TargetString.  The point of my requirement was to collect a target string...

  • RE: How to do a basic loop in SQL

    It's part of a wider series of functions. 
    I have a table which produces around 10 records, each is a mispelt name.  I need to compare each of these...

  • RE: How to do a basic loop in SQL

    Thanks Lynn,
    I understand this is how to select a column.  I'm interested in learn how to incrementally select each record in that column... that is, to return the value...

  • RE: Returning Number of records deleted

    Thank you for your response.
    I had thought something like this, but am getting the error 'Invalid attribute/option identifier'

    Wait a second!  Stop everything!  Hold the phone!  The input...

  • RE: Write Conflict

    Thanks all who responded.
    Unfortunately, there is a requirement for the Bit fields to be null as the default. However, I modified the fields to [Smallint] and that seemed to...

  • RE: Findfirst VBA for SQL table

    Thanks to all who responded.

    I have learned that ADO is the best option.  It works just fine.  I wanted to avoid it because so much of my Db...

  • RE: How to set the primary key for each table

    Thanks again Johnathan for your quick response.
    Unfortunately this is not generating a value in my messages window and not applying a PK to any table, even if I switch...

  • RE: How to set the primary key for each table

    Thank you Johnathan.

    This seems awesome!

    The problem is I ended up having to manually create the PK on all tables, which took ages.  so to run this,...

  • RE: How to set the primary key for each table

    Thank you all for your replies!

    TripleAxe - this is exactly what I was looking for, thank you. I presume I can use this with the exec command and...

Viewing 13 posts - 16 through 28 (of 28 total)