General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Fixing field length in SQL Select command
Is it possible to set the field lenght of a field when using the SQL Select command. What I need to do is insert 4 lines into a table based on existing values in the table and calculated values. The fourth line is the sum of the first three lines. Number of fields is dynamic so I am using macro substitution to create the lines. In the original table the format of the numeric fields is 12. When I do my Select commands I get different lengths for the fields. Is there any way around this?
I am thinking of using arrays. I there is an easy way to print the values of the arrays? How about adding them (short of the brute force method of a For loop).
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only