February 6, 2013 at 9:27 am
JohnPapa (2/6/2013)
In the recordset the RV value is not Null, nothing prints when you try to print the value and the field is empty on the form. I will look into this a bit more.
Then you're going to have to sit and debug and research. Not a SQL Server issue there.
What do you think about using, instead of the RV field, a DATETIME2 field with SYSDATETIME() entered in it?
Needs a trigger, otherwise won't get updated when the row changes. Rowversion is automatic, datetime is manual.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 6, 2013 at 2:06 pm
JohnPapa (2/6/2013)
Gail, there is no need to display it, I just need to know the value. In the recordset the RV value is not Null, nothing prints when you try to print the value and the field is empty on the form. I will look into this a bit more.
Maybe your FE has difficulty displaying (or printing) whatever array variant varbinary(8) data (or binary(8) if the column was declared not null) turns up in VBS as.
I'll refrain from giving in to my hatred of VB and suggesting you ditch VB and switch to either C# or Jscript.
Tom
February 6, 2013 at 2:45 pm
L' Eomot Inversé (2/6/2013)
I'll refrain from giving in to my hatred of VB and suggesting you ditch VB and switch to either C# or Jscript.
It's an MS Access form, so VBA's the only choice.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 6, 2013 at 11:44 pm
Gail thanks again, Tom merci,
Switching to c# or something else is easier said than done and as Gail mentioned, not an option in this case.
ROWVERSION is the right way to go and I will investigate further.
John
February 7, 2013 at 8:01 am
GilaMonster (2/6/2013)
L' Eomot Inversé (2/6/2013)
I'll refrain from giving in to my hatred of VB and suggesting you ditch VB and switch to either C# or Jscript.It's an MS Access form, so VBA's the only choice.
Perhaps Tom is also suggesting you ditch MS Access? :hehe:
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 7, 2013 at 8:30 am
Thanks for your input. Unfortunately ditching Access is not an option for the specific project.
February 7, 2013 at 1:04 pm
jcrawf02 (2/7/2013)
Perhaps Tom is also suggesting you ditch MS Access? :hehe:
No, through being so fortunate as to have avoided having to learn about it I know far too little about MS Access to have a view on it (and hope I can keep things that way, because I like MS SQLServer far too much to want to switch horses). :w00t:
Besides, I didn't actually suggest he switch from VBA, because I was fairly sure that it wouldn't be a realistic option. Switching language is sometimes the right thing to do, but a problem with displaying particular data is not really a good indication that this is one of those times (despite the awfulness of the current language).
Tom
February 8, 2013 at 12:13 am
Tom many thanks for your comment.
Since you have not dealt with Access extensively and at the risk of repeating things that everyone knows please note the following from someone who has been dealing with Access for many years. Access is not a db. It is a software development tool. It so happens that in MS Office, it is bundled with a db called JET/ACE. In place of JET/ACE you can have SQL Server, Oracle or any other db. The Access/Jet/ACE combo has many advantages, like ease of deployment, development, debugging, speed and disadvantages like security and multi-user issues. It depends on the application. In my case (www.VisualDentist.com) Access/Jet is a good choice based on the advantages above. As you can surely appreciate, it depends on the project.
Having said the above and based on your comments, I have been looking into using another FE with SQL Server.
John
Viewing 8 posts - 31 through 37 (of 37 total)
You must be logged in to reply to this topic. Login to reply