hello everybody,
we use sapdb 7.3 with odbc 7.3 and access 2000 as front-end. The
database is currently running on a win-xp but the final database will
run on a linux-system.
1) Differences linked tables <-> ADO
Some of us mentionded that carriage return and line feed is not saved.
This ist true and false.
If you use linked tables and connect the database by
form![formname].recordsource = "SELECT ...." and afterwards you edit a
linked field in access and type in CR/LF than everything is saved.
BUT if you use a ADO-Connection (ADODB.connection as
database-connection, ADODB.command for executing the SQL-statement)
with SQL UPDATE or INSERT statement, than the CR/LF is thrown away.
(ADO-version 2.6). Same in SQL-Studio !
Die database field is defined as varchar(xx) ASCII.
Any hints ??????
2) To find a solution I tried the following:
With a first insert statement i added a new record to the table without
any varchar-field. In the second step i run a SELECT to get the formely
added record and tried the method recordset.edit (recordset is defined
as ADODB.recordset). But, surprise, edit does not exist. So i tried the
method recordset.movefirst because my query used a primary key so only
one record was in that recordset. I changed the values for the
varchar-fields, send recordset.update AND THE NEWLINES where SAVED !
3) The SERIAL-Type
It�s a nice type but of now worth. If you use this type as a primary
key, then access is not able to update linked-tables using this type.
Very sad, because in postgreSQL this is working correct. My workaround
was to use a table for the next value for every auto-increment field.
This not a big problem, because the workaround is working properly.
I hope, anybody has some ideas and can help me, especially to my first
ADO-Update/Insert-problem with the newline.
Oliver Br�ker
=========================
Br�ker & Laskowski GmbH
[EMAIL PROTECTED]
http://www.B-L.de
=========================
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
