Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to bring a field into QV but instead of bringing me the values, it transforms half of them into numbers(or date). Here is what I mean:
How can I keep the format on the left?
Thank you
Change the alignment on the Presentation tab of the object properties. Or in the script use the text() function to load the field as text:
Load
text(MyField) as MyField
from ...somewhere...;
Are you reading from xls file? can you provide it?
I am reading the data from a .dbf file (fox). I cannot copy or even access it outside of QV. The data should all be the same, but I cannot vouch for it. I will try to get some rights to access the database tomorrow . I think I will repost then. Thank you anyway for your help.
Change the alignment on the Presentation tab of the object properties. Or in the script use the text() function to load the field as text:
Load
text(MyField) as MyField
from ...somewhere...;