Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
where are my carriage returns/linefeeds? |
Author |
Message |
|
Posted : 2007-09-12 05:05:41 |
Hello. We are bringing data into MS Access from linked QODBC tables.
We noticed that the carriege returns/linefeeds are lost from Invoice Line MEMO fields.
Is there a solution for this?
Thank you
Chris.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-09-12 08:35:53 |
The REPLACE function can be used in MS Access like this to replace the linefeeds (DEC 10) returned by QODBC with carriage return/linefeeds (DEC 13, 10):
DoCmd.RunSQL _ "INSERT INTO Local_ItemInventory ( Part, Description, QuantityOnHand ) " & _ "SELECT Name, replace(PurchaseDesc,chr(10),chr(13) & chr(10)), QuantityOnHand " & _ "FROM ItemInventory " & _ "WHERE IsActive=Yes" |
|
|
|
|