Viewing 13 posts - 16 through 28 (of 28 total)
Thanks PietLinden. This seems very simple and easy to implement.
I will play around with it and see how I go.
thanks
February 11, 2019 at 10:14 pm
Hi Mark. that's Interesting. Thanks for the tip. I'll look into it. For example can i create the table with the 0 value as the default?
Thanks again.
Cheers
November 7, 2018 at 2:16 pm
Thanks to all those responded.
I solved the issue by altering all the bits fields to TinyInt fields. This them solved the write conflict issue, but created an issue...
November 6, 2018 at 2:34 pm
Thanks for the warning Lynn.
As I said, I want it to work before I make it pretty. So far, I have not found a method that does what I...
October 23, 2018 at 8:25 pm
Thank you pietlinden, but in both of those examples, you are required to provide a SourceString and a TargetString. The point of my requirement was to collect a target string...
October 23, 2018 at 6:11 pm
It's part of a wider series of functions.
I have a table which produces around 10 records, each is a mispelt name. I need to compare each of these...
October 23, 2018 at 5:04 pm
Thanks Lynn,
I understand this is how to select a column. I'm interested in learn how to incrementally select each record in that column... that is, to return the value...
October 23, 2018 at 4:45 pm
Thank you for your response.
I had thought something like this, but am getting the error 'Invalid attribute/option identifier'
Wait a second! Stop everything! Hold the phone! The input...
October 16, 2018 at 10:21 pm
Thanks all who responded.
Unfortunately, there is a requirement for the Bit fields to be null as the default. However, I modified the fields to [Smallint] and that seemed to...
August 22, 2018 at 4:44 pm
Thanks to all who responded.
I have learned that ADO is the best option. It works just fine. I wanted to avoid it because so much of my Db...
August 15, 2018 at 4:27 pm
Thanks again Johnathan for your quick response.
Unfortunately this is not generating a value in my messages window and not applying a PK to any table, even if I switch...
July 31, 2018 at 6:26 pm
Thank you Johnathan.
This seems awesome!
The problem is I ended up having to manually create the PK on all tables, which took ages. so to run this,...
July 31, 2018 at 5:28 pm
Thank you all for your replies!
TripleAxe - this is exactly what I was looking for, thank you. I presume I can use this with the exec command and...
July 31, 2018 at 4:56 pm
Viewing 13 posts - 16 through 28 (of 28 total)