importing checkboxes and repeating fields

[mikihasa]

ODBC Users?

Is it possible to import checkbox data (where value fields are used) and repeating field data?

I am using the native ODBC driver in FMP to import records into a FMP file.

1) How can I get multiple checkboxes in a value field list to be checked based on the import data?

2) How can I fill repeating fields?

I am trying to use the ASCII character number 29 (which according to FM is what separates repeating field data in the output), but all that does is:

1) cause no check boxes to be checked (since none of my value fields has the special ASCII character in them)

2) includes a nonprintable character (ASCII 29) in the first field of a repeating set

Please let me know if anyone participating in this forum is using ODBC (SQL) to import data.

Michael

[mikihasa]

The answer to importing groups of checkboxes that have multiple selections is to separate the data with a carriage return. One down and one to go...

I'd still like to know if there is a magic character that can be used to tell FMP to skip to the next field in a repeater. Using a return (like with the checkboxes) just jumps to the next line in the first section of the repeating field, which is close but not correct.

Is this (filling repeating fields) impossible because SQL doesn't do repeating fields? Is it that I just don't know the right character to stick in there?

Should I just not use the handy repeating field feature?

Is anyone out there?

Michael

[reginaldlo]

Did you figure out how to get the repeating fields working? I'm having the same problem with ascii 29 having no effect through SQL.