Using ODBC to update records in Filemaker

[preston]

When importing files into filemaker, you can designate a "match field" and then update the record with the imported data instead of creating a new record.

I'm working on getting and putting info into Filemaker via ODBC. I can find and retrieve records just fine with ODBC (not the speediest though), but when I try to use a primary key and update a record, it simply creates a new record instead of first finding the matching record. I'd like the behavior of using the primary key as a "Match Field". Is there something I'm missing, or is it as I fear and Filemaker's ODBC implimentation is just poor in this regard.

This is using OS X, and the other side is the UPS Worldship software.

-Preston

[Steverino]

I'm also working on this issue. I think the match field is actually the primary key. What SQL statement are you using? (I tried "SELECT SerialIDfield1 from DATABASE1," but that overwrote unrelated records. I'm now experimenting with "INSERT into DATABASE1(SerialIDfield1) values (SerialIDfield1)" but it doesn't assign the right serial number to the new record. I also tried "values(MAX(SerialIDfield1)+1)", but that messed things up, didn't do what was expected, and caused my program to quit.

[Steverino]

What I probably want is a statement that inserts the default value. Would this work: "INSERT into DATEBASE1" without specifying the column or the value? Or should it be: "INSERT into DATEBASE1(SerialIDfield1) values(<<some way to indicate default>>)"?