mrgmhale wrote: > The space padding is an issue I ran into using ODBC to connect to a M$ > Access database table a few years ago. The designers of the VB app that I > was passing converted data to had a textbox of limited width, and right > justified and no value trimming. I will pulling a PartNo field from an > Access table via ODBC connectivity, performed a conversion on the PartNo > value, then sent the converted value to a target Access table used by the VB > app to import various data, including my converted PartNo data. With the > ODBC padding the PartNo value was getting pushed out of the display width > limitation of the right justified textbox. When I researched to cause of > the problem I found that ODBC intentionally performs the padding, and there > was no way around it. The VB app was eventually altered to populate the > offending textbox with a trimmed PartNo imported value, and a left justified > format - although the programmers had insisted right up to the end it was a > problem caused by me (cuz that crazy assed FoxPro stuff is a dead language, > you know!). When I finally gathered the documentation from M$ showing it > was an intentional design for ODBC to work properly they ceded the point and > "fixed" what I deemed to be a poor interface issue on their part anyway > (lazy assed programming). > > So, unless something in a very basic concept in ODBC design has changed in > the past 6 years or so, then no, the padded values will not go away. I hate > being the bearer of bad tidings... But, I guess someone has to do it <g>... >
Don't you just hate it when they label your app as the problem merely because it's Foxpro? BASTARDS!!!!! -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
