Default Barcode Setting

Hi Alex, it akber again, I have already posted this and again posting for you. you can create the database level trigger to accomplish this

CREATE TRIGGER UpdBarcode ON Item FOR INSERT AS

UPDATE Item SET Barcodeformat= 3 FROM Item INNER JOIN Inserted ON Item.ID= Inserted.ID

in the above line you can give any element of format I given 3 which is the

I hope you know how to do this. please rate this.

"Alex" wrote:

Thanks Akber I appreciate the help. This was a suggestion to enhance RMS. I think most people (for good reasons) would like to stay away from adding database triggers and doing behind the scenes modifications to avoid any potential (future) conflicts.

From what I have seen most everybody consistently uses the same barcode type as well as for example the same item taxes. So if we can default any respective settings/fields this would be great and save time and avoid mistakes. I know you can set a default tax for items so why not apply this to Barcode Type and other fields as well?

P.S. Why do you request your post to be rated, and how do we rate you?

Thank you for your suggestion on default barcode types. We are considering this for future versions.

This postNeed to have the option to be able to set a default Barcode (type) so we don't have to set this everytime we create a new item.

---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.

Hi. I have SQL express on the machine to manage the DB we have here and I have the default barcodeformat = "8" (Code128).

However I cannot get the SQL query to run. Please let me know if you can get me some more help.

-Andrew

"Akber Alwani" wrote:

Akber et al,

Just what I needed, however, how do I 'update' / 'change' the trigger as you've set out below.

You will have to forgive me, I know what triggers are but I do not know my way around SQL (yet).

In short, I would like to amend an already created trigger. I would like to change:

UPDATE Item SET Barcodeformat=3 UPDATE Item SET Barcodeformat=6 (for 128A)

Cheers.

Ryan

Akber Alwani wrote: