Search found 5 matches

by Tarak
Thu Jul 18, 2019 6:34 am
Forum: Label Design & Printing
Topic: Renaming table columns
Replies: 6
Views: 412

Re: Renaming table columns

Hi Kyle,

Thanks again for all your help, I managed to figure it out, I killed 2 birds with one stone, I managed to rename the columns and trim the values using the following SQL commands:

RTRIM([jmpJobID]) as "Job ID", RTRIM([jmpPartID]) as "Part ID"

Thanks again :D
by Tarak
Fri Jul 12, 2019 11:03 pm
Forum: Label Design & Printing
Topic: Renaming table columns
Replies: 6
Views: 412

Re: Renaming table columns

Hi Kyle,

No worries.
by Tarak
Fri Jul 12, 2019 9:14 pm
Forum: Label Design & Printing
Topic: Renaming table columns
Replies: 6
Views: 412

Re: Renaming table columns

Hi Kyle,

Thanks for the response, I tried the Alias field, but that only seems to rename the field in the tree, the column name in the table still remains the name that is pulled from SQL. :-k
by Tarak
Thu Jul 11, 2019 12:36 am
Forum: Label Design & Printing
Topic: Renaming table columns
Replies: 6
Views: 412

Renaming table columns

Hi, When I preview my form, the table columns are a lot wider than they need to be because of the column name, is it possible to rename the column names in an SQL connection? This is part of the SQL code: SELECT [jmpJobID], [jmpPartID], [jmpPartShortDescription] I thought I could use something like ...
by Tarak
Wed Jul 10, 2019 11:18 pm
Forum: Label Design & Printing
Topic: Concatenate, how to TRIM blank spaces
Replies: 1
Views: 214

Concatenate, how to TRIM blank spaces

Hi all, I'm just created a new label and and connected to an SQL database, I used the concatenate function to join 2 fields, but in the preview it looks like this: 654 A (it's actually got about 10 spaces in between, but I couldn't show that here, it would only let 1 space show) , how can I trim the...