Announcement

Collapse
No announcement yet.

Xbase 3 - Database Relations

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Xbase 3 - Database Relations

    How are Miva programmers accomplishing database relations using dBase3 databases?

    Do you have to write functions that perform MvFinds?

    Thanks in advance,
    Tim

    #2
    Re: Xbase 3 - Database Relations

    Originally posted by tmallardi View Post
    How are Miva programmers accomplishing database relations using dBase3 databases?
    Mostly, we don't :^) . SQL is sooooo much easier to use.

    A while ago, I had to do a "downgrade" project, where a user of MM4 wanted me to write them a custom search module, similar to one I had already written for MM5 using SQL. Writing code to emulate the SELECT query across multiple tables turned out to be kind of complex. Since there's no JOIN operation, I basically had to create a loop on the first table, then have it do MvFINDs for the other tables one at a time. It took a lot more code than a SELECT, but conceptually it wasn't too bad.

    HTH --
    Kent Multer
    Magic Metal Productions
    http://TheMagicM.com
    * Web developer/designer
    * E-commerce and Miva
    * Author, The Official Miva Web Scripting Book -- available on-line:
    http://www.amazon.com/exec/obidos/IS...icmetalproducA

    Comment


      #3
      Re: Xbase 3 - Database Relations

      Originally posted by Kent Multer View Post
      Mostly, we don't :^) . SQL is sooooo much easier to use.

      HTH --
      Sounds like I need to start programming SQL with the big boys.
      I sure love how easy it is to manage xBase3 data files using CDBF though.

      Comment

      Working...
      X