TWO PART QUESTION:
(1)I use a SAVEREC function to add a new record for all my forms. However, the problem I am having is that
I am getting this error message (on some forms),
Connectivity error: [Microsoft][ODB SQL Server Driver][SQL Server]Cannot insert an explicit value into a timestamp column. Use insert with a column list to exclude the timestemp column, or insert a DEFAULT into timestamp column.
I know that this is asking me to use INSERT instead of APPEND BLANK, but if this is centralized how could I do this? Or i guess I could insert into the TIMESTAMP a default, I do this a the back-end or at VFP?
(2)BTW, what is this timestamp column for? Does it get updated by VFP or SQL05. I think this was added during upsize.
FUNCTION saverec
IF m.adding
APPEND BLANK
m.adding = .F.
ENDIF
m.editing = .F.
GATHER MEMVAR MEMO
SHOW GET m.newrecord ENABLE
SHOW GET m.saverecord DISABLE
SHOW GET m.cancel DISABLE
SHOW GET m.next ENABLE
SHOW GET m.prev ENABLE
SHOW GET m.delrecord ENABLE
SHOW GET m.browse ENABLE
SHOW GET m.find ENABLE
SHOW GET m.quit ENABLE
UNLOCK IN 1
_CUROBJ = 1
SHOW GETS
RETURN
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
If you want to track when a user makes a change or adds a new row, they are helpful. But, if that is too much information or overkill, you don't need them. I thought you hinted you wanted that information in a previous message a week or two ago. It's not necessary to have that information. But, again, it's up to you as to how important it is to know when something was added or changed.
Normally, I don't track that kind of thing in my apps because it is overkill. Occasionally, I do track it only to group things together as a batch where a certain session's transactions can get tracked together and limited to a specific report. One example might be someone shipping items from an order. if the order allows for a partial shipment, you can allow a smaller group of items to get printed and labelled in the database as being shipped. With the date/time stamp, those items will show as being shipped at a specific moment. If an item comes in right after that shipment and still can be shipped the same day, then that partial shipment gets a newer, but different, date/time stamp for that day, and still allows a printout that shows just that one new item for that same day with the later time portion being the new batch identifier. If I didn't have the time in there, all of the items for that day would shgow up for today's date. Of course, I wouldn't want the previous items that were already labelled as shipped, just the latest ones. And, I could have used a simple batch identifier as well which would just assign a number for each day's shipments. In this case, I chose to use the date/time stamp to nail down when a day's work was marked as shipped in the system.
I hope this gives you some explanation as to why you might or might not use the date/time stamp for anything.
Business Accounts
Answer for Membership
by: epicazoPosted on 2006-10-04 at 07:12:29ID: 17659531
FYI:
I am using remote views to connect to SQL server 2005.