| Author |
Messages |
|
olie04
Posts:33
 |
| 05/06/2010 12:28 PM |
 Alert
|
| We use the CustomDate1 field for our rewards customers for expiration of their rewards card. Is there anyway possible to auto-populate that field so that the clerks don't have to worry about typing in the date for a new customer?
I tried setting the fields' DEFAULT value to getdate(), but the date still shows 12/30/1899, and it doesn't add the current date. What I would love to do is do a dateadd('yyyy', '1', getdate()) but I am just trying to get the getdate() function working for the default value.
Any insight on this would be greatly appreciated!
TIA! |
|
|
|
|
morzo23@yahoo.com
Posts:1
|
| 05/25/2010 6:17 AM |
Alert
|
Hi Olie04, there are two ways you can do this (if I have understand exactly what you want to achive): first, by SQL, creating a stored procedure, that will update the field, when something exactly happends with the Customer, playing with the Customer.[ID] field as a variable or, create a small add-on, a dll or a .exe file that will update that field, again based on Customer.[ID] field...
Hope this helps and gives you more ideas...
Regards, A. |
|
|
|
|
olie04
Posts:33
|
| 05/25/2010 8:17 AM |
Alert
|
Posted By morzo23@yahoo.com on 05/25/2010 6:17 AM
Hi Olie04, there are two ways you can do this (if I have understand exactly what you want to achive): first, by SQL, creating a stored procedure, that will update the field, when something exactly happends with the Customer, playing with the Customer.[ID] field as a variable or, create a small add-on, a dll or a .exe file that will update that field, again based on Customer.[ID] field...
Hope this helps and gives you more ideas...
Regards, A.
Thanks for the reply! I will most definitely look at the stored procedure option, maybe using a trigger?
I am on the road to learning C# right now, so making .dll & .exe files will soon be available to me, however, I do not know the first thing to when it comes to programming for RMS. I am not a developer, but would definitely love to know how to get the resources on it, etc.
I do mostly PHP/MYSQL programming, and I am very fluent at that, but trying to join the Microsoft brigade, I am just lost. C++, C#, Netframe works, etc.
I downloaded Visual Studio 2010 for C#, and I know how to make buttons, and text objects, but I havent the slightest clue on how to incorporate that into RMS.
|
|
|
|
|
olie04
Posts:33
|
| 05/25/2010 9:48 AM |
Alert
|
Posted By morzo23@yahoo.com on 05/25/2010 6:17 AM
Hi Olie04, there are two ways you can do this (if I have understand exactly what you want to achive): first, by SQL, creating a stored procedure, that will update the field, when something exactly happends with the Customer, playing with the Customer.[ID] field as a variable or, create a small add-on, a dll or a .exe file that will update that field, again based on Customer.[ID] field...
Hope this helps and gives you more ideas...
Regards, A.
Just a small update. I figured out how to use a trigger, and like magic whenever a new customer is inserted, it automatically adds 1 year and sets the price level.
Thank you for pointing this out! It works great! |
|
|
|
|
|