Re: Data module and toolbar

Article View: borland.public.vdbase.data.sql

Article #1443

Back to borland.public.vdbase.data.sql Previous Next

#1443

From: Bowen Moursund
Date: Fri, 26 Dec 1997 00:00

25 lines
1300 bytes

>I have a form with a data module that's opening a default table.
>I like that the user can open another table (the same structure) with a
file
>open tool button on the toolbar using the GETFILE() function.  I don't know
>how to change the default table with the new table name.

Perhaps something like:

function OpenNewTableButton_OnClick
   cTable = getfile()
   if isblank(cTable)
      return
   endif
   with (form.datamodref1.ref.DefaultTableQuery)
      active = false
      sql = "select * from " + cTable
      active = true
   endwith
   form.rowset = form.datamodref1.ref.DefaultTableQuery.rowset
   return
__
Bowen Moursund (TeamB)
bowen.NOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm

Technical Details

Message-ID: <680tjl$m3a3@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <67vuvt$lr41@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,d1f3b1f4f16bb118
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund" <teamb@opto-pps.com>
Subject: Re: Data module and toolbar
Date: 1997/12/26
Message-ID: <680tjl$m3a3@forums.borland.com>
X-Deja-AN: 310349251
Content-Transfer-Encoding: 7bit
References: <67vuvt$lr41@forums.borland.com>
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: DataTech
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message