Matthew Jarvis wrote: > Vince Teachout wrote: > <snip> > >> No, but the "God, this is boring - I wonder if I can automate this" >> function "MSSqlMe() I wrote about 4 years ago to rewrite VFP tables into >> MSSql tables is certainly coming in handy! :-D >> >> > > Vince- > > That sounds like it could be handy - care to post the code?
I've been thinking about posting my ME() functions for some time: SqlMe() - creates a SQL Select statement in the clipboard for the current WA, with several options InsertMe() - Creates a Insert statement in the clipboard, with several options, and also creates the VALUES clause with a leading character that indicates what kind of data is expected. Plus, bonus, it sounds naughty. CurseMe() - creates a FILE containing a CREATE CURSOR statement for current WA, with lots of options MySQLMe() - Creates a MySQL CREATE TABLE statement, etc... MSSQLME() - Creates a MS SQL CREATE TABLE statement, and IIRC, creates the ALTER Table command for the Primary index, and the index commands for the other indexes MyAccessMe() - ditto for Access ORASQLME() - ditto for Oracle OraDate() converts a vfp date to Oracle TO_Date command for use in queries: e.g. OraDate(date()) =" To_Date('12/14/2006','MM/DD/YYYY')" NvlSQLMe() - creates a SQL Select statement in clipboard with all fields NVL'd: SELECT NVL(Spons_uid, '') AS Spons_uid... etc... WaitGlass() - turns hourglass cursor on/off These things save me hours of time doing repetitive, boring coding. If there's any interest, let me know and I'll e-mail code to whoever wants it. If people STILL think it's useful after getting and trying the code, let me know and I'll talk to Ed about putting it in the downloads section. _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.