Jonas_A

What is CDML? It might be right that another solution would be better, but at the stage I am now, it would be too much work to redesign it all. One "ugly" solution that I could do is to install the 255 first chars initially, and after that just update the field with the next 255 chars and so on until the whole string is stored. This sounds like a bad overcomplicated solution though. It must be some way of getting around the problem with the 255 char problem. In the FM manuals it says that it can handle over 60.000 chars, but it seems that the problem lies in that FM have really crappy ODBC support. Anybody else that have ben stuck with this problem too? /Jonas

Are you trying it on a local machine or over the network via IP? I have done it locally, and the solution is pretty simple. Using ODBC, define the connectionstring like this: ODBCConnStr1_FM = "Driver={FileMaker Pro};" & _ "Dbq=;" & _ "Uid=;" & _ "Pwd=yourpassword;" Note that my solution does not use a odbc data source, but instead crates one at runtime. However, it is pretty much the same principle of passing the password if you use an odbc data source. /Jonas

Hi! I am developing a VB application that puts data into filemaker. I have encountered a problem that I believe is a FM ODBC driver bug. Hopefully someone else will know about this and be able to provide me with a solution. This is the problem: When I try to install a value into a FM text field, and the value is longer than 255 chars, the string gets chopped off, taking away everything after the first 255 chars. I run filemaker 5, but I have installed the 5.5 ODB drivers since the 5 one was so buggy. In great need of a solution for this! Thanks /Jonas