Hi
I have to create a report to convert data in the CODE Field from Lower case to UPPERCASE as I have some bad data . This has occured as the data was entered from SQL not from the Navision Client.
Can anybody help me out how to access the Fields in a Table with Data type "CODE" and to loop through all the tables as I have multiple tables with bad data.
Thx in Advance.
0
Comments
Next you need to find the fields that are of type code to do this create a new tabular form. set the source table to field. select all the fields from the virtual table fields. Run the form. Filter on table ID and filter on Type = Code.
Then open enterprise manager.
and write the following sql statement
in the above sql statment
NavisionSP2 is the company name and table name
test and secondtestfield are code fields.
Good luck.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
It worked for one table.thx a lot.
I have a problem sorting the tables as I have more than 200 tables to sort based on CODE Field.
How can I implement the above for all the Tables containing CODE Field in SQL?
Thx in Advance.
Who ever did this, inserting data like that should taken out to the woods and hmm should be left in there.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I tried creating a report in Navision client which was of not much help.
Is it the same to run a report in Navision Client to Change the Code Field to UpperCase and doing the same by writing a query in SQL? I need some help with the query.
thx in advance.
Here is an idea. Write a report in navision that will create a text file that will consist of sql statements for all the tables and fields?
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I could not sort the fields by datatype as the datatype for code,text is varchar in SQL. I am a bit confused how to sort.
Can anybody help me out with the SQL query to sort the code fields and change them to uppercase. ](*,)
thx in advance
update [NavisionSP2$Customer]
set test = upper(test)
This statement changes the field test to uppercase.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
You got me wrong Rashed.
I guess u missed my response for the code u sent to me.It worked for one table.I am just wondering how to ,as I have more than 200 tables and each table consisting of multiple Fields with the datatype CODE.
I need to write a query to loop around all the tables and fields with Datatype=CODE and convert them to uppercase.
Thx in Advance
I will create a table and a form, that will generate the sql statement. Once I get free time.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
here is the report. This report will dynamically create the sql statements for all navision tables that contain code fields and will change them to uppercase. Simply import it and compile it.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I owe u 1.
I love playing the game sudoku so I named my ID after it.
will get back to you soon with some new issues.
=D>
Thx a lot.
sudoku
http://www.BiloBeauty.com
http://www.autismspeaks.org