FileMaker Server Advanced
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I'm currently working on a project that use FileMaker Server and SQL Server 2000. On a button click, I sometime need to migrate data from SQL to FileMaker. So far everything is fine. But now the problem is with decimal values. Currently I just do a replace of (,) to (.). But FileMaker use . as a thousand separator ... So I try to send [34,78] as a value (the SQL statement is generated automatically and by no means we can use parameter), and the ODBC driver return an SQL Parser Error on this value. So is there a way to send the (,) in an SQL statement without returning a parser error ? Thank you very much !! By the way, the ODBC driver is SEQUELINK 5.4 My Blog -- modified at 11:15 Friday 21st October, 2005