SYS(2015)

2015-03-31 Thread Laurie Alvey
Anyone know how to reverse engineer this function so that you get a datetime value? Laurie --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com

Re: SYS(2015)

2015-03-31 Thread Christof Wollenhaupt
Anyone know how to reverse engineer this function so that you get a datetime value? Here's the C# version that generates a SYS(2015) value. It's three characters for the year/day and six for the milliseconds within the day:

RE: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Virgil Bierschwale
When I was active, this was how I stayed up on software https://mspartner.microsoft.com/en/hk/pages/membership/action-pack-subscribe .aspx -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, March 31, 2015 3:49 PM To:

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
Can't afford it for this project. All I need to do is restore a backup and export data from the database. Thanks, On 3/31/2015 1:52 PM, Virgil Bierschwale wrote: When I was active, this was how I stayed up on software

Re: FoxPro/DOS 2 Lines per record in a browse?

2015-03-31 Thread American Sentry Systems, Inc.
I tried: change fields fieldname1+' '+fieldname2+ , fieldname3 I got a unrecog phrase/keyword in cmd error by the way, I am running 2.6 if that is material John On 03/25/2015 04:44 PM, Ted Roche wrote: I'd forgotten about CHANGE! I believe EDIT is a synonym. Clever work-around! On Wed,

Re: FoxPro/DOS 2 Lines per record in a browse?

2015-03-31 Thread Ted Roche
Not sure the help is all that helpful when it comes to everyone once knew this. Try: change fields fred=fieldname1+' '+fieldname2+ , fieldname3 Essential, you're creating a calculated field, fred. It doesn't have to be named that, but it always worked for me :) On Wed, Mar 25, 2015 at 8:27

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
That link takes me to Amazon and SQL Server 2014 for $49.00. Can I restore a backup of 2008 R2 into this? The $49 is okay by me. On 3/31/2015 2:06 PM, Ted Roche wrote: Jeff: FREE should be the price: http://leafe.com/archives/full_thread/498425 On Tue, Mar 31, 2015 at 4:48 PM, Jeff

InfoWorld mention of FoxPro

2015-03-31 Thread Ted Roche
Former Byte columnist, Microsoftie and New Hampshire resident Jon Udell posts a blog entry on InfoWorld: Wanted: Easy database app dev tools for the Web Programming languages, application frameworks, SQL or NoSQL databases, data-binding mechanisms, templating libraries -- they're all up for

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
Thanks Ted. Stephen must be absent today. We miss you when you aren't here. ;^) On 3/31/2015 2:28 PM, Ted Roche wrote: I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Ted Roche
Or the SQL Server express 2008 R2 edition, which is what you asked for initially! http://www.microsoft.com/en-us/download/details.aspx?id=30438 Surprised to see these still available. On Tue, Mar 31, 2015 at 5:33 PM, Ted Roche tedro...@gmail.com wrote: I should be here less often :) If the

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
Database is large. Thanks and you better not go anywhere! On 3/31/2015 2:35 PM, Ted Roche wrote: Or the SQL Server express 2008 R2 edition, which is what you asked for initially! http://www.microsoft.com/en-us/download/details.aspx?id=30438 Surprised to see these still available. On Tue,

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Ted Roche
I should be here less often :) If the database isn't huge, you could probably get by with SQL Server Express: http://www.microsoft.com/en-us/download/details.aspx?id=29062 On Tue, Mar 31, 2015 at 5:32 PM, Jeff Johnson j...@san-dc.com wrote: Thanks Ted. Stephen must be absent today. We miss

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
I need the enterprise manager (or whatever it is called now) software because I don't have time to learn to manipulate express. Thanks, On 3/31/2015 2:53 PM, Richard Kaye wrote: Large is a relative term, Jeff. Does it exceed the capacities of the current Express version? If not, you should

Re: FoxPro/DOS 2 Lines per record in a browse?

2015-03-31 Thread Michael Glassman
This is an example of FoxPro’s (both DOS and Windows) inconsistency and quirkiness. Calculated columns in BROWSE, CHANGE, and EDIT commands must always be assigned to a new variable name. Calculated columns in LIST and DISPLAY statements must NOT be assigned to a new variable. Just to keep

RE: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Richard Kaye
SSMS = SQL Server Management Studio. This is actually the 2008 R2 version I just found. http://www.microsoft.com/en-us/download/details.aspx?id=22985 And then there's the 2014 download but it's not 100% clear to me if this is time limited in any way since the page refers to eval.

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Ted Roche
I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was discussion here on a FREE developer edition, but now I can't locate that thread. $49 seems like a reasonable deal. I would

RE: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Richard Kaye
Large is a relative term, Jeff. Does it exceed the capacities of the current Express version? If not, you should be able to just get that. And one change over time is they also make SSMS available to Express users. It used to be SSMS was not available so you got the engine but not the dev

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Ted Roche
Jeff: FREE should be the price: http://leafe.com/archives/full_thread/498425 On Tue, Mar 31, 2015 at 4:48 PM, Jeff Johnson j...@dcsoftware.com wrote: I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make

[NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make heads or tails of it. I purchased an earlier developer version of SQL Server and it fit my needs perfectly. Can someone tell me the least expensive way

RE: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Dan Covill
A couple of days ago I stumbled over this: https://msdn.microsoft.com/en-us/library/hh510202.aspx It's a new form of SQL Server Express called LocalDB, and is supposed to reduce required complexity and overhead for software developers/testers. Looks good but I haven't investigated further.