K
kirchner
Guest
Yep, I've done that before and tried it again in 11.7.2 right now. This is the statement sent to the database after updating the database: SELECT "cust_num", "pais", "name", "address", "address2", "city", "state", "postal_code", "contact", "phone", "sales_rep", "credit_limit", "balance", "terms", "discount", "comments", PROGRESS_RECID, PROGRESS_RECID_IDENT_ FROM "sports"."sports"."cliente" ORDER BY "cust_num" Notice the second field "pais", the portuguese word for Country (actually there is a acute accent on the I when you write it properly), and the table name is "cliente". It was a standard sports.customer table before. The very same r-code. The schema name also comes from the Schema Holder, from the "FOREIGN OWNER" atribute. The database name is more complicated because you connection parameters, your ODBC settings and your "QUALIFIER" in the SH can influence it.
Continue reading...
Continue reading...