Collect data from two fields and print on one field

Scriptcase 9
#1

There is data in two fields. like id and code. I can combine these two and print to another field but it is not registering in the database. For example id=10 code=B. I want it to write 10B in another field. I’m printing it but it’s not registering in the database.

#2

In your query you can use the function Concat(FIELDA,FIELDB) as Result

#3

this was not self explanatory for me, can you write the code for me please. Thank you

#4

Please, can you show me your query when you going to print?

#5

i can see together but not in database
onload events

{sp_reference} = {sp_code}.{ref_no};

001
001806×67 9.42 KB
002

#6

Create a view in your database, based on your table. Add an extra field like…

SELECT
sp_code,
ref_no,
,
CONCAT(sp_code, ref_no) AS result
FROM yourTable

Then base your SC app on this view. Now you can use the result field which will have the other two fields joined together.

2 Likes
#7

thank you for your reply