Xojo Conferences
MBSOct2019CologneDE

FileMaker via ODBC - anyone doing this ?? (Real Studio network user group Mailinglist archive)

Back to the thread list
Previous thread: 4.0.2 and Type 2
Next thread: AE: returning records


Re: Yielding time to other apps and windows   -   Mike Benonis
  FileMaker via ODBC - anyone doing this ??   -   Tracy
   Re: FileMaker via ODBC - anyone doing this ??   -   Aldo Bergamini
   Re: FileMaker via ODBC - anyone doing this ??   -   Ian Jempson
    Re: FileMaker via ODBC - anyone doing this ??   -   Chris Malumphy

FileMaker via ODBC - anyone doing this ??
Date: 07.05.02 07:15 (Tue, 7 May 2002 18:15:26 +1200)
From: Tracy
Hi Listers
Is anyone using Filemaker via ODBC plugin ??

I am interested in single user usage only, so it will be on a local hard
disk.

Cheers Tracy

---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>

Re: FileMaker via ODBC - anyone doing this ??
Date: 07.05.02 11:47 (Tue, 7 May 2002 12:47:42 +0200)
From: Aldo Bergamini
Tracy is believed to have said:

>Hi Listers
>Is anyone using Filemaker via ODBC plugin ??
>
>I am interested in single user usage only, so it will be on a local hard
>disk.
>
>Cheers Tracy

I am working with the ODBC plugin, but with a different database (PrimeBase).

Rgds
Aldo

---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>

Re: FileMaker via ODBC - anyone doing this ??
Date: 07.05.02 20:32 (Tue, 07 May 2002 20:32:44 +0100)
From: Ian Jempson
Hi Tracy

I did take a look at this and had it working. The problem I came across was
the speed issue when dealing with databases with large numbers of fields. My
impression was that FileMaker seemed to evaluate all summary fields before
returning values to any requests. Took ages if you're dealing with a
database of even a few thousand records.

hth
Ian

on 7/5/02 7:15 am, Tracy at <email address removed> wrote:

> Hi Listers
> Is anyone using Filemaker via ODBC plugin ??
>
> I am interested in single user usage only, so it will be on a local hard
> disk.
>
> Cheers Tracy
>
> ---
> Subscribe to the digest:
> <mailto:<email address removed>>
> Unsubscribe:
> <mailto:<email address removed>>

---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>

Re: FileMaker via ODBC - anyone doing this ??
Date: 07.05.02 23:53 (Tue, 07 May 2002 18:53:07 -0400)
From: Chris Malumphy

I connect my RB programs to Filemaker Pro 5 frequently.

I have a DB with thousands of records and while it is not what I call
fast, it is more than acceptable for a single user.

What I do is make sure make sure the ODBC Database is in the RB plugins
folder.

Make sure the Filemake DB is open and the Access Privileges and Sharing
are set (single user, local data access companion).

Then in RB I use code like the following (with DBNames and passwords
provide by in my user interface) to put the results of an sql into a
listbox:

dim n, nfields, nrecords as integer
dim s, db_string as string
dim dbcursor as databasecursor

listBoxResults.deleteAllRows
tabPanel1.value = 2
db_string = "DSN=" + trim(editfieldDBname.text) + ";UID=" +
trim(editfieldLogIn.text) + ";PWD=" + trim(editfieldPassword.text)

db=OpenODBCDatabase(db_string, 0, "")

s = editfieldSQL.text
dbcursor = db.sqlselect(s)
nfields = dbcursor.fieldcount
editfieldDisplayFields.text = str(nfields)
listBoxResults.columncount = nfields
for n = 1 to nfields
listboxResults.heading(n-1) = dbcursor.idxField(n).name
next
while not dbcursor.eof
for n = 1 to nfields
if n = 1 then
nrecords = nrecords + 1
listBoxResults.addrow dbcursor.idxField(n).stringValue
else
listBoxResults.cell(listboxResults.lastindex, n-1) dbcursor.idxField(n).stringValue
end
next
dbcursor.movenext
wend
db.close
listboxResults.addrow "N = " + str(nrecords)

Exception
msgBox "Some error happened in Execute_SQL"



---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>