Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
Basic SELECT missing character in field data |
Tue, Oct 9 2007 12:18 AM | Permanent Link |
Phil Read | Hi Tim,
This has me scratching my head. I have a table called trans_history with numerous fields. 1 of the fields is called gl_code and is a String type 20 in length. When I view the table the gl_code fields show correct data. But when I run a simple query: "SELECT * FROM trans_history" Its removing the an A character from the fields data. For example the table shows this: gl_code --------- A101 A102 A101 A101 A102 Z101 R101 Run a query "SELECT * FROM trans_history" and get this: gl_code --------- 101 102 101 101 102 Z101 R101 Where me 'A' gone? It's just removed the A's for no reason, although it left the 'Z' and 'R' Any ideas? Thanks, Phil. |
Tue, Oct 9 2007 12:22 AM | Permanent Link |
Phil Read | IGNORE THIS POST!!! PROBLEM SOLVED
|
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |