#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Mexico
    Posts
    3
    Rep Power
    0

    Talking 3 easy questions . . .


    First
    I'm using

    Delphi 7 Enterprise
    M$ SQL Server 2000
    M$ 2000 Server
    M$ 2000 Workstation

    First question:
    Wich is the best option to connect Delphi with M$ Server 2000?

    Second question:
    I'm using ADO to connect Delphi with M$ Server 2000. I know that ADO doesn't have LocateNext. How to implement this function ( right now I'm using Locate then a Next funcion)

    Last, do you know a software to document my source code? Flowcharting etc?. ( best if it is free )

    Comments on this post

    • Gran Roguismo agrees
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed God 1st Plane (5500 - 5999 posts)

    Join Date
    Oct 2000
    Location
    Back in the real world.
    Posts
    5,966
    Rep Power
    191
    First question:
    Wich is the best option to connect Delphi with M$ Server 2000?
    What does "connect" mean for you? Could be as simple as:
    TStream.Create("\\server\share\file", fmOpenRead)... If this is not what you want, tell a little more details please.
    The WinAPI (Help / Win32 or similar) is your friend...

    Second question:
    I'm using ADO to connect Delphi with M$ Server 2000. I know that ADO doesn't have LocateNext. How to implement this function ( right now I'm using Locate then a Next funcion)
    What's bad about this way? If you need it in a ADO component, derive your own class from them

    Last, do you know a software to document my source code? Flowcharting etc?. ( best if it is free )
    I never used Delphi 7, only the 6 version and it comes with a simple flowcharting software built-in, the charts can be connected to source code and such. You can toggle the view from source code to flowchart and vice-versa. Sorry, can't remember how to activate it, I suggest you read the manual....
    Free flowcharting software has been discussed here recently, do a search.

    A tip on code documentation: Search google for "javadoc", this is IMO kinda standard to document code. You put special comments in it similar to this:
    Code:
    procedure loadFromFile(filename: String; replace: Boolean);
    { ** Loads a document from a file 
    @author: me
    @version: 1.0
    @params:
      filename: "The File's name"
      replace: "true: replace the current document or false: open a new window"
    ...
    }
    begin
    ...
    end;
    JavaDoc will extract this info from your source code and make html, pdf, or other formats from it...
    (I never used it with delphi, but I see no reason why it should not work)

    hth,
    M.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Mexico
    Posts
    3
    Rep Power
    0
    Hi
    First question:
    'Best way to use Delphi with MS SQL Server. Querys, stored procedures etc.



    "derive your own class from them "
    eeerrr... well.....mmmm.....ok.


    "do a search"
    I Will...


    Regards.
  6. #4
  7. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,643
    Rep Power
    4248
    Originally posted by Fajardo
    Hi
    First question:
    'Best way to use Delphi with MS SQL Server. Querys, stored procedures etc.

    "derive your own class from them "
    eeerrr... well.....mmmm.....ok.

    "do a search"
    I Will...
    Regards.
    1. Depends on what you want to do. I use both tadoquery and tadostoredproc objects. Most of the time though, I tend to use tadostoredproc because we write stored procs for just about anything to add an extra layer of abstraction between the front end and the database engine. The reason is that it is easier to maintain that way for us. If I use a TAdostoredproc and then make a minor change to the stored proc, I don't need to redistribute the app throughout the office. With a TAdoQuery object, I need to make changes to the delphi code, recompile the app and then tell everyone in the office that uses the app, to grab the latest and greatest code.

    2. Delphi's ADO objects have the Locate method which does the same thing. See the documentation for TCustomADODataSet.Locate in your help.

    3. http://www.fatesoft.com/s2f/ is one. DISCLAIMER -- I just googled for it. Personally, my opinion of flowcharts is that only neanderthals drew flowcharts and look what happened to them . Seriously though, I'm about the only one in the office that is anal about documenting everything, and I don't draw program flowcharts much either. The only flowcharts we draw are functional diagrams to explain functionality to the managers, not actual logic flowcharts.
    Last edited by Scorpions4ever; October 24th, 2003 at 04:21 PM.
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Mexico
    Posts
    3
    Rep Power
    0
    Thanks M.Hirsch and Scorpions4ever.

IMN logo majestic logo threadwatch logo seochat tools logo